Programmer Analyst - Data Warehouse Business Analyst

Overview

Title:
Programmer Analyst 6 - Data Warehouse Business Analyst

Location:
Lansing, MI (Hybrid Locals Only)

Duration: 12 Months

Data Warehouse Business Analyst / Reporting Position Description

General

Summary:

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

Responsibilities

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