Epic BI Developer

Prominence Advisors; Chicago (IL); Hybrid; USD 130,000 - 180,000; Full time

Benefits offered by this job

Health Care Plan

401k

Work From Home

Training & Development Fund

Technology Stipends

Job summary

Prominence Advisors in the United States seeks a senior Epic BI Developer to lead the Cogito data model migration to a cloud-hosted environment, with Azure as the preferred platform. You will guide customers, validate data integrity, and design dashboards using Cogito reporting tools.

Ideal candidates will have 5+ years of BI development, strong SQL skills, and deep Epic experience, plus a proven ability to deliver complex projects remotely and mentor client teams throughout the engagement.

Qualifications

• Active Cogito Data Model certification.
• Hands-on experience with Cogito tools and reporting platforms.
• Experience migrating Epic Cogito/Caboodle/Clarity to cloud (Azure preferred).
• 5+ years of BI development experience.
• Strong SQL development and cloud data warehouse tuning.
• Epic implementation and optimization experience.
• Knowledge of PHI security/compliance in cloud environments is a plus.
• Ability to deliver projects remotely.

Responsibilities

• Lead the Cogito data model migration from on-premise to a cloud-hosted environment (Azure).
• Validate data integrity, report parity, and performance benchmarks between old and new platforms.
• Design, build, and troubleshoot Cogito reports and dashboards.
• Optimize SQL development and reporting workflows for cloud infrastructure.
• Mentor customers to up-level their analyst skills on Cogito tools and cloud reporting.
• Translate operational requirements into system configuration and data architecture decisions.
• Create migration runbooks and data flow diagrams; manage risks and issues.
• Coordinate across BI, infrastructure, and customer teams; report progress and milestones.

Tools

Reporting Workbench

Radar

SlicerDicer

RW SQL

Job description

Prominence is looking for a senior Epic BI Developer to assist with a Cogito Cloud migration project.

Who We Are

Prominence is a healthcare and life sciences technology and consulting firm dedicated to helping leading organizations do more with their data. With deep expertise across the full ecosystem — spanning providers, payers, and life sciences — we turn complex data into actionable insight.

We deliver a full spectrum of services, including advisory, analytics, optimization, and IT staffing. Our work helps organizations operate more efficiently, improve patient outcomes, and deliver measurable financial impact through smarter use of data. Recognized as a 2x Best in KLAS organization, we partner with more than 120 health systems and 40 life sciences organizations, including 7 of the top 10 U.S. News & World Report-ranked institutions.

Through our life sciences brands, Tegra Analytics and WLH Consulting & Learning Solutions, we extend these capabilities to pharmaceutical and biotech organizations — combining data, consulting, and learning to advance commercial excellence.

By connecting strategy, data, and execution, we help organizations translate data into clarity, strategy into action, and vision into measurable results. At our core, we are a people-first, values-driven organization that believes strong teams and trusted partnerships are what ultimately make healthcare and life sciences smarter.

Your Role

Our consultants guide our customers through complex technology requirements to summit the challenge at hand. You will need to be able to create order out of chaos, and compile ambiguous information into tactical action plans.

Our ideal team members are humble, smart, and driven to ensure our customer's success. This includes a passion to deliver high-quality results, while teaching our counterparts how to fish and grow the skills needed to support and expand upon the deliverables of our projects.

Requirements

As a member of our Epic Consulting team, you'll work closely with our customers to implement and optimize their Epic workflows. In addition to your Epic project work, you will help mentor and grow our customer's teams, elevate issues, and guide projects to a successful outcome.

Key Responsibilities

• Lead technical execution of the Cogito data model migration from on-premise to a cloud-hosted environment (e.g., Microsoft Azure), including Caboodle and Clarity data structures
• Validate data integrity, report parity, and performance benchmarks between the legacy on-premise environment and the new cloud platform
• Apply technical expertise to implement and optimize EMR workflows and data capture within the Cogito data model
• Design, build, and troubleshoot reports and dashboards using Reporting Workbench, Radar, SlicerDicer, and RW SQL against cloud-hosted Cogito data
• Optimize SQL development and reporting workflows for cloud infrastructure performance, scalability, and cost efficiency
• Mentor customers to up-level their system knowledge and analyst skills on both Cogito reporting tools and the new cloud environment
• Analyze operational and business requirements and translate them into system configuration and cloud data architecture decisions
• Create build documentation, data flow diagrams, and migration runbooks
• Track and resolve project risks and issues, including migration-specific risks (data loss, downtime, report cutover)
• Lead meetings and participate in ongoing work-product coordination across BI, infrastructure, and customer teams
• Transparently report on project status, migration milestones, and deliverables
• Develop robust knowledge transfer documentation to hand off the migrated environment and reporting suite to customer teams
• Additional duties as may be required to successfully deliver the migration project
• May be invited to participate in corporate functions, events, and meetings

Desired Qualifications

• Active Certification(s): Cogito Data Model, Cogito Tools
• Hands-on experience with Reporting Workbench, Radar, SlicerDicer, and RW SQL
• Experience migrating Epic Cogito/Caboodle/Clarity environments to a cloud platform (Azure preferred)
• 5+ years of experience as a BI developer
• Strong SQL development skills, including performance tuning in cloud data warehouse environments
• Epic implementation and optimization experience
• Familiarity with cloud infrastructure concepts (cost management, security/compliance for PHI in the cloud, environment provisioning) a plus
• Demonstrated ability to deliver successful projects remotely

Success Criteria

• High degree of professionalism; treats others with respect, keeps commitments, builds trust within a team, works with integrity, and upholds organizational values.
• Highly organized; able to manage multi-faceted work streams
• Self-motivated; able to maintain schedule, meet deadlines, and monitor your personal work product
• Highly adaptable; able to acclimate quickly to new project assignments and work environments.
• Creative; not paralyzed by problems and able to work collaboratively to find novel solutions
• Clear communication skills; ability to clearly convey messaging that resonates with your audience, in clear and concise written and verbal communications
• Can smell smoke and anticipate issues before they arise, ability to elevate effectively
• Passion to mentor and guide others

Hours Worked

This is a Full Time, 40 hour per week position.

This role is part of our active pipeline for upcoming client engagements and is contingent on project availability, with timing aligned to client demand.

Benefits

• Competitive Salaried and Hybrid Compensation Plans
• Health Care Plan (Medical, HSAs, Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Dependent & Health Savings Accounts
• Short Term & Long Term Disability
• Paid Time Off (Vacation/Sick & Public Holidays)
• Training & Development Fund
• Technology Stipends (for Qualifying Roles)
• Work From Home
• Charitable Giving to Causes You Believe In

Employment Eligibility

Must be legally authorized to work in the United States without sponsorship.

Commitment to Equal Opportunity

The world's most talented professionals come from every background. All applicants will be considered for employment without attention to age, race, color, religion, gender identity and/or expression, sexual orientation, national origin, marital status, veteran or disability status, or any other characteristic protected by law. In addition, Prominence will provide reasonable accommodations for qualified individuals with disabilities.

Partnership Eligibility

Our partnerships are extremely important to us. This online application is not intended for anyone who is currently under a non-compete agreement or has an arrangement that precludes employment at Prominence. We appreciate your help in respecting our partners.