CCBHC BUSINESS INTELLIGENCE DEVELOPER II (94000789)

FLSA Status

Exempt

Job Role Summary

The Certified Behavioral Health Clinic Business Intelligence Developer II is a hybrid role delivering on reporting needs to the Sandra Eskenazi Mental Health Center (“SEMHC”) and working with the Eskenazi Health Analytics Department. The incumbent helps champion data driven decision making. The developer is knowledgeable in the content and structure of the data warehouse and the software used to access it. The Business Intelligence Developer II is responsible for the development of requested reports, overall evaluation of data quality, assisting Tier I Developers, and working with the Data Analysts to ensure user needs are being met. A successful developer will enjoy writing SQL code, be able to apply critical thinking and problem-solving skills to meet requests, evaluate solutions to problems, and be willing to take innovative approaches to achieving the goals of the organization.

Essential Functions and Responsibilities

• Proactively contributes to Eskenazi Health’s mission: Advocate, Care, Teach and Serve with special emphasis on the vulnerable population of Marion County.  Models Eskenazi values of P.R.I.D.E. (Professionalism, Respect, Innovation, Development and Excellence)
• Utilizes Epic Cogito Tools, SlicerDicer, and other business intelligence tools to meet customer needs.
• Strategizes and implements Epic strategies to meet CCBHC quality measure technical specifications
• Builds, maintains, and problem-solves webservices data sharing with State of Indiana Division of Mental Health and Addiction (“DMHA”)
• Collaborates with the SEMHC senior leadership and quality team to ensure that CCBHC data collection and reporting from Epic meet required reporting deadlines
• Prioritizes completion of SEMHC CCBHC related Epic work tickets
• Takes lead in ensuring execution of all DMHA-mandated DARMHA updates
• Adheres to departmental policies and procedures regarding peer reviews, validation, and movement of content from lower to production environments.
• Ensures the reporting security of users, and access to reports is correct.
• Works with a multidisciplinary team to accomplish deliverables.
• Works with Application Teams to ensure system configuration allows reporting to meet business needs.
• Actively participates in departmental maintenance and cleanup of the reporting library and data quality.
• Reviews assigned Nova Notes and completes the required work by the established upgrade deadlines.
• Independently debugs problem queries or problem-solves complex reporting problems.
• Works with team lead and ETL developer when unable to write a query that runs efficiently.
• Develops data models for business intelligence tools outside of Epic.
• Provides one-on-one training to end users.
• Validates data in reports by utilizing Epic and other software to verify what is returned in the results matches what is displayed to end users.
• Understands the ETL processes specific for the Analytics team.
• Executes SSIS jobs when needed and understands the process of SSIS job development.
• Writes medium complexity SQL queries and seeks out ways to increase efficiency and skill in SQL code.

Job Requirements

• Bachelor’s degree in information technology, Computer Science, Informatics, Business, Mathematics or a healthcare major from an accredited college or university
• Three years of healthcare or analytical experience may be substituted in lieu of educational requirement
• Proficiency in SQL programming is required.
• Able to obtain the following Epic certifications (or comparable certifications if Epic stops offering these) within six months of hire.
  • Cogito Fundamentals
  • Cogito Administration
  • Caboodle Data Model
  • Clarity Data Model
  • Clinical Data Model
  • Data Courier (Badge)
• Valid Indiana driver’s license

Knowledge, Skills & Abilities

• Deep understanding of Eskenazi Health or healthcare clinical and operational workflows in general.
• Ability to lead Analytics or other IS/IT meetings.
• Demonstrates strong communication and interpersonal skills.
• Ability to probe for information about the underlying needs for a report request.
• Ability to analyze data and assist with identifying ways to measure key performance indicators.
• Knowledge and skill with Eskenazi business intelligence software.
• Continues to advance understanding of Eskenazi Health data and learning new business intelligence skills.
• Demonstrates strong time management skills.
• Ability to work independently to complete tasks with minimal assistance from other team members.

• Knowledge of C# and Web Services is highly preferred