Data Analyst / ETL Developer
Full Job Description
Role Overview
We are seeking a Senior Data Analyst / ETL Developer for the Office of Retirement Services (ORS) based in Lansing, MI. As a contractor on this 12-month assignment with extension potential, you will lead data migration efforts and optimize infrastructure using Microsoft Azure technologies.
Key Responsibilities
- Data Pipeline Design: Develop scalable pipelines using Microsoft Azure services, focusing on profiling, cleansing, validation, and quality resolution during large-scale migrations.
- Root-Cause Analysis: Identify data irregularities and implement approved solutions to ensure integrity.
- Requirements Gathering: Engage stakeholders to align data initiatives with ORS objectives.
- SQL Expertise: Leverage strong SQL/T-SQL skills, specifically within Azure SQL Managed Instance, for effective transformation.
- Data Integration Workflow Design: Create complex workflows supporting modernization from 20-year-old packages to new products.
- Migration Leadership: Execute data mapping and migration from on-premises solutions to cloud databases (Azure Data Factory).
Methodology & Collaboration
- Agile Practices: Actively participate in sprint planning, stand-ups, and iterative development.
- Mentorship: Guide junior developers on data profiling and source-to-target mapping.
Data Management Knowledge Required
Familiarity with Master Data Management (MDM), Metadata Management, Information Lifecycle Management (ILM), and Data Governance is essential to maximize efficiency and quality.
Qualifications
- Bachelor's degree in a related field or equivalent experience.
- 6+ years of experience as a Data Analyst / ETL Developer with Microsoft Azure, Azure DevOps, Git, CI/CD, SQL/T-SQL, and ADF/Microsoft Fabric.
Company
GSK Solutions Inc.
GSK Solutions Inc., located in Lansing, MI, supports critical government initiatives through data infrastructure management and modernization efforts within the Office of Retirement Services (ORS). As...
Practice this interview
A voice mock interview for Data Analyst / ETL Developer (Hybrid Onsite) at GSK Solutions Inc., with questions from this job description and your resume, and a scored report afterwards.
Set up interview