EDW Senior Healthcare Business/Data Analyst
Senior business/data analyst supporting a State Medicaid Enterprise Data Warehouse: gathering and documenting requirements and business rules for reports and extracts, writing SQL to profile Medicaid data, and supporting federal reporting (CMS-64, MARS, T-MSIS, PERM), testing/UAT, and documentation in SharePoint and Azure DevOps.
- Compensation
- Not disclosed
- Location
- Indianapolis, IN, USA
- Work setup
- Remote
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Data analytics
- Posted
Skills
Must have
- Bachelor's degree in business, information systems, public health, or related field, or equivalent experience
- 8+ years business analysis experience (requirements gathering, documentation, stakeholder facilitation, UAT)
- 5+ years working with healthcare data (claims, encounters, eligibility/enrollment, provider, or financial)
- 3+ years with Medicaid or public-sector healthcare programs (State Medicaid/CHIP, MMIS/MES vendors, Medicaid data warehouses, or managed care plans)
- 3+ years writing SQL to analyze and validate data in a relational database or data warehouse
- Understanding of Fee for Service and managed care claim adjudication, including managed care encounters
- Basic understanding of CMS reporting requirements for Medicaid
- Experience writing use cases, user stories, and acceptance criteria and supporting testing/UAT
- Experience facilitating meetings and documenting outcomes
- Proficient in MS Word, Excel, PowerPoint, Visio, MS Project, SharePoint, and Teams
- Strong written and verbal communication skills for technical and non-technical audiences
- Self-starter, organized, detail-oriented, able to manage competing priorities and tight deadlines with limited supervision
Full description
For over twenty-seven years RCR Technology Corporation has delivered the highest quality services to our clients with an expansive portfolio of industry-relevant services, and deep technical capabilities around data management and application development.
We are seeking a Senior Business/Data Analyst to support the State Medicaid Enterprise Data Warehouse (EDW) and works closely with the Medicaid SME on federal and State reporting. The role owns core BA work with limited supervision: gathering and managing requirements, documenting business rules and processes, facilitating and documenting meetings, and tracking decisions and action items. The analyst also does hands-on data analysis in SQL to validate requirements, research data questions, and support testing of reports.
This role helps the SME focus on policy and leadership-level work by owning the day-to-day documentation, coordination, and analysis that keep reporting deliverables moving. It also builds backup knowledge on the team for Medicaid and federal reporting processes.
Primary Responsibilities
- Gather, document, and manage business requirements for EDW reports, extracts, and enhancements, including federal reporting such as CMS-64/CMS-21 support, MARS, T-MSIS, and PERM.
- Analyze current business processes and systems and document requirements for new or changed processes.
- Help translate federal and State Medicaid policy and reporting guidance into business rules and requirements, with direction from the Medicaid SME.
- Write clear requirements artifacts: business requirements, business rules, use cases, user stories, acceptance criteria, data mappings, and process flows.
- Maintain requirements traceability from request through design, testing, and delivery.
- Schedule and facilitate working sessions with State business users, Optum technical teams, and other partners. Capture minutes, decisions, action items, and follow-ups.
- Track open questions, dependencies, and risks for assigned work, and escalate issues to the SME and project lead when needed.
- Write SQL to profile and analyze Medicaid enrollment, eligibility, provider, claims, encounter, and financial data to answer business questions and confirm requirements.
- Identify and document data anomalies and report variances, and work with ETL, BI, and QA teams to resolve them.
- Share use cases with data and quality analysts for profiling, review results, and confirm alignment with project requirements and Medicaid/CMS guidelines.
- Support testing and UAT, including test scenarios, acceptance criteria, defect reporting, and follow-up.
- Prepare presentations, summaries, and status updates for the SME, internal leadership, and the customer.