Develop and maintain complex SQL and/ or Python queries to retrieve, join, and summarize data from multiple
sources, initially in SQL Server and later within Snowflake.
Develop, validate, and maintain analytical reports, dashboards and visual analytics (e.g., Power BI, Tableau) to
communicate findings effectively to stakeholders.
Use analytical reasoning to interpret trends, relationships, and outliers; synthesize findings into actionable insights
for business, operational, or clinical teams.
Collaborate with operational, business and clinical units to define metrics, KPIs, and performance indicators aligned
with organizational goals and document business rules and transformation logic that support consistent use of data
across reports.
Translate complex data into clear insights and visualizations that highlight trends, opportunities, and areas for
improvement.
Perform data validation, reconciliation, and spot checks to ensure accuracy and reliability of data migrated from
on-prem to cloud systems.
Support the development of automated data pipelines and quality checks in collaboration with data engineers.
Utilize SQL and Python for data querying, modeling, staging, reporting automation.
Create reports and dashboards in the Epic EHR as well as reports and dashboard in Power BI
Leverage Epic Clarity and Caboodle as a primary EHR data source for analysis, ensuring data accuracy and
consistency across reporting environments.
Aid in the development and validation of analytic datasets within Epic Caboodle to support enterprise reporting and
population health initiatives.
Participate in the development of data dictionaries, metadata documentation, and validation routines.
Identify and troubleshoot data anomalies and irregularities.
Contribute to continuous improvement of data quality and analytic capabilities by identifying process
enhancements and automating manual workflows.
Work closely with Data Engineering, Integration, and Governance teams to ensure data definitions, lineage, and
access controls are properly maintained.
Become a data subject matter expert (SME) and understand various sources and applications of Central Health
data.
Performs other duties as assigned.