Sr. Epic Business Intelligence Developer

Montage Health; United States; Remote; USD 123,000 - 164,000; Full time

Job summary

Montage Health is seeking a Senior BI Developer to design, develop and deploy analytics solutions across the enterprise. You will join a team to implement BI reports and dashboards using Tableau, PowerBI, SSRS, and Caboodle data models to turn data into insights.

The ideal candidate has 7+ years in database development and BI, strong SQL, experience with Epic Clarity-Caboodle, and healthcare workflows. You will collaborate with business teams, ensure data quality and governance, and support data

Qualifications

• 7+ years in database development and BI reporting.
• Expert in Tableau, PowerBI, and data visualization.
• Experience with Epic Clarity-Caboodle integration.
• Strong SQL skills including window functions.
• Healthcare data workflows familiarity.
• Ability to translate business needs into BI solutions.

Responsibilities

• Translate stakeholder requirements into BI reports and dashboards in Tableau, PowerBI, SSRS.
• Create data models and data flow diagrams.
• Build data marts for analytics across departments.
• Ensure data quality and governance across projects.
• Maintain and extend Epic Caboodle platform and Caboodle data modeling.
• Support data standards and master data management initiatives.
• Participate in data extraction and project lifecycle activities.

Skills

SQL

Tableau

PowerBI

Caboodle

Epic Clarity

SSIS

ADF

Data modeling

Data warehousing

BI reporting

Education

Bachelor’s degree in technical, scientific, or healthcare discipline

Epic Clarity-Caboodle Development certifications (preferred)

Tools

Tableau

PowerBI

Epic Caboodle

SSIS

Azure Data Factory

SQL Server

Job description

Welcome to Montage Health’s application process!

Job Description:

About the job

Welcome to Montage Health where we provide exceptional care, at every stage of life! We have an inclusive culture where people are respected, engaged and empowered to do their best every day for our patients. We currently have an exciting career opportunity for a Senior Business Intelligence Developer with healthcare industry experience to join our team.

Position Overview

Individuals in this position will design, develop and deploy data analytic solutions to a diverse array of stakeholders across the enterprise. As a Sr. Business Intelligence Developer, you will collaborate with our team of skilled developers to implement BI reports, dashboards and other forms of analytics solutions designed to gain new insights, while upholding best practices and standards. You will play a key role in our mission of converting data into actionable insights.

Responsibilities:

• Coordinate with various business teams, subject matter experts, or external entities to gather requirements and translate them into coherent Business Intelligence (BI) reports, and dashboards in Tableau, PowerBI, SSRS
• Create data models, ERD and data flow diagrams as needed
• Build functional data marts for in-depth analytics by stakeholders
• Perform data analysis and ad-hoc queries to support business decision-making
• Implement best practices to ensure data quality and data integrity
• Maintain and extend Epic Caboodle platform and develop custom Caboodle data modeling components
• Understand complex logic and solve data issues by coming up with sound technical solutions
• Support implementation of enterprise data standards and master data management standards
• Assist with data governance initiatives in the areas of data quality, data security, metadata management, and MDM
• Actively contribute to all aspects of the data project lifecycle including request intake and acknowledgment, project estimation, time-tracking, and prioritization of tasks
• Assist with identification, development and validation of data sources
• Contribute to the department’s short-term and long-term strategic plan
• Make appropriate recommendations on management of data extraction, and analysis
• Maintain knowledge of the current regulations and technologies related to data management
• Be an exemplary team player with excellent collaboration skills
• Exhibit outstanding customer service skills with stakeholders
• Perform other duties as required or assigned

Experience

• 7+ years of proven experience in database development, BI reporting
• Strong analytical, technical, and troubleshooting skills
• Ability to assess requirements from multiple sources and find innovative technical solutions
• Solid understanding on creating content to display Epic data from Clarity and Caboodle
• Experience with Microsft BI stack
• Sound knowledge of healthcare and health plan workflows
• Ability to work in a complex environment
• Ability to be organized and proficient at tracking tasks, defining next steps, and following project plans
• Advanced knowledge of SQL, including window functions and common table expressions
• Sound knowledge of data ETL concepts, processes, and tools such as MS SSIS, ADF
• Advanced knowledge of database and data warehousing concepts, including data lakes, relational and dimensional database design concepts, and data modeling practices
• Familiarity with Agile project management methods such as SCRUM, Lean, and/or Kanban
• Expert knowledge of Tableau, PowerBI, and dynamic data visualization tools
• Advanced knowledge of healthcare data structures, workflows, and concepts, from Electronic Health Record systems like Epic

Education

• Bachelor’s degree in technical, scientific, and/or healthcare discipline; or equivalent work experience

Licensure/Certifications

• Epic Clarity-Caboodle Development certifications are preferred

Additional Information

Hours: Must be able to accommodate pacific time zone hours
Location: Remote

Salary Range (based on years of applicable experience)

$122,553 to $163,945

#LI-RL1

Assigned Work Hours:

Full-time (Exempt)

Position Type:

Regular

Pay Range

(based on years of applicable experience):

$58.92 to $78.82