Make an impact with data infrastructure and modernization. As a Data Analyst / ETL Developer supporting the Office of Retirement Services (ORS) through Intellibee, you will help build and optimize scalable, Azure-based data pipelines that update an existing 20-year-old software package. This is a contract role in Lansing, MI (onsite), built around Agile execution, strong data quality practices, and measurable delivery.
You will work on data migration and modernization initiatives that require end-to-end pipeline ownership: from gathering data requirements and designing workflows, to profiling, cleansing, validation, transformation, and migration from on-prem sources into cloud databases.
What you’ll do
- Design, develop, and maintain scalable data pipelines using Microsoft Azure services.
- Drive data profiling, cleansing, validation, and resolution of data quality issues during large-scale migration projects.
- Lead root-cause analysis for data irregularities and implement approved solutions.
- Gather data-related requirements with customers and business partners to ensure alignment with ORS objectives.
- Apply strong SQL and T-SQL skills, including Azure SQL Managed Instance, to query, manipulate, and transform data.
- Design complex data integration workflows using multiple years of experience to support ORS data needs.
- Execute data migration activities, including data mapping, transformation, validation, and migration from on-prem solutions to cloud databases.
- Build and optimize ETL/ELT workflows using Azure Data Factory (ADF).
- Operate in an Agile environment, participating in sprint planning, stand-up meetings, and iterative development.
- Share and apply industry best practices and standards to improve efficiency and data quality.
- Provide mentorship to first-time developers in data profiling and source-to-target mapping exercises.
- Support data management concepts including MDM, Data Quality, Metadata Management, Data Security, ILM, and Data Governance.
- Influence and coordinate with delivery teams and stakeholders to emphasize the critical role of data in projects and initiatives.
- Manage customer expectations by assessing complex situations, prioritizing effectively, and delivering complete, provable, high-quality outcomes.
- Demonstrate strong written and verbal communication to engage management, staff, and customers professionally.
What you bring
- Bachelor’s degree in a related field (or equivalent work experience).
- 6+ years of proven experience as a Data Analyst or ETL Developer.
- Proven skills in Microsoft Azure, Azure Data Factory, and Microsoft Fabric.
- Expertise in SQL and T-SQL, especially with Azure SQL Managed Instance.
- Experience with Azure DevOps, Git, and CI/CD.
- Strong data integration and migration experience, with cloud migration experience considered a plus.
- Understanding of industry data management best practices and standards.
- Strong problem-solving and analytical skills, including the ability to break down complex issues into actionable tasks.
- 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.
Technologies you’ll use
Microsoft Azure, Azure SQL Managed Instance, Azure Data Factory (ADF), Microsoft Fabric, SQL, T-SQL, Azure DevOps, Git, CI/CD
Benefits
- Long-Term Stability: Multi-year opportunities with room to grow.
- Comprehensive Health Coverage: Healthcare benefits for you and your family.
- Future Planning: Access to a 401(k) program.
- GC Assistance: Support for immediate Green Card processing, if required.