Job Details

PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters who know the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

Data Warehouse Business Analyst

We are seeking a Data Warehouse Business Analyst to join our team. The selected candidate will work a hybrid schedule consisting of two (2) days onsite each week in Lansing, MI, and three (3) days remotely

General Summary:

This position supports the Eligibility Data Warehouse Team, which provides critical data to support eligibility determinations for 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 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 entities to ensure IT solutions adhere to 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.