Epic Business Intelligence Developer Senior

Job Description:

Job Summary

This position will work with Surgical Services data. Partners with the business to turn data into critical information and knowledge. Possesses an advanced understanding of healthcare and/or data and analytics. Develops reporting and analytic solutions with knowledge of the primary source data (i.e., electronic health records, claims) and workflows. Develops relationships with internal and external users for direct consumption or integration with other systems. This role promotes data literacy by educating and training customers to use the data as an analytical tool, displaying the information for the purpose of analysis and exploration. Without supervision, designs, codes, configures, tests, debugs, deploys, documents, and maintains programs. Uses a variety of software development tools, programming languages, and testing/verification applications. This role creates and adheres to development best practices and quality standards. Gathers business requirements and translates the information into detailed technical specifications from which programs will be written or configured, and to validate that the proposed applications align with both the architectural design and business needs. Works closely with other BIDs, Data Engineers, Data Scientists, and internal/external customers. Coaches less experienced Business Intelligence Developers.

Essential Functions

• Designs, codes, configures, tests, debugs, deploys, documents, and maintains self-service reporting assets and understands Extract, Transform and Load (ETL) for the purpose of populating data warehouse assets and sending data outside of data warehouse assets.
• Translates and documents business program needs into a technical solution using visuals and creating data sources, metrics, and automation. Visuals, data sources, and automation will be created from electronic health record (EHR) reporting tools and databases, (i.e., Clarity, Caboodle, Epic Registries, Epic Extract Framework, Custom Radar SQL metrics, Data Links, and Predictive Model configuration), cloud reporting systems (i.e. Snowflake), and other EHR agnostic tools (i.e. SSIS, GoAnywhere, Tableau, PowerBI, etc.). Presents that technical solution to key stakeholders.
• Provides advanced analytics that can turn data into critical information in understanding a systemic business problem.
• Independently able to provide troubleshooting, maintenance, support, oversight, and technical guidance.
• Possesses knowledge of workflows in multiple business areas to support data development, analytics, and quality improvement activities. Guides less experienced Business Intelligence Developers in gaining workflow knowledge.
• Performs job-related duties in conformance with digital services standards and initiates and leads team through new/improved standards. Coaches less experienced Business Intelligence Developers.
• Participates in agile ceremonies determining the nature and scope of project activities and processes to be developed or modified, working across teams to communicate development dependencies to accomplish a final solution.
• Works with data engineers and data architects as the architect designs relational and dimensional data models to verify that the model meets the use cases and aligns with strategic direction.

Qualifications

Required

• Bachelor's Degree or equivalent in business, liberal arts, computer science, application programming, software development, information systems, database administration, mathematics, engineering, or another related field
• 5 or more years of relevant experience
• Any Epic Certification held upon hire (preferably Epic Clinical Data Models and/or Clarity)
• Experience working with Tableau
• Experience working with health data (preferably with Surgical Services data)