JobHabor
Menu

Lansing, MI - IT - Agency Services - ORS - ETL - Programmer Analyst 5

RICEFW Technologies · Lansing, MI, United States · Hybrid

Strong hiring record · median 6 days open

100100

Hiring signal

Actively hiring

Posted today · Never reposted · Checked today · How we score

First seen
20 November 2026
Reposted
Not since September 2026
Last checked
Today · still on the employer's board
All reasons

In its favour

  • Posted yesterday
  • Still listed on the employer's own board

Did you apply?

Lansing, MI - IT - Agency Services - ORS - ETL - Programmer Analyst 5 at RICEFW Technologies. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

Security Comments

Position Description

Please ensure you attach the Cover Sheet (attached), valid Right to Represent with hybrid work schedule acknowledged and confirmed by candidate, and the candidate&# ;s resume with full legal first name, and last name ONLY. (Refer to Bid Submission Requirements). We request that resumes are kept to 4-5 pages, and your candidate will be rejected if this criteria is not met. Withdrawn candidates will not be permitted to be replaced.If you would like to use a sub vendor, only 1 level deep, please use dotStaff

Forms link

/en-US/public/SOMI/forms/df22aa32-ddd7-4035-91ac-2a10092614e3 Additional Requirements: Professional References are required for this posting. Please see the posting attachments for the reference guide. The State of Michigan is looking for a Programmer Analyst 5 Max Bill : NA/hour Sub Vendors Allowed: Yes -Vendor submissions will close on 11/ /2026 at 10:00am ET. Late submissions will not be accepted.

-Interview Process

Interviews will be conducted in-person in Lansing, MI. No remote interviews will be permitted, this is non-negotiable.

-Assignment duration

1-year with the intent to extend based on business needs.

-Hybrid Work Schedule

There is no remote-only option. In-office for the 2 days per week is required (Tuesday/Wednesday).

-Local candidates

Candidates must be willing to relocate within -miles of Lansing, MI within the 1st week of starting this position. The State will not provide any relocation assistance with relocating, all costs incurred are the sole responsibility of the candidate. Again, virtual interviews will NOT be permitted.

Top Skills & Years of Experience

-6+ years of experience with Microsoft Azure, Azure DevOps, Git, CI/CD -6+ years of experience with Azure SQL Managed Instance, Strong SQL and T-SQL skills -6+ years of experience with Azure Data Factory (ADF), Microsoft Fabric -Bachelor&# ;s Degree in a related field.-Clear and concise written and verbal communication is crucial to success and productivity in this role

Job description attached and listed below

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 ongoing modernization effort, using Agile methodologies, to update our current 20-year-old software package, to a modernized new product for the future.

Key Responsibilities

1. Expertise in Design, develop, and maintain scalable data pipelines using Microsoft Azure services. 2. Strong experience with data profiling, data cleansing, data validation, and resolving data quality issues during large-scale migration projects. 3.

Root-Cause Analysis

Oversee the identification and resolution of data irregularities by conducting root-cause analyses and implementing approved solutions. 4.

Requirements Gathering

Engage with customers and business partners to gather data-related requirements, ensuring alignment with ORS objectives. 5.

SQL Expertise

Demonstrate strong SQL skills, particularly with Azure SQL Managed Instance, to manipulate, query, and transform data effectively. 6.

Data Integration Workflow Design

Leverage multiple years of experience to design complex data integration workflows that support ORS&# ;s data needs. 7.

Data Migration Leadership

Perform data migration activities, including data mapping, transformation, validation, and migrating from on-prem data solutions to cloud databases. 8.

Modernization Effort

Build and optimize ETL/ELT workflows using Azure Data Factory (ADF). 9.

Agile Methodology

Embrace Agile software methodology, participating actively in Agile development practices, including sprint planning, stand-up meetings, and iterative development. 10.

Industry Best Practices

Stay informed about industry best practices and standards, advocating for and implementing data-driven solutions that maximize efficiency and quality. 11.

Problem-Solving Skills

Ability to think abstractly and break down complex data issues and solutions into simplified, actionable tasks. 12.

Mentorship

Provide guidance and mentorship to first-time developers in data profiling and source-to-target mapping exercises. 13.

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. 14.

Stakeholder Engagement

Effectively influence, negotiate, and lead delivery teams to recognize the critical role of data in all projects and initiatives. 15.

Customer Expectation Management

Assess complex situations, set priorities, and implement action plans, ensuring a strong focus on delivering complete, provable, and high-quality outcomes. 16.

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 6+ years of experience):

  • 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. 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 technology modernization effort and Agile development approach.

Skills

More jobs at RICEFW Technologies

All 52

Similar roles