Developer, Business Intelligence

About This Role

This Business Intelligence Developer, certified in Epic Cogito, plays a pivotal role in providing analytics insights and developing data solutions for clinical and business operations. The role involves collaborating with stakeholders, gathering requirements, performing analyses, and designing, developing, and maintaining complex reports and databases. This Epic subject matter expert will build data solutions leveraging Epic databases and the Cogito suite of tools.

Responsibilities

• Configure and test Epic-released and Foundation System content for all applications, including Reporting Workbench, SlicerDicer, Radar, Cogito SQL
• Create content to display Epic data from Chronicles, Clarity, and Caboodle
• Write SQL and configure Radar settings for custom SQL metrics
• Modify existing reports
• Distribute analytics content to data consumers
• Review peer reports for validity
• Work with subject matter experts to understand the needs of data consumers
• Maintain the Analytics Catalog and associated metadata records
• Test analytics build in a specified testing environment and volume test in live environments
• Review upgrade documentation related to Cogito features and determine how to implement the changes
• Responsible for building and maintaining: Cubes-Extracts, SlicerDicer custom filters, Third-party BI tools, Epic data in Caboodle
• Identify business and technical impacts of user requirements
• Assume responsibility for the quality and delivery of technology business solutions
• Create ad hoc queries, data sources and reports to support the business
• Utilize Cogito suite of tools to deliver data solutions
• Provide production support and respond to questions related to BI development tool set and Cogito suite
• Mentor and provide guidance, direction, and support to other developers

Requirements

• 4+ years of recent healthcare or IT experience
• 3+ years of experience with BI reporting tools
• 3+ years of experience with SQL, writing complex, highly optimized queries across large volumes of data, database design, data warehouse design, query performance tuning, and writing stored procedures
• Knowledge of BI reporting best practices
• Applied experience working through the complete report development lifecycle for medium to large scale projects
• Training in the fundamentals of report design for the third-party reporting tool
• Strong experience with end users to gain an understanding of user workflows and how to present the data users need in a meaningful way
• Certified in Cogito Fundamentals (this is required to complete data model certification)