We use essential cookies

Please Accept our Privacy Policy

Data Engineer (Azure) - Lansing, MI

Digital Technology Solutions

Lansing, MI 48933 • 11/21/2026

Job Description

Job Description

DTS is looking for Data Engineer (Azure) for our direct client position in Lansing, MI



Job Description:

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



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.