Talent.com
Stellar Professionals
ETL DeveloperStellar Professionals • Lansing, MI, United States
Search for other jobs
ETL Developer

ETL Developer

Stellar Professionals • Lansing, MI, United States
7 hours ago
Job type
  • Quick Apply
Job description

Senior Data Analyst / ETL Developer (Programmer Analyst 5)

Role Overview

Contract role (Hybrid - 2 days onsite/week in Lansing, MI) supporting a large-scale legacy modernization initiative to replace a 20-year-old retirement system with a modern cloud platform. Working in an Agile environment, you will architect scalable Azure data pipelines, lead on-premises-to-cloud data migrations, enforce data quality and governance, and mentor junior developers.

Location & Work Setup

  • Location: Lansing, MI (Candidates must relocate within 70 miles of Lansing, MI within the first week of starting at their own expense)
  • Arrangement: Hybrid - Tuesdays and Wednesdays onsite are required (no remote-only option)
  • Interview: In-Person Only in Lansing, MI (No remote/virtual interviews permitted; non-negotiable)
  • Shift: EST

Crucial Responsibilities

  • ETL/ELT & Pipeline Engineering: Design, build, and optimize complex, scalable data integration workflows and ETL/ELT pipelines using Azure Data Factory (ADF) and Microsoft Fabric.
  • Cloud Data Migration & Quality: Lead end-to-end data migration efforts from on-premises systems to cloud databases, executing data profiling, source-to-target mapping, cleansing, validation, and root-cause analysis of data anomalies.
  • Database Development: Write and optimize complex SQL/T-SQL queries and transformations on Azure SQL Managed Instance.
  • Agile Delivery & Mentorship: Collaborate with stakeholders to gather data requirements, participate in Agile sprints, enforce data governance/MDM best practices, and mentor junior developers on data profiling and mapping.

Core Qualifications & Stack

  • Azure Cloud & DevOps: 6+ Years with Microsoft Azure, Azure DevOps, Git, and CI/CD pipelines.
  • Database & T-SQL: 6+ Years with Azure SQL Managed Instance, strong SQL, and T-SQL development.
  • Data Integration & Analytics: 6+ Years with Azure Data Factory (ADF) and Microsoft Fabric.
  • Data Governance & Architecture: Strong grasp of Master Data Management (MDM), Data Quality, Metadata Management, Data Security, Information Lifecycle Management (ILM), and Agile methodologies.
  • Education & Communication: Bachelor's Degree in a related field (or equivalent work experience) plus clear, concise written and verbal communication skills.

Must-Have Constraints & Submission Requirements

  • Must physically reside in the United States and relocate within 70 miles of Lansing, MI within the first week of starting (no relocation assistance provided).
  • Must attend an In-Person Interview in Lansing, MI (no virtual interviews allowed) and work onsite every Tuesday and Wednesday.
  • Submission Packet: Must include professional references per the required reference guide

Create a job alert for this search

ETL Developer • Lansing, MI, United States