Epic Reporting Analyst

Philadelphia, PA, US, 19107

Job Type: 

Req ID: 24553

Shift: Days

Employment Status: AF - Active - Regular - Full Time 

Job Summary

The Epic Reporting Analyst is responsible for a full range of activities that are required to deliver business and clinical valued analytics and reporting solutions to the enterprise. These activities include requirements definition, development, test planning, test execution and direct interaction with the health care business and clinical area(s), application experts, and other projects and programs within the organization.


This position will focus on the development of Epic Reporting solutions enabling visualizations of operational reporting, key metrics and self-service analytics based on our enterprise data. Good communication skills are required to effectively solicit requirements. Solutions are based primarily on the Epic Clarity operational data store, Epic Reporting Workbench and Epic Radar. This position is critical to ensuring the daily continuity in our operational and analytics deliverables. Technical skills should include SQL (Relational Database), Epic Clarity, Epic Reporting Workbench and Epic Radar. Certifications preferred.

Job Responsibilities

  1. Data Modeling – evaluate structured and unstructured data, determine the most appropriate schema for new fact tables, data marts, etc.
  2. Data Integration – incorporate new business and system data into the CHOP Data Warehouse while maintaining enterprise best practices and adhering to data governance standards.
  3. Reporting – collaborate with colleagues across the enterprise to scope requests. Extract data from various data sources, validate results, create relevant data visualizations, and share with requester. Develop dashboards and automate refreshes as appropriate.
  4. Governance / Best Practices – adhere and contribute to enterprise data governance standards. Also educates and supports colleagues in best practices to ensure that data is used appropriately.
  5. Product Ownership – collaborate and act as the voice of the customer to offer concrete feedback and project requests as well as an advocate for analytics from within the business units themselves.
  6. Assemble large, complex data sets that meet functional / non-functional business requirements.
  7. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  8. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources (including ground, hybrid cloud, and cloud) using SQL and various programming technologies.
  9. Develop analytics tools that utilize data resources to provide actionable insights, operational efficiency and other key business performance metrics.
  10. Work with stakeholders including the Executive, Clinical, and Analyst teams to assist with data-related technical issues and support their data infrastructure needs.
  11. Develop optimized tools for analytics and data scientist team members that assist them in building and optimizing projects into an innovative industry leader.
  12. Proficient at integrating predictive and prescriptive models into applications and processes.
  13. Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  14. Make recommendations about platform adoption, including technology integrations, application servers, libraries, and frameworks.
  15. Participate in a shared production on-call support model.
  16. Be a critical part of an Agile Scrum software development team, ensuring the team successfully meets its deliverables each sprint.
  17. Serve as a mentor for Data Engineer I and II

Required Licenses, Certifications, Registrations

Two (2) Certifications or proficiency in appropriate Data Science/Data Integration/Data Warehousing technology or subject domain.

Required Education and Experience

Required Education:

  • Bachelor’s Degree in Computer Science, Computer/Software Engineering, Information Technology or related fields.


Required Experience:

  • Minimum of six (6) years of Data Engineering/Business Intelligence/Data Warehousing experience, preferably in a healthcare environment.
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Experience supporting and working with cross-functional teams in a dynamic environment.
  • Working knowledge of message queuing, stream processing, and highly scalable data stores.
  • Previous experience manipulating, processing and extracting value from large disconnected datasets.

Preferred Education, Experience & Cert/Lic

Preferred Education:

  • Advanced Degree in Computer Science, Informatics, Information Systems or another quantitative field.


Preferred Experience:

  • Minimum of ten (10) years of experience in a Data Engineer role

Additional Technical Requirements

  • Strong analytic skills related to working with structured and unstructured datasets.
  • Must possess critical thinking and creative problem solving skills along with the ability to communicate well with stakeholders throughout the organization.
  • Strong communication, project management and organizational skills.
  • Highly proficient in SQL
  • Experience with big data tools: Hadoop, Spark, Kafka, BigSQL, Hive, etc.
  • Experience with relational SQL and NoSQL databases, including IBM PDA (Netezza), MS SQL Server and HBase.
  • Experience with data integration tools: Informatica, MS Integration Services, Sqoop, etc.
  • Experience with cloud vendors and services: AWS, Google, Microsoft, IBM
  • Experience with stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming, etc.
  • Experience consuming and building APIs
  • Experience with object-oriented/object function programming languages: Python, Java, C++, Scala, etc.
  • Experience with statistical data analysis tools: R, SAS, SPSS, etc.
  • Experience with visual analytics tools: QlikView, Tableau, Power BI etc.
  • Experience utilizing Agile methodology for development
  • Familiarity with electronic health record and financial systems. i.e. Epic Systems, Cerner, WorkDay, Infor, Strata etc.

All CHOP employees who work in a patient building or who provide patient care are required to receive an annual influenza vaccine unless they are granted a medical or religious exemption.

Children's Hospital of Philadelphia is committed to providing a safe and healthy environment for its patients, family members, visitors and employees. In an effort to achieve this goal, employment at Children's Hospital of Philadelphia, other than for positions with regularly scheduled hours in New Jersey, is contingent upon an attestation that the job applicant does not use tobacco products or nicotine in any form and a negative nicotine screen (the latter occurs after a job offer).

Children's Hospital of Philadelphia is an equal opportunity employer. We do not discriminate on the basis of race, color, gender, gender identity, sexual orientation, age, religion, national or ethnic origin, disability or protected veteran status.

VEVRAA Federal Contractor/Seeking priority referrals for protected veterans.  Please contact our hiring official with any referrals or questions.

CHOP Careers Contact 

Talent Acquisition

2716 South Street, 6th Floor

Philadelphia, PA 19146 

Phone: 866-820-9288




Nearest Major Market: Philadelphia

Job Segment: Medical, EMR, Database, Developer, Computer Science, Healthcare, Technology