| ETL Developer (Hybrid Onsite) at Lansing, Michigan, USA |
| Email: [email protected] |
| From: Sameer, GSK SOLUTONS INC [email protected] Reply to: [email protected] Job Title: Data Analyst / ETL Developer (Onsite Interview - Hybrid Onsite) Location: Lansing, MI Duration: 12 Months+ Client: State of Michigan 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-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 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. 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. Applicants must be prescreened on the following before vendor submission: 1. Live within 60 miles of the Lansing, Michigan, workplace location (validation based on applicants residence zip code). 2. On-site interview at the hiring managers discretion. 3. Agree to work on-site. The current agency policy requires minimum two days on-site and up to three days remote. The team currently works on-site Tuesdays and Wednesdays. Keywords: Michigan |
| [email protected] View all |
| Mon Oct 30 21:23:00 UTC 2023 |