BI Developer (Epic)

• Location: Chicago, Illinois
• Type: Direct Hire
• Job #3097

Carex's partner is unlocking the future of virtual care! Their mission is to increase access to convenient and cost-effective care on a single platform connected to our nation's health systems.

They are seeking a direct-hire, remote business intelligence developer (BID). This individual will be responsible for connecting the business requirements and associated functions to meet current and future business needs. They own triaging analytics needs, gathering requirements, and building solutions to meet those needs. A BID is well-versed in Epic, including end-user workflows and has the technical skills required to design and write reports to meet stakeholder needs.

What you'll do:

§ Create and support business intelligence tools and reports

§ Design, code, test, and aggregate results from SQL queries to provide information to users

§ Engage leaders to discuss and influence options for new business intelligence capabilities and insights

§ Gather, document, and maintain business requirements

§ Assist with system logging, triage, and responding to issues

§ Support operational business improvement initiatives by developing and designing reports

§ Validate data integrity, monitor system performance, and deliver on data and reporting requests

§ Configuring and testing Epic-released and Foundation System content for all applications, including:

ú Reporting Workbench

ú SlicerDicer data models

ú Radar dashboards

ú Cogito SQL

§ Creating content to display Epic data from Chronicles, Clarity, and Caboodle

§ Writing SQL and configuring Radar settings for custom SQL metrics

§ Creating dashboards and reports from a variety of non-Epic systems for clinical, financial, technical, product and client success needs

§ Distributing analytics content to 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 Clarity and Caboodle features and determining how to implement the changes

§ BIDs might also be responsible for building and maintaining:

ú Cubes

ú Extracts

ú SlicerDicer custom filters

ú Third-party BI tools

ú Custom Epic data in Caboodle

What you’ll Bring:

• 5+ years of BI developer experience required
• 5+ years of Epic reporting experience required
• Epic certification in Cogito Fundamentals and Cogito Tools Administration required
• Completion of one of the following Epic training tracks preferred:
  • Access Data Model Certification
  • Clinical Data Model Certification
  • Revenue Data Model Certification
• Familiarity with Epic applications and database structure
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Familiarity with visualization technologies (example: Power BI)
• Proficiency with SQL and relational database concepts
• Proficiency with data warehouse and data dictionary
• Strong communication skills, written and verbal
• Highly organized, able to multi-task as well as maintain intense focus on individual tasks
• Self-starter with ability to maintain schedule, meet deadlines, and monitor one’s own work product

#LI-TB1