Back to Jobs
Recently postedTechnology

Data Analyst / ETL Developer (Hybrid Onsite)

GSK Solutions Inc.Lansing, MI🇺🇸United States

Quick overview

Work modeOn-site
LocationLansing, MI, United States
Stakeholder ManagementSQLT-SQLGitETLAzureAgileCI/CDAzure DevOpsAzure Data Factory

Job description

Job Title

Data Analyst / ETL Developer (Hybrid Onsite)

Location

Lansing, MI

Duration

12 Months

Interview Type

In-Person

Note

  • Additional Requirements: Professional References are required for this posting. Please see the posting attachments for the reference guide.

  • Vendor submissions will close on 11/30/2026 at 10:00am ET. Late submissions will not be accepted.

  • Interview Process: Interviews will be conducted in-person in Lansing, MI. No remote interviews will be permitted, this is non-negotiable.

  • Assignment duration: 1-year with the intent to extend based on business needs.

  • Hybrid Work Schedule: There is no remote-only option. In-office for the 2 days per week is required (Tuesday/Wednesday).

  • Local candidates: Candidates must be willing to relocate within 70-miles of Lansing, MI within the 1st week of starting this position. The State will not provide any relocation assistance with relocating, all costs incurred are the sole responsibility of the candidate. Again, virtual interviews will NOT be permitted.

Description

Job description attached and listed below:

As a Data Analyst / ETL Developer within the Office of Retirement Services (ORS), you will play a vital role in managing and optimizing the data infrastructure, ensuring data quality, and facilitating effective data migration efforts. You will work as a contractor, collaborating closely with internal stakeholders and technical teams to support ORS's data-related initiatives, especially in the context of our ongoing modernization effort, using Agile methodologies, to update our current 20-year-old software package, to a modernized new product for the future.

Key Responsibilities:

  1. Expertise in Design, develop, and maintain scalable data pipelines using Microsoft Azure services.
  2. Strong experience with data profiling, data cleansing, data validation, and resolving data quality issues during large-scale migration projects.
  3. Root-Cause Analysis: Oversee the identification and resolution of data irregularities by conducting root-cause analyses and implementing approved solutions.
  4. Requirements Gathering: Engage with customers and business partners to gather data-related requirements, ensuring alignment with ORS objectives.
  5. SQL Expertise: Demonstrate strong SQL skills, particularly with Azure SQL Managed Instance, to manipulate, query, and transform data effectively.
  6. Data Integration Workflow Design: Leverage multiple years of experience to design complex data integration workflows that support ORS's data needs.
  7. Data Migration Leadership: Perform data migration activities, including data mapping, transformation, validation, and migrating from on-prem data solutions to cloud databases.
  8. Modernization Effort: Build and optimize ETL/ELT workflows using Azure Data Factory (ADF).
  9. Agile Methodology: Embrace Agile software methodology, participating actively in Agile development practices, including sprint planning, stand-up meetings, and iterative development.
  10. Industry Best Practices: Stay informed about industry best practices and standards, advocating for and implementing data-driven solutions that maximize efficiency and quality.
  11. Problem-Solving Skills: Ability to think abstractly and break down complex data issues and solutions into simplified, actionable tasks.
  12. Mentorship: Provide guidance and mentorship to first-time developers in data profiling and source-to-target mapping exercises.
  13. Data Management Knowledge: Display familiarity with key data management concepts, including Master Data Management, Data Quality Management, Metadata Management, Data Security, Information Lifecycle Management, and Data Governance.
  14. Stakeholder Engagement: Effectively influence, negotiate, and lead delivery teams to recognize the critical role of data in all projects and initiatives.
  15. Customer Expectation Management: Assess complex situations, set priorities, and implement action plans, ensuring a strong focus on delivering complete, provable, and high-quality outcomes.
  16. Strong Communication: Demonstrate strong written and verbal communication skills to professionally engage with management, staff, and customers. Display sound judgment and reasoning skills.

Qualifications (This is a senior position and requires 6+ years of experience):

  • Bachelor's degree in a related field (or equivalent work experience).
  • Proven experience as a Data Analyst or ETL Developer.
  • Proven skills in Microsoft Azure, Azure Data Factory, and Microsoft Fabric.
  • Expertise in SQL, T-SQL, especially with Azure SQL Managed Instance.
  • Expertise in Azure DevOps, Git, CI/CD
  • Proficiency in data integration and migration, with cloud migration experience as a plus.
  • Understanding of industry data management best practices and standards.
  • Strong problem-solving and analytical skills.
  • Ability to mentor and guide junior team members.
  • Knowledge of data management concepts, including MDM, Data Quality, Metadata Management, Data Security, ILM, and Data Governance.
  • Excellent stakeholder engagement, negotiation, and leadership skills.
  • Strong organizational skills with the ability to work independently and collaborate effectively within a team.

Top Skills & Years of Experience

Top Skills & Years of Experience:

  • 6+ years of experience with Microsoft Azure, Azure DevOps, Git, CI/CD
  • 6+ years of experience with Azure SQL Managed Instance, Strong SQL and T-SQL skills
  • 6+ years of experience with Azure Data Factory (ADF), Microsoft Fabric
  • Bachelor's Degree in a related field.
  • Clear and concise written and verbal communication is crucial to success and productivity in this role

Recruiter Details

Contact: Sameer - - Seven one nine - two three nine - Five five five five


Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs