Sr. Epic Business Intelligence Developer

Montage Health

United States

Remote

USD 123,000 - 164,000

Full time

3 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Remote work

Flexible hours (Pacific TZ)

Full-time exempt

Job summary

Montage Health is seeking a Senior BI Developer with healthcare experience to design, develop and deploy data analytics solutions for diverse stakeholders across the enterprise. You will lead BI reports and dashboards using Tableau, Power BI and SSRS, build data models, data marts and Caboodle components, and ensure data quality and governance in a complex healthcare environment.

The ideal candidate has 7+ years of BI/database development, strong SQL (window functions), ETL (SSIS/ADF), and

Qualifications

7+ years of database development and BI reporting experience.
Proficient in Epic Clarity-Caboodle data modeling and healthcare data workflows.
Strong SQL skills including window functions and CTEs.
Experience with Tableau, Power BI and SSRS for interactive dashboards.
Familiarity with Agile project management (SCRUM/Lean/Kanban).

Responsibilities

Coordinate with business teams to translate requirements into BI reports and dashboards.
Create data models, ERD and data flow diagrams as needed.
Build functional data marts for analytics by stakeholders.
Perform data analysis and ad-hoc queries to support decisions.
Maintain data quality, data integrity and governance.
Maintain and extend Epic Caboodle platform and data modeling components.
Ensure compliance with data standards and master data management.
Contribute to data project lifecycle from intake to prioritization.
Identify and validate data sources; contribute to strategic planning.
Provide excellent collaboration and customer service to stakeholders.

Skills

SQL

ETL processes

Tableau

PowerBI

Epic Clarity-Caboodle

SSIS

ADF

Data modeling

Data governance

Healthcare analytics

Education

Bachelor's degree in technical, scientific, and/or healthcare discipline

Epic Clarity-Caboodle Development certifications (preferred)

Tools

SSRS

MS SSIS

Tableau

PowerBI

Epic Caboodle

ADF

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