Business Intelligence Developer I

Marion County Public Health Department; Indianapolis (IN); On-site; USD 65,000 - 90,000; Full time

Job summary

Eskenazi Health is seeking a Business Intelligence Developer I to join its Analytics Department. The role focuses on developing reports, validating data quality, and ensuring accurate data delivery from the data warehouse using SQL and Epic Cogito tools.

You will work with ETL developers and application teams to meet reporting needs and support end users with training. Applicants should have a Bachelor's degree in IT/CS/Informatics/Business/Math or a healthcare major, with SQL knowledge and a

Qualifications

• Bachelor's degree in IT/CS/Informatics/Business/Math or healthcare major.
• Experience with healthcare analytics is preferred.
• Understanding of database structures and ability to read/write basic SQL.

Responsibilities

• Develop reports and evaluate data quality for the data warehouse.
• Write SQL queries of basic to medium complexity.
• Validate reporting results and data accuracy for end users.
• Collaborate with ETL developers and application teams on data delivery.
• Provide one-on-one end-user training and support.

Skills

SQL

Data warehousing

Critical thinking

Problem solving

Education

Bachelor's degree in IT/CS/Informatics/Business/Math or healthcare major

Tools

Epic Cogito Tools

SlicerDicer

BI reporting tools

Job description

Location: Indianapolis, IN, US, 46202

Organization: HHC

Sub-Division:Hospital

Schedule:Full Time

Shift:Days

Eskenazi Health serves as the public hospital division of the Health & Hospital Corporation of Marion County. Physicians provide a comprehensive range of primary and specialty care services at the 333-bed hospital and outpatient facilities both on and off of the Eskenazi Health downtown campus including at a network of Eskenazi Health Center sites located throughout Indianapolis.

FLSA Status

Exempt

Job Role Summary

The Business Intelligence Developer I is part of Eskenazi Health’s Analytics Department and helps champion data driven decision making. The developer is proficient in the content and structure of the data warehouse and the software used to access it. The Business Intelligence Developer I is responsible for the development of requested reports and the overall evaluation of data quality. A successful developer will enjoy writing SQL code, be able to apply critical thinking and problem-solving skills to meet requests and be able to dig into data to validate reporting results and data quality.

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.
• 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.
• Write SQL queries of basic to medium complexity.

Job Requirements

• Bachelor's degree in Information Technology, Computer Science, Informatics, Business, Mathematics or a healthcare major from an accredited college or university
• Two years of healthcare or analytical experience may be substituted in lieu of educational requirement.
• Understanding of database structures and being able to read/write basic SQL codes is required.
• Able to obtain the following Epic certifications (or comparable certifications if Epic stops offering these) within six months ofre.Cogito Fundamentals, Cogito Administration, Caboodle Data Model, Clarity Data Model, Clinical Data Model, or Data Courier (Badge)

Knowledge, Skills & Abilities

TBD

Accredited by The Joint Commission and named as one of Indiana’s best employers by Forbes magazine for two consecutive years and the top hospital in the state for community benefit by the Lown Institute , Eskenazi Health’s programs have received national recognition while also offering new health care opportunities to the local community. As the sponsoring hospital for Indianapolis Emergency Medical Services, the city’s primary EMS provider, Eskenazi Health is also home to the first adult Level I trauma center in Indiana, the first verified adult burn center in Indiana and Sandra Eskenazi Mental Health Center, the first community mental health center in Indiana, just to name a few.