Work Model: Hybrid, 2 days a week on site
Allows Relocation: Yes, but must interview in person
SUMMARY
For this Programmer Analyst role, our client, the State of Michigan, is seeking a Data Analyst / ETL Developer for 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 ongoing modernization effort, using Agile methodologies, to update our current 20-year-old software package, to a modernized new product for the future.
ReSPONSIBILITIES
- Expertise in Design, develop, and maintain scalable data pipelines using Microsoft Azure services.
- Strong experience with data profiling, data cleansing, data validation, and resolving data quality issues during large-scale migration projects.
- 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 Azure SQL Managed Instance, 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: Perform data migration activities, including data mapping, transformation, validation, and migrating from on-prem data solutions to cloud databases.
- Modernization Effort: Build and optimize ETL/ELT workflows using Azure Data Factory (ADF).
- Agile Methodology: Embrace 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
Required:
- Bachelor's degree in a related field (or equivalent work experience).
- Proven experience as a Data Analyst or ETL Developer.
- Proven skills in Microsoft Azure, Azure Data Factory, and Microsoft Fabric.
- Expertise in SQL, T-SQL, especially with Azure SQL Managed Instance.
- Expertise in Azure DevOps, Git, CI/CD
- 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.
PRE-EMPLOYEMENT & CLIENT SUBMISSION REQUIREMENTS
Employment and/or client submission is contingent upon successful completion of required pre-employment screening and verification processes. These requirements include:
-
Background check: Candidates must successfully complete the required background screening in accordance with company policy and applicable law.
-
Drug screening: Candidates must successfully complete the required drug screening in accordance with company policy, applicable client requirements, and applicable law.
-
Identity and location verification: Candidates may be required to complete identity and/or location verification using a secure verification tool prior to client submission.
-
Employment eligibility: Candidates must provide appropriate documentation to verify employment eligibility as required by law.
-
Qualification verification: Information provided during the application and recruiting process, including employment history, education, certifications, licenses, and professional references, may be verified as applicable.
-
Additional client requirements: Additional screening, documentation, or verification may be required based on the client, position, work location, or applicable requirements.
All screening and verification activities will be conducted in accordance with applicable company policies, client requirements, and federal, state, and local laws.
BENEFITS
This is a contract opportunity with a great organization. As a contractor for Smith Johnson, you are eligible for medical, dental, life, disability. Smith Johnson pays for 70% of your medical and dental and 100% of life and disability. The contract is also eligible for PTO/holiday accrued monthly. You are also eligible for a 3% retirement matching plan. Smith Johnson believes in taking care of our contractors.