Quick overview
Job description
Location:Lansing,MI
In Person Interview Very long term project; initial PO for 1 year and usually the project goes for 3-5 years with this customer Hybrid2 days a week onsite
Job Description
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
- Expertise in Design, develop, and maintain scalable data pipelines using Microsoft Azure services.
- Strong experience with data profiling, data cleansing, data validation, and resolving data quality issues during large-scale migration projects.
- Root-Cause Analysis: Oversee the identification and resolution of data irregularities by conducting root-cause analyses and implementing approved solutions.
- Requirements Gathering: Engage with customers and business partners to gather data-related requirements, ensuring alignment with ORS objectives.
- SQL Expertise: Demonstrate strong SQL skills, particularly with Azure SQL Managed Instance, to manipulate, query, and transform data effectively.
- Data Integration Workflow Design: Leverage multiple years of experience to design complex data integration workflows that support ORS's data needs.
- Data Migration Leadership: Perform data migration activities, including data mapping, transformation, validation, and migrating from on-prem data solutions to cloud databases.
- Modernization Effort: Build and optimize ETL/ELT workflows using Azure Data Factory (ADF).
- Agile Methodology: Embrace Agile software methodology, participating actively in Agile development practices, including sprint planning, stand-up meetings, and iterative development.
- Industry Best Practices: Stay informed about industry best practices and standards, advocating for and implementing data-driven solutions that maximize efficiency and quality.
- Problem-Solving Skills: Ability to think abstractly and break down complex data issues and solutions into simplified, actionable tasks.
- Mentorship: Provide guidance and mentorship to first-time developers in data profiling and source-to-target mapping exercises.
- 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.
- Stakeholder Engagement: Effectively influence, negotiate, and lead delivery teams to recognize the critical role of data in all projects and initiatives.
- Customer Expectation Management: Assess complex situations, set priorities, and implement action plans, ensuring a strong focus on delivering complete, provable, and high-quality outcomes.
- 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.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- WO

Senior Cybersecurity Data Engineer - Data Platform & Lakehouse S with Security ClearanceRecently posted
Workday · Reston, VA · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLAWSSnowflake+9Technology$152k - $228k/yr - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · Baltimore, MD · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · Washington, DC · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr - KT

Data Engineer SnowflakeRecently posted
Kforce Technology Staffing · Westlake, TX · Hybrid · Posted 20 Nov 2026 🇺🇸
OraclePL/SQLSQL+8TechnologySalary not listed - GE

Principal Data Engineer - Hybrid
Genesis10 · Plano, TX · Hybrid 🇺🇸
AWSFlinkDatabricks+3Technology$150k - $190k/yr - AI

Senior Data Software EngineerRecently posted Auto Apply
Airbnb · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLScalaETL+3Technology$196k - $227k/yr - SG

Lead Data EngineerRecently posted
Software Guidance & Assistance · Rockville, MD · Hybrid · Posted 21 Nov 2026 🇺🇸
Stakeholder ManagementSQLApache Spark+7TechnologySalary not listed - CL

Lead Data EngineerRecently posted
ClifyX · Atlanta, GA · On-site · Posted 20 Nov 2026 🇺🇸
SQLGitApache Spark+9TechnologySalary not listed - TM

Data Engineer--cloud security or cloud infrastructureRecently posted
Tech Mahindra (Americas) Inc. · Milpitas, CA · On-site · Posted 20 Nov 2026 🇺🇸
AWSEncryptionCDK+5TechnologySalary not listed - AT

Data Engineer
Aivanta Tech Inc · Texas City, TX · Hybrid 🇺🇸
SQLApache SparkAWS+8TechnologySalary not listed - KE

Senior Data EngineerRecently posted
Kentro · United States · On-site · Posted 20 Nov 2026 🇺🇸
DockerSQLT-SQL+12Technology$158k - $175k/yr - ST

AWS Data Engineer - W2 ContractRecently posted
SDVS Technologies LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
AWSLLMGenerative AI+1TechnologySalary not listed
