Business Technical Analyst Undergraduate Summer Intern
About The Position
The intern will analyze existing business intelligence data flows, trace dashboard dependencies from SQL Server to their original sources, and identify opportunities to migrate or route reporting data directly to Snowflake. The intern will document data lineage and migration requirements, collaborate with business and technical teams, assist with implementing and validating an end-to-end Snowflake pipeline, and present recommendations for future migrations. The role also provides exposure to processes and functions in the Managed Care industry. The intern will contribute to projects supporting the business, apply academic knowledge, learn new skills, research topics relevant to the functional area and industry, and attend training and development presentations to enhance professional competencies. Other duties may be assigned, and the intern must comply with all policies and standards.
Requirements
- High school diploma or equivalent.
- Must be enrolled in an undergraduate program at an accredited university or college through the internship period.
- Must be authorized to work in the U.S. without current or future employment-based visa sponsorship.
- Analytical, curious, organized, and comfortable solving problems.
- Strong communication and collaboration skills with business and technical teams.
Nice To Haves
- Enrollment in a field related to the hiring department is preferred.
- Coursework or experience with databases, SQL, reporting, or data analytics is preferred but not required.
Responsibilities
- Analyze existing BI data flows.
- Trace dashboard dependencies from SQL Server to their original sources.
- Identify opportunities to migrate or route reporting data directly to Snowflake.
- Document data lineage and migration requirements.
- Collaborate with business and technical teams.
- Assist with implementing and validating an end-to-end Snowflake pipeline.
- Present recommendations for future migrations.
- Contribute to projects that support the business and learn about processes and functions within the Managed Care industry.
- Research legal, regulatory, and other topics within the functional area and industry.
- Attend training and development presentations.
- Perform other duties as assigned.
- Comply with all policies and standards.
Benefits
- Competitive pay
- Health insurance
- 401K and stock purchase plans
- Tuition reimbursement
- Paid time off plus holidays
- Flexible approach to work with remote, hybrid, field, or office work schedules
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Intern
Education Level
High school or GED
