Programmer Analyst 6 Data Warehouse Business Analyst

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) Eligibity 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.

Tasks:

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