Epic Business Intelligence Developer

Epic BI Developer

Position Overview

We are seeking an experienced Epic BI Developer to join our team and support enterprise reporting, analytics, and data warehousing initiatives. The ideal candidate will possess strong expertise within Epic's Cogito suite, be highly proficient in SQL, and serve as a subject matter expert for reporting and analytics solutions. This individual will not only develop and maintain reporting assets but will also provide mentorship and guidance to other developers as questions arise within their day-to-day work.
The successful candidate will have deep knowledge of Epic reporting tools, data models, and best practices, with the ability to collaborate effectively across technical and operational teams to deliver impactful business intelligence solutions.

Key Responsibilities

Business Intelligence & Reporting Development

• Design, develop, test, and maintain reporting and analytics solutions utilizing Epic's Cogito toolset.
• Create and optimize reports, dashboards, extracts, and data solutions to support operational, clinical, and financial stakeholders.
• Develop and maintain complex SQL queries, stored procedures, and database objects.
• Analyze business requirements and translate them into effective reporting and data solutions.
• Ensure data accuracy, integrity, and performance across reporting environments.

Epic Cogito Development

• Leverage Epic Cogito tools to support reporting and analytics needs.
• Utilize Clarity and Caboodle data structures to build scalable reporting solutions.
• Work with Clinical and operational data models to support enterprise reporting initiatives.
• Troubleshoot reporting issues and identify opportunities for performance improvements.

Mentorship & Team Support

• Serve as a Sr. resource and mentor for other BI developers.
• Provide technical guidance and best practices related to Epic reporting, SQL development, and data modeling.
• Assist team members with troubleshooting, solution design, and development challenges.
• Participate in knowledge-sharing activities and contribute to team growth and development.

Data Integration & Source Control

• Support data integration efforts and ETL processes.
• Collaborate with technical teams to maintain reporting environments and data pipelines.
• Utilize source control methodologies and participate in version management processes.
• Contribute to development standards and documentation practices.

Required Qualifications

• Active Epic certifications in:
  • Cogito
  • Clarity Data Model
  • Clinical Data Model
  • Caboodle Data Model
• Strong proficiency in SQL with experience developing complex queries and database solutions.
• Experience working with Epic reporting environments including Clarity, Caboodle, and Cogito tools.
• Strong understanding of healthcare data analytics and reporting best practices.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently while collaborating effectively with cross-functional teams.
• Experience mentoring, coaching, or supporting other developers.

Preferred Qualifications

• Experience with SQL Server Integration Services (SSIS).
• Experience utilizing Git Hub or other source control/version management tools.
• Previous healthcare IT, Epic, or business intelligence consulting experience.
• Experience supporting enterprise data warehouse and reporting initiatives.
• Knowledge of healthcare clinical, operational, and financial data workflows.

Preferred Skills

• Epic Cogito Suite
• Epic Clarity Reporting
• Epic Caboodle
• SQL Development
• Data Modeling
• Report and Dashboard Development
• ETL Processes
• SSIS
• Git Hub
• Data Analysis
• Performance Optimization
• Technical Mentorship

Work Environment & Expectations

• Collaborate with business, clinical, operational, and technical stakeholders to deliver reporting solutions.
• Support ongoing reporting and analytics initiatives across the organization.
• Act as a trusted technical resource and mentor to other BI developers.

Overtime & On-Call Expectations

• No overtime requirements at this time.
• No on-call responsibilities are currently expected for this role.

Ideal Candidate

The ideal candidate is a highly skilled Epic BI professional who combines deep expertise in the Cogito reporting ecosystem with strong SQL development skills. They are passionate about data, enjoy mentoring fellow developers, and have the technical knowledge necessary to support and enhance enterprise reporting and analytics solutions across the Epic platform.
Job Type & Location
This is a Contract position based out of Pittsburgh, PA.
Pay and Benefits
The pay range for this position is $85.00 - $95.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the…