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.