Data Analyst / ETL Developer Location: State of Michigan, Department of Technology Management and Budget, Office of Retirement Services (ORS).
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.
Join our team and contribute to the success of the Office of Retirement Services by leveraging your data expertise to make a positive impact on Michigan's retirees and the state's retirement services. Your role will be instrumental in managing and optimizing the data infrastructure that supports the retirement services provided to Michigan residents, especially in the context of our technology modernization effort and Agile development approach
Job Duties
- 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.
Requirements
6+ years:
- Experience with Microsoft Azure, Azure DevOps, Git, CI/CD
- Experience with Azure SQL Managed Instance, Strong SQL and T-SQL skills
- Experience with Azure Data Factory (ADF), Microsoft Fabric
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 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.
Desired Skills
- Proficiency in data integration and migration, with cloud migration experience
Minimum Education
Location
- 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.
- Position is a hybrid schedule. There is no remote-only option. In-office for the 2 days per week is required (Tuesday/Wednesday).
- Working hours Monday-Friday, approximately 8:00 a.m. to 5:00 p.m. (flexible scheduling is possible)
Additional
Requirements
- Must be authorized to work in the United States; We are unable to offer sponsorships at this time
- Must undergo a background check and drug screening for employment.
Employment Terms
- This is a W2 position
- 40 hrs per week
- HYBRID schedule - There is no remote-only option. In-office for the 2 days per week is required (Tuesday/Wednesday).
About Zenfreed
At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent.
We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.
Benefits
We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees.