IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.

Our client is looking for a SQL Data Warehouse Business Analyst. The client, 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 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.

NOTE: Local candidates within 2 hours of Lansing, MI ONLY. NO RELOCATION ALLOWED. Position will be hybrid, in office 2 days a week upon start and there is NO REMOTE ONLY option. Candidates submitted must be willing to come onsite (Lansing, MI) for interviews

Location: Lansing, MI (Hybrid)

Contract: 1+ years

Skills Required:

• 5+ years - SQL experience
• 5+ years - Experience as a Business Analyst (BA)
• 5+ years - Experience in Agile Methodology s
• Bachelor s Degree (Please include on your resume)

*** Rate depends on experience

*** Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time.

*** Companies submitting candidates should only submit direct W2 employees for this position.

Please submit your resume by using the "URL" below