Title: Programmer Analyst VI - Data Warehouse Business Analyst
Location: Lansing, MI (Hybrid)
Note: This is a W2 contract role - 1099, C2C, and 3 rd party candidates will NOT be considered
This position plays a critical role in supporting 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. The Business Analyst will serve as a liaison between business stakeholders and technical teams, ensuring accurate data analysis and reporting using SQL-based tools. This 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.
Position Duties:
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 department entities to ensure IT solutions adhere to department 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
Position Qualifications:
5+ years of experience as a Business Analyst (BA)
5+ years of experience with SQL
5+ years of experience working in Agile methodologies
A minimum of a Bachelor's Degree in Information Technology or other related field