Developer, Business Intelligence

Business Intelligence Developer certified in Epic Cogito, will play a pivotal role in providing analytics insights and developing data solutions to support clinical and business operations. Collaborating closely with various stakeholders, your responsibilities span from gathering requirements and performing qualitative and quantitative analyses to designing, developing, and maintaining complex reports and databases.

This Epic subject matter expert will build data solutions by leveraging the Epic databases (Chronicle, Clarity, Caboodle) and the Cogito suite of tools.

Responsibilities

• Configuring and testing Epic-released and Foundation System content for all applications, including: Reporting Workbench, SlicerDicer, Radar, Cogito SQL
• Creating content to display Epic data from Chronicles, Clarity, and Caboodle
• Writing SQL and configuring Radar settings for custom SQL metrics
• Modifying existing reports
• Distributing analytics content to data consumers
• Reviewing peer reports for validity
• Working with subject matter experts to understand the needs of data consumers
• Maintaining the Analytics Catalog and associated metadata records
• Testing analytics build in a specified testing environment and volume testing in live environments
• Reviewing upgrade documentation related to Cogito features and determining 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 productions support and respond to questions related to BI development tool set and Cogito suite
• Mentor and provide guidance, direction, and support to other developers

Qualifications

• 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)
• Certified in Cogito Tools Administration
• Complete the Caboodle-Clarity Development class
• Badges for Radar SQL Metrics, SlicerDicer Custom Build, and Cogito SQL

Travel Required:

• Domestic travel up to 25%

Education:

• College degree in engineering, physics, computer sciences, math, information systems, or statistics (Required)
• Advanced degree (Preferred)

Required Technical Training or Professional Licensing:

• Epic Cogito Certification, Epic Certifications based on role focus - one or more of the following certifications are required:
  • Access Data Model Certification
  • Clinical Data Model Certification
  • Revenue Data Model Certification
  • Caboodle-Clarity Development Certification

English Language required.