ETL Developer

The selected candidate will work a hybrid schedule consisting of onsite work in Lansing, Michigan two (2) days per week and remote work three (3) days per week.

Job Description:

We are seeking a qualified candidate for the role of ETL Developer. As an ETL Developer, 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 the client'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 the client'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 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 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.