Programmer Analyst 5 (Data Analyst / ETL Developer) (123903)
Client: State of MI
Location: Lansing, MI (Hybrid schedule, 2 days a week in office REQUIRED. Tuesday & Wednesday. Local candidates ONLY. Must live within 60 miles of Lansing, MI.)
Duration: 1 year with possible extension
Close to Submissions on 11/06 at 10AM EST.
Interviews: ONSITE interviews required
Top Skill & Years of Experience Required:
• Proven experience as a Data Analyst or ETL Developer.
• Expertise in SQL, especially with Microsoft SQL Server.
• Proficiency in data integration and migration, with cloud migration experience as a plus.
• Understanding of industry data management best practices and standards.
• Knowledge of data management concepts, including MDM, Data Quality, Metadata Management, Data Security, ILM, and Data Governance.
Data Analyst / ETL Developer (Contractor)
Position: Data Analyst / ETL Developer Location: State of Michigan, Department of Technology Management and Budget, Office of Retirement Services (ORS).
Position 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 ambitious modernization effort, using Agile methodologies, to update our current 17-year-old software package, to a modernized new product for the future.
Key Responsibilities:
- Data Profiling and Source-to-Target Mapping: Lead data profiling and source-to-target mapping exercises to understand data sources, structures, and relationships.
- 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 Microsoft SQL Server, 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: Lead data migration efforts, with preference given to experience in migrating from on-prem data solutions to cloud databases.
- Modernization Effort: Play a key role in our ongoing modernization effort to replace our aging software, which is over 17 years old, with a new, modern system coded up to current standards. Contribute to the development of this cutting-edge software, ensuring that the data integration and ETL processes are aligned with our modernization goals.
- Agile Methodology: Embrace our recent transition from Waterfall to 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 10+ years of experience):
- Bachelor’s degree in a related field (or equivalent work experience).
- Proven experience as a Data Analyst or ETL Developer.
- Expertise in SQL, especially with Microsoft SQL Server.
- 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.
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 modernization effort and our Agile development approach.