Job Description:Position SummaryThis role provides healthcare data expertise specific to the CCHA line of business, using claims, EHR, care management, and other data sources to support quality, utilization, and operational reporting for Medicaid populations. Performs ad-hoc and routine analyses, develops static and dynamic reports, identifies data-driven opportunities, and evaluates programs to guide CCHA quality measures and clinical team decision-making.
Works with a high degree of autonomy; expected to scope, build, validate, and deliver end-to-end analytic work with minimal oversight, while using Claude and other tools thoughtfully to increase productivity without sacrificing accuracy or judgment.
Core Responsibilities- Build and maintain CCHA reporting, writing and tuning T-SQL and developing in Power BI.
- Translate CCHA business and quality needs into information requirements; produce accurate, user-friendly reports and dashboards.
- Support CCHA quality measure reporting and related program evaluation.
Role ExpectationsAccountability & Ownership- Own work end-to-end - scope through delivery - including catching and fixing preventable errors before they go out.
- Escalate issues and apply feedback so the same correction doesn't recur.
Communication- Acknowledge requests promptly, confirm scope/requirements before starting, and give proactive status updates (not just at delivery).
- Escalate discrepancies and risks early, with enough context to support a decision.
- Communicate clearly to the audience - no unnecessary jargon - including transparent communication when something goes wrong (what happened, impact, root cause/plan).
Customer Service- Set clear expectations with CCHA stakeholders, confirm scope/assumptions before building, and document scope changes rather than letting requirements drift.
- Design deliverables with business-user utility in mind; get sign-off/testing before finalizing.
Data QC & Validation- Perform documented self-review/QC before submission (data, calculations, joins, filters, logic, outputs).
- Investigate anomalies before reporting; document what's unresolved.
- Maintain enough documentation (methodology, sources, assumptions, limitations) that work is reproducible.
Engagement & Collaboration- Participate actively in team processes; keep methodology/documentation consistent with teammates.
- Proactively resolve dependencies with teammates and stakeholders to keep work on schedule.
Strategic Thinking- Interpret findings in business context (quality, utilization, cost, operational impact).
- Identify trade-offs/risks on significant issues to support decisions.
- Use judgment to separate real findings from noise/data issues.
Technical Skills & AI Use- Use Claude to draft, troubleshoot, and improve queries, scripts, and documentation - with sound judgment, not blind acceptance.
- Independently review and validate all Claude-generated output before use.
- Build reusable Claude prompts and workflows for recurring CCHA work to improve consistency.
- Experience with Databricks or other cloud based platforms
- Maintain proficiency in SQL, Power BI, Python, Office, Git, and Claude.
Qualifications- Bachelor's degree in Health Administration, Applied Statistics, Mathematics, or related field. Master's preferred.
- 5-7+ years with relational databases, T-SQL, SQL stored procedures, Power BI/Report Builder.
- Healthcare industry experience, ideally with Medicaid claims/clinical data; familiarity with medical terminology and coding.
- Comfortable using AI tools (e.g., Claude) to support analytic work, with the judgment to validate and apply output appropriately.
- Strong problem-solving skills - able to scope a complex problem and break it into components.
- HIPAA-compliant home office if remote.
Salary Range:Salary Range: $90,719.20 - $117,936.00
Additional Compensation: Eligible for annual bonus based on individual and/or company performance.
Benefits: Includes medical, dental, and vision insurance; 401(k); paid time off (PTO); and Employee Assistance Program (EAP)
Application Deadline: Open until filled. Applications will be reviewed on a rolling basis.
How to Apply: Apply via careers page at https://alpinephysicians.wd1.myworkdayjobs.com/external