Senior Data Analyst
AVEM BUSINESS SOLUTIONS LLC•Oklahoma City, OK
•Remote
About The Position
The Senior Data Analyst turns clinical, financial and operational data into insight that leaders use to improve patient outcomes, cost and efficiency. The role bridges EHR, ERP and the data platforms, owning complex analyses, enterprise reporting and dashboard delivery from request to adoption. The analyst also mentors junior analysts and sets standards for data quality and governance.
Requirements
- Bachelor's degree in data analytics, statistics, computer science, health informatics, finance or a related field.
- 5+ years of data analysis experience, including 3+ years in a healthcare provider, health system or payer setting.
- Advanced SQL (complex joins, CTEs, window functions, performance tuning).
- 3+ years building enterprise dashboards in Power BI, including DAX and data modeling.
- Hands-on experience reporting from Epic Clarity and/or Caboodle.
- Experience working with Oracle ERP financial, supply chain or HCM data.
- Working knowledge of healthcare data: ICD-10, CPT, DRG, revenue cycle and quality measures.
- Python or R for statistical analysis and automation.
- Demonstrated understanding of HIPAA and handling of PHI.
- Strong understanding of software development lifecycle and project management methodologies.
- Excellent communication, documentation and presentation skills.
- Self-starter, passionate about making a difference.
Nice To Haves
- Epic certification or proficiency: Clarity Data Model, Caboodle Data Model or Cogito.
- Microsoft certification: Power BI Data Analyst Associate or Fabric Analytics Engineer.
- Experience with Oracle Fusion Cloud ERP, OTBI, BI Publisher or Oracle Analytics Cloud.
Responsibilities
- Lead complex analyses across clinical, revenue cycle, supply chain, workforce and finance domains, and present findings and recommendations to directors and executives.
- Build and maintain KPI frameworks for quality, length of stay, readmissions, throughput, labor productivity and cost per case.
- Support value-based care, population health and regulatory reporting (CMS, Joint Commission, state agencies).
- Write and optimize SQL against Epic Clarity and Caboodle to extract encounter, order, charge and outcome data.
- Build and validate Epic reporting content (Reporting Workbench, Radar dashboards, SlicerDicer) in partnership with Epic analysts.
- Translate Epic workflow and documentation changes into downstream reporting impacts.
- Integrate Oracle ERP data (General Ledger, Accounts Payable, Procurement, Supply Chain, HCM) with clinical data for cost, margin and spend analysis.
- Develop reports using Oracle BI Publisher, OTBI and Oracle Analytics, and reconcile results with Finance.
- Design, publish and govern Power BI datasets, semantic models and dashboards, including DAX measures, row-level security and refresh schedules.
- Develop data pipelines and models in SQL Server, Azure Data Factory, Azure Synapse or Microsoft Fabric.
- Automate recurring work with Power Query, Power Automate and advanced Excel.
- Define metric definitions and data dictionaries; monitor data quality and resolve discrepancies across source systems.
- Protect PHI by applying HIPAA, minimum-necessary and de-identification standards in all deliverables.
- Gather requirements from clinical and business stakeholders, scope requests and manage delivery timelines.
- Mentor junior analysts, review their code and reports, and promote analytics best practices.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
