Senior Business Analyst Data Warehouse & Reporting (Local to Michigan)

Responsibilities:

• Collaborate with 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 client entities to ensure IT solutions adhere to client 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.