FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Business Intelligence Intern, Information Technology
ServiceLinkBusiness Intelligence Intern supporting migration of legacy reports to cloud-based data architecture. Collaborating with BI engineers on data modeling and analytics tasks.
Tech Stack
Tools & technologiesCloudSQL
About the role
Key responsibilities & impact- Support the migration of legacy SSRS reports to a data lake-centric analytics architecture
- Analyze existing SSRS report logic, stored procedures, datasets, and dependencies
- Re-create report logic using SQL, data lake structures, and modern semantic models
- Design and implement semantic layers (Power BI datasets, tabular models, or equivalent) optimized for reuse and performance
- Assist with data model normalization, star schema design, and metric standardization
- Validate migrated reports and datasets for data accuracy, performance, and completeness
- Document source-to-target mappings, transformation logic, and modeling standards
- Collaborate primarily with BI engineers and architects; limited to no direct business user interaction
- Gain hands-on experience with enterprise BI modernization initiatives
- Apply academic knowledge to large-scale, real-world data systems
Requirements
What you’ll need- Undergraduate Junior, Senior, or Graduate status in Computer Science, Information Systems, Data Analytics, or related field
- Strong interest in data engineering, analytics platforms, and BI architecture
- Solid understanding of SQL, including joins, aggregations, and query optimization
- Familiarity with relational data models and dimensional modeling concepts
- Exposure to or interest in data lakes, analytics platforms, or cloud data services
- Experience with Power BI, SSRS, or other reporting tools (academic or internship experience acceptable)
- Strong analytical and problem-solving skills
- A desire to work on focused, independent technical projects
- Attention to detail and commitment to data quality and design best practices
Benefits
Comp & perks- Health insurance
- Vision insurance
- Dental insurance
- Life insurance
- 401(k) plans
- Employee Stock Purchase Plan
- Paid vacation
- Sick time
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLdata lake structuressemantic modelsstar schema designdata model normalizationreport logicquery optimizationdata accuracy validationtransformation logicdimensional modeling
Soft Skills
analytical skillsproblem-solving skillsattention to detailcommitment to data qualityindependent work