
Lansing, MI - IT - Agency Services - ORS - ETL - Programmer Analyst 5
RICEFW Technologies · Lansing, MI, United States · Hybrid
Strong hiring record · median 6 days open
- 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
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.
More jobs at RICEFW Technologies
All 52- Systems Software Programmer - Project LeadRICEFW Technologies · North Charleston, SC, United States · USD 70/hrtoday
- JFS - IT Consultant 1/ITC1RICEFW Technologies · Remote, OH, United States · USD 94today
- ABC - Cybersecurity Engineer 4RICEFW Technologies · United Statestoday
- NCDIT-HIEA - Data Scientist- JuniorRICEFW Technologies · Remote · USD 70/hrtoday
- IT - SCDMV - Security Analyst - AdvancedRICEFW Technologies · Blythewood, SC, United Statestoday
Similar roles
- Lansing, MI System Analyst 6 - RedCap for hybrid in LansingSyntricate Technologies · Lansing, MI3mo ago
- Business Analyst (CBAP) – Azure DevOps & UAT – Lansing, MIMaxIT Consulting - Max Corporate Group · Lansing, United States3d ago
- Database Administrator 5 for Hybrid Work in LansingSyntricate Technologies · Lansing, MI7mo ago
- Programmer :: Lansing, MI (Hybrid)ARK Solutions · Lansing, MIyesterday
- Programmer Analyst 6 (JAVA) in Lansing MI HybridSyntricate Technologies · Lansing, IN11d ago
- Application Security Analyst- State of MI- Lansing, MISteneral Consulting · Lansing, MI, United States · USD 60–65/hr2mo ago