MI Govt DataBusiness Analyst SQL, DW, ETL, data quality

Job ID: MI-155009 ()

Hybrid/Local (Lansing ONLY) MI Govt Data/Business Analyst (15) with SQL DW ETL data quality/reporting/analytics training content development QA Agile and healthcare/eligibility determination experience

Location: Lansing MI (DTMB)
Duration: 12 Months
Please see the attached Pre-Screening Questions and have your candidate complete these. Make sure to remember to attach the answers to your bid when responding to this posting!
Remote or On-site: Accepting local candidates within 2 hours of Lansing MI ONLY. Position will be hybrid in office 2 days a week upon start and there is NO REMOTE ONLY option.

Top Skills & Years of Experience:
5 years of SQL experience
5 years of experience as a Business Analyst (BA)
5 years of experience in Agile Methodologies

Collaborate with DHHS program staff and technical teams to gather and document business
requirements.
Assist stakeholders in defining reporting/ETL requirements and provide guidance on data
interpretation.
Perform data quality checks and troubleshoot reporting issues to ensure accuracy and
compliance.
Support ongoing enhancements and integrations related to data reporting and analytics.
Participate in process improvement initiatives gap analysis and change management activities.
Provide training and technical support to end users for reporting tools and processes.
Assist in differentiating between defects and new requirements.
Develop training content.
Design develop and implement test plans for applications or subsystems.
Create or collect test data and execute approved tests to determine the accuracy of program logic
to produce desired results.
Participate in artifact reviews with peers system specialists Enterprise Security and other DTMB
entities to ensure IT solutions adhere to DTMB and agency policies standards or guidelines.
Identify security requirements and standards.
Develop and execute ad hoc SQL queries to extract analyze and validate data.
Create and maintain reports and dashboards using SQL-based tools to meet reporting needs.

The Department of Health and Human Services (DHHS) Eligibility group is responsible for public assistance
programs that provide essential support to individuals and families across Michigan. The Eligibility Data
Warehouse Team plays a critical role in supporting these programs by ensuring accurate and timely data
is available for eligibility determinations reporting and program management.
This position supports the Eligibility Data Warehouse Team which provides critical data to support eligibility.
determinations for DHHS assistance programs. The Business Analyst will serve as a liaison between
business stakeholders and technical teams ensuring accurate data analysis and reporting using SQL-
based tools. The role focuses on understanding business needs translating them into actionable reporting
requirements and creating ad hoc queries and dashboards to support decision-making and compliance
with federal and state requirements.

MI RTR Hybrid (1).docx

MI Cover Sheet

155009 Prescreen

MI

innoSoul Inc. is an Information Technology company and offers technology solutions in various platforms to different business domains. More specifically business solutions for Application Development System integration network or software installation support Custom Web Development Hosting solutions. Our value-added solutions leverage technology to enhance business performance increase productivity and secure data.