Senior Data AnalystETL Developer 123903

Lansing, MI - IT - DTMB - Agency Services - ORS - Programmer Analyst 5 - Senior Data Analyst/ETL Developer 123903

Please make sure your candidate can speak to the skills listed on their resume, the manager will have a technical team on the interview panel.

Local candidates ONLY. Must live within 60 miles of Lansing, MI.

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.

Please Read Full Job Description below

Job Description: 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-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 band 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 8+ 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 practic