S2Tech is a fast-growing IT consulting company serving clients in over a quarter of the United States. They are seeking a Senior Medicaid BI / Reporting Business Analyst to support a large-scale Medicaid pharmacy modernization initiative, acting as a liaison between business stakeholders and technical resources to define reporting requirements and perform data analysis.
Responsibilities:
- Gather, analyze, and document business requirements for reports, dashboards, and data extracts
- Translate business requirements into detailed functional and technical specifications
- Perform data analysis and validation using SQL
- Map source system data elements to reporting requirements and outputs
- Create report mockups, wireframes, and reporting specifications
- Collaborate with business stakeholders, technical teams, data engineers, and report developers
- Support User Acceptance Testing (UAT) and reporting validation activities
- Identify and resolve data quality issues and reporting discrepancies
- Document business rules, data definitions, transformation logic, and reporting processes
- Support modernization and migration activities involving reporting and analytics platforms
- Participate in project planning, design sessions, requirements workshops, and stakeholder meetings
Requirements:
- Bachelor's degree or equivalent experience
- 8+ years of experience as a Business Analyst, Reporting Analyst, Data Analyst, or Business Systems Analyst
- Strong SQL skills with the ability to query, analyze, validate, and troubleshoot data
- Experience gathering and documenting reporting requirements
- Experience creating functional specifications, data mappings, and process documentation
- Experience working with relational databases (Oracle preferred)
- Strong communication and stakeholder management skills
- Experience supporting User Acceptance Testing (UAT) and validation activities
- Medicaid, MMIS, MES, or healthcare industry experience
- Pharmacy Benefit Management (PBM) experience
- Experience supporting Medicaid claims, provider, eligibility, pharmacy, or financial reporting
- Experience with Cognos, Tableau, Apache Superset, Power BI, SAS, or similar reporting tools
- Experience with data warehouses, reporting repositories, and healthcare analytics environments
- Familiarity with ETL processes, data integration, and source-to-target mapping
- Experience supporting large-scale government healthcare modernization initiatives