Health Plan Lead Analytics Developer Epic Tapestry

Children's National Medical Center; Washington (District of Columbia); On-site; USD 147,000 - 245,000; Full time

Job summary

Children's National Hospital in Washington, DC is seeking a Health Plan Lead Analytics Developer Epic Tapestry to guide the development of analytics assets across Epic Cogito and Clarity.

You will lead reporting, dashboards, and data extracts, mentor teammates, ensure data quality, and partner with stakeholders to enable strategic decisions and improve enrollee outcomes in a dynamic healthcare environment.

Qualifications

• 10+ years of experience creating and maintaining reports and visualizations.
• Deep healthcare analytics knowledge and hands-on Epic reporting experience preferred.
• Strong SQL querying and data analysis skills across EMR data.

Responsibilities

• Lead design, development and maintenance of reports, dashboards, and data extracts.
• Mentor team members and ensure data quality for accurate analytics.
• Collaborate with clinicians, IT and administrators to translate requirements into Epic outputs.
• Develop Epic reports using Clarity, Reporting Workbench and Radar Dashboards.
• Establish data validation standards and ensure scalable analytics solutions.
• Communicate findings clearly to stakeholders and guide data-driven decisions.

Skills

SQL

Tableau

Business Objects

Power BI

OLAP

Oracle

SQL Server

T-SQL

PL/SQL

XML

HTML

Data Modeling

Python

Quality Assurance

Risk Analysis

Root Cause Analysis

Statistical Process Controls

Analytical Thinking

Problem-Solving

Communication

Project Coordination

Time Management

Healthcare Knowledge

Revenue Cycle

Adaptability

Collaboration

Change Management

Integrity

Education

Epic Certification

Tools

Clarity

Reporting Workbench

Radar Dashboards

Job description

Health Plan Lead Analytics Developer Epic Tapestry

1101 Vermont Ave NW Suite 1200 Washington, DC 20005

Kids Are Our Everything.

Department

10015 Information Resources

Pay Range

$147,264.00 - $245,440.00

The Lead Analytics Developer serves as a key member of the HSCSN data and analytics team, providing technical leadership for reporting, analytics, and data solutions that support health plan operations, regulatory compliance, and strategic decision making. Working closely with stakeholders across the health plan, this role leads the design, development, and maintenance of analytic products including reports, dashboards, data extracts, and data visualizations that support core business functions and strategic initiatives. The Lead Analytics Developer establishes development and data quality standards, guides solution design and data validation activities, and mentors team members to ensure the delivery of accurate, scalable, and actionable analytics solutions. The successful candidate combines advanced healthcare analytics expertise, strong technical and communication skills, and a passion for transforming data into meaningful insights that improve enrollee outcomes and organizational performance. Experience with healthcare payer operations and analytics platforms is preferred; experience with Epic technologies is a plus.

As the Lead Epic Analytics Developer, you will spearhead the technical development of enterprise-class data assets, including reports, visualizations, dashboards, and data extracts, to support business insight and decision-making for the Epic Cogito and Clarity applications. You will produce and analyze reports to address significant business issues, combining quantitative and qualitative data with subject-matter expertise to deliver clear, actionable insights. Your role involves leading efforts to ensure that Epic report writing tools and outputs are effective in providing comprehensive and insightful recommendations based on data-driven findings. Leads the development efforts of BI solutions architecture that accurately translates business requirements to technology solutions and ensures the design will meet business requirements throughout the lifecycle of a change

Minimum Work Experience

10 years Requires deep functional knowledge with 10 years of related experience in the creation and maintenance of reports and visualizations. (Required)

Required Skills/Knowledge

• Experience with relational database concepts, querying and analyzing EMR data using SQL for data extraction, manipulation and reporting.
• Experience with data analysis and visualization tools such as Tableau, Business Objects, MicroSoft Power BI.
• Expertise in OLAP, Oracle, SQL Server, T-SQL, PLSQL, XML, HTML
• Experience with Data Modeling; Python (programming Language); Quality Assurance; SQL (Programing Language).
• Experience with Analytical Techniques; Business Analysis; Quantitative Analysis; Rist Analysis; Root Cause Analysis; Statistical Process Controls.
• Analytical & Problem-Solving Skills - Expertise in analyzing complex technical and functional issues, troubleshooting, identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusions
• Communication & Interpersonal Skills - Exceptional verbal and written communication skills, with the ability to effectively interact with cross-functional teams, deliver clear and concise documentation, and engage diverse stakeholders in meaningful discussions.
• Project Coordination & Time Management - Skilled in managing competing priorities and overseeing multiple projects, ensuring delivery of high-quality results on time while maintaining the ability to handle larger, more complex initiatives.
• Healthcare & Revenue Cycle Knowledge - Advanced understanding of healthcare operations, clinical workflows, and revenue cycle management, with a proven ability to align Epic system functionality to meet organizational needs and objectives.
• Adaptability & Resilience - Demonstrates flexibility in adapting to changing business needs, remains composed under pressure, and successfully navigates and drives change in a fast-paced healthcare environment.
• Collaboration & Teamwork - A proactive leader and team player who builds strong relationships, offers constructive feedback, and consistently works to achieve organizational goals through collaboration and mutual support.
• Change Management & Change Agent - Experienced in managing and driving change within the organization by influencing stakeholders, guiding teams through transitions, and ensuring the smooth adoption of new processes and technologies.
• Integrity & Professionalism - Maintains the highest level of integrity, accountability, and professionalism, particularly when handling complex or high-pressure situations, while strictly adhering to organizational policies and procedures.

Required Licenses and Certifications

Epic Certification Requirement: This position requires that the appropriate Epic certification be successfully obtained and maintained for the assigned area of responsibility within 6 weeks of completing training or obtained prior to hire or demonstrated through work experience. 60 Days, (Required)

Functional Accountabilities

• Overseas the technical execution of business analysis activities to enable technology solutions that adequately fulfill strategic business needs and objectives
• Leads the execution of long-term strategic goals for Epic report development in conjunction with end user, management, customers, and other stakeholders.
• Conducts extensive research and makes expert recommendations on Epic products, services, and standards in support of procurement and development efforts
• Collaborates with stakeholders, including clinicians, administrators, and IT professionals, to understand reporting requirements and translate them into actionable reports within the Epic EHR system.
• Develop, customize, and maintain Epic reports using tools such as Clarity, Reporting Workbench, Radar Dashboards, and other reporting modules to extract and analyze data. Leveraging multiple Epic data models.
• Leads the design and creation of visually appealing and easy-to-understand reports, dashboards, and data visualizations that effectively communicate key performance indicators (KPIs), trends, and metrics.
• Performs and overseas data validation and quality assurance checks to ensure accuracy and reliability of reports
• Troubleshoot and resolve any issues or discrepancies in data extraction, transformation, or report generation processes.
• Lead collaboration with the Epic team and other stakeholders to optimize and streamline reporting workflows and processes.
• Stay up to date with the latest Epic reporting functionalities, features, and best practices, and proactively identify opportunities for improvement and innovation.
• Provides timely and appropriate communication to business owners, stakeholders, and users on issue status and resolution
• Leads the team in providing training and support to end-users, ensuring they can effectively utilize and interpret the reports generated.
• Document report specifications, data sources, and methodologies to maintain an organized and accessible repository of reporting assets.
• Coordinates and maintains an organized report and standard definitions library for easy access and reference for stakeholders
• Collaborates with both Enterprise Architecture and Solutions Architecture on the solutions/service design to ensure it conforms to enterprise architectural standards for future roadmaps.
• Performs other duties as assigned.
• Comply with all policies and standards.

The disclosed salary range includes the minimum and maximum rates within which Children's National believes an individual's base pay rate will fall for this position. It is not typical for an individual to be hired at or near the maximum of the pay range. The exact pay rate for this position will be based on a variety of factors in alignment with the Children's National compensation philosophy. These factors are legitimate and non-discriminatory including, but not limited to, the current market conditions; organizational needs; the individual's combination of prior work experience, level of education, knowledge, skills, and other qualifications. Children's National is committed to providing a fair and competitive total rewards package to each of our employees. This base salary range does not include our comprehensive benefits package or any additional compensation for which this position may be eligible.

Childrens National Hospital is an equal opportunity employer that evaluates qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender, identity, or other characteristics protected by law. The "Know Your Rights" poster is available here: and the pay transparency policy is available here: Know Your Rights Pay Transparency Nondiscrimination Poster.

Please note that it is the policy of Children's National Hospital to ensure a "drug-free" work environment: a workplace free from the illegal use, possession or distribution of controlled substances (as defined in the Controlled Substances Act), or the misuse of legal substances, by all staff (management, employees and contractors). Though recreational and medical marijuana are now legal in the District of Columbia, Children's National and its affiliates maintain the right, in accordance with our policy, to enforce a drug-free workplace, including prohibiting recreational or prescribed marijuana.