Job ID: JOB_ID_748
Position Overview
The State of Michigan is currently seeking a dedicated and analytical Business Analyst with a strong background in Data Warehousing and ETL (Extract, Transform, Load) processes. This position is situated within the Eligibility Data Warehouse Team, a critical unit responsible for managing the data that drives state-wide eligibility determinations for various social service programs. The successful candidate will play a pivotal role in ensuring that business requirements are accurately translated into technical solutions that maintain the integrity and compliance of state and federal data reporting. This is a hybrid role based in Lansing, Michigan, requiring two days of on-site presence per week, and is exclusively open to local candidates residing within a two-hour radius of the city.
Core Responsibilities
The primary focus of this role is to support the Eligibility Data Warehouse Team by acting as a liaison between business stakeholders and technical developers. Key responsibilities include:
- Requirement Elicitation: Facilitating meetings with program managers and policy experts to gather, document, and refine business and reporting requirements.
- Data Mapping and Documentation: Creating detailed data mapping documents that outline the flow of information from source systems to the data warehouse, ensuring that ETL logic aligns with business rules.
- SQL Analysis: Writing and executing complex SQL queries to perform deep-dive data analysis, validate reporting accuracy, and identify data quality issues.
- Dashboard Development: Designing and maintaining dashboards and reports using SQL-based tools to provide actionable insights to state leadership.
- Quality Assurance: Participating in the full software development lifecycle (SDLC), including the development of test plans, execution of user acceptance testing (UAT), and validation of bug fixes.
- Compliance and Regulation: Ensuring all data reporting meets strict state and federal regulatory standards for eligibility programs.
- Change Management: Assisting in the implementation of process improvements and managing changes to existing reporting structures.
- End-User Training: Developing training materials and providing hands-on support to end-users to maximize the utility of the data warehouse tools.
Technical Environment
Candidates will work within a robust technical stack that includes enterprise-level SQL databases, sophisticated ETL frameworks, and advanced reporting and dashboarding platforms. The environment demands a high level of technical proficiency in SQL for data manipulation and a conceptual understanding of data warehousing architectures, including star and snowflake schemas. Experience with government data systems or eligibility-related datasets is highly advantageous.
Professional Requirements
The ideal candidate must possess strong communication skills, both written and verbal, to effectively communicate technical concepts to non-technical audiences. A proactive approach to problem-solving and the ability to manage multiple priorities in a fast-paced environment are essential. Furthermore, candidates must have a valid LinkedIn profile for professional verification and must be prepared for interviews that may require on-site presence or rigorous vendor validation via Microsoft Teams. This role offers a unique opportunity to contribute to public service by enhancing the data systems that support Michigan’s most vulnerable populations.
Impact and Community
The Eligibility Data Warehouse Team is at the forefront of the State of Michigan’s digital transformation efforts. By joining this team, the Business Analyst will contribute to the modernization of legacy systems, ensuring that data flows seamlessly from front-end applications to the back-end warehouse. This process involves complex ETL logic that must be meticulously documented and tested. The BA will also be involved in data governance initiatives, helping to define data standards and ensure that all reporting is consistent across different state agencies. In addition to technical skills, the role requires a deep understanding of the business rules governing programs like Medicaid, SNAP, and TANF. The ability to interpret policy manuals and translate them into logic for data queries is a unique and highly valued skill in this position. The hybrid work model in Lansing provides a balance of collaborative in-person interaction and the flexibility of remote work, making it an ideal environment for a professional looking to make a significant impact on public policy through data. Lansing itself offers a high quality of life with a low cost of living, making it an attractive location for professionals and their families.
Special Requirements
Visa: USC, GC, GC-EAD & H4EAD. Interview: On-site presence or vendor validation via MS Teams. Domain: State of MI (Government). Local candidates only (within 2 hours of Lansing). Must have LinkedIn profile.
Compensation & Location
Salary: $60 – $60 per year
Location: Lansing, MI
Recruiter / Company – Contact Information
Recruiter / Employer: Spear Staffing LLC
Email: jai@spearstaffing.com
Recruiter Notice:
To remove this job posting, please send an email from
jai@spearstaffing.com with the subject:
DELETE_JOB_ID_748