Job Description :
Role: Programmer Analyst 5 - Senior Data Analyst/ETL Developer
Location: Lansing, MI
Interview Type: ONSITE
Work Arrangement: Hybrid (2-3 days onsite/week)
Note: Local profiles or within 50 miles of Lansing, MI. ID & address proof is 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.
Description:
As a Data Analyst / 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 client data-related initiatives, especially in the context of our ambitious modernization effort, using Agile methodologies, to update client current 17-year-old software package, to a modernized new product for the future.
Key Responsibilities:
1. Data Profiling and Source-to-Target Mapping: Lead data profiling and source-to-target mapping exercises to understand data sources, structures, and relationships.
2. Root-Cause Analysis: Oversee the identification and resolution of data irregularities by conducting root-cause analyses and implementing approved solutions.
3. Requirements Gathering: Engage with customers and business partners to gather data-related requirements, ensuring alignment with client objectives.
4. SQL Expertise: Demonstrate strong SQL skills, particularly with Microsoft SQL Server, to manipulate, query, and transform data effectively.
5. Data Integration Workflow Design: Leverage multiple years of experience to design complex data integration workflows that support client data needs.
6. Data Migration Leadership: Lead data migration efforts, with preference given to experience in migrating from on-prem data solutions to cloud databases.
7. 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.
8. 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.
9. Industry Best Practices: Stay informed about industry best practices and standards, advocating for and implementing data-driven solutions that maximize efficiency and quality.
10. Problem-Solving Skills: Ability to think abstractly and break down complex data issues and solutions into simplified, actionable tasks.
11. Mentorship: Provide guidance and mentorship to first-time developers in data profiling and source-to-target mapping exercises.
12. 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.
13. Stakeholder Engagement: Effectively influence, negotiate, and lead delivery teams to recognize the critical role of data in all projects and initiatives.
14. Customer Expectation Management: Assess complex situations, set priorities, and implement action plans, ensuring a strong focus on delivering complete, provable, and high-quality outcomes.
15. 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.
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.