Epic Business Intelligence Developer Senior

Job Summary

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 has an understanding of 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 technical solutions 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.

How Corewell Health cares for you

• Comprehensive benefits package to meet your financial, health, and work/life balance goals. Learn more here.
• On-demand pay program powered by Payactive
• Discounts directory with deals on the things that matter to you, like restaurants, phone plans, spas, and more!
• Optional identity theft protection, home and auto insurance, pet insurance
• Traditional and Roth retirement options with service contribution and match savings

Qualifications

Required

• Bachelor's Degree or equivalent in business, liberal arts, computer science, application programming, software development, information systems, database administration, mathematics, engineering, or other related field
• 5 years of relevant experience
• Epic Cogito certification within 6 months of employment
• Experience working within the Cogito suite (Workbench, Radar, SlicerDicer)
• Experience using SQL

Preferred

• Experience developing dashboards using Tableau
• Experience working with ETL pipelines

About Corewell Health

As a team member at Corewell Health, you will play an essential role in delivering personalized health care to our patients, members and our communities. We are committed to cultivating and investing in YOU. Our top-notch teams are comprised of collaborators, leaders and innovators that continue to build on one shared mission sta