Sr. Epic Business Intelligence Developer

About the job

Position Overview

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

Education

Licensure/Certifications

Assigned Work Hours

Pay Range

• (based on years of applicable experience):
• to

Requirements

• 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