Senior Data Engineer

Position Title:

Department:

Job Description:

General Description:  The Senior Business Intelligence (BI) Reporting Developer is responsible for the strategic design and implementation of highly complex report libraries and universes used by all departments within the enterprise.   The Senior BI Developer creates analytics content based upon input from BI Analysts and company leadership to enhance business decision making capabilities.   The Sr. BI Developer will develop and enhance the underlying data models used by BI Analysts, including a data warehouse or multi-dimensional system and is skillful in aggregating large data from multiple systems.  The Sr. BI Developer is responsible for aggregating data from multiple sources into an efficient data solution.   Provides leadership and mentoring to BI team and end users.  

Essential Responsibilities:  Responsibilities listed in this section are core to the position.  Inability to perform these responsibilities with or without an accommodation may result in disqualification from the position. 

• Leads the analysis, design, implementation, and maintenance of enterprise reporting applications and reporting libraries/universes.
• Develops of cubes, complex reports, interactive dashboards, and report libraries/universes.
• Creates standard SQL stored procedures, views and functions using best practices and efficient code
• Performs performance tuning on reports and database objects
• Provides oversight for enterprise EHR report library based out of Reporting Workbench
• Manages EHR databases by providing support for ETL related issues, errors and both scheduled / emergency related maintenance requests.
• Administrative responsibilities for BI servers
• Plans scalability, redundancy and disaster recovery for BI services
• Provides leadership, mentoring and guidance to other developers and IT staff.

Performs BI Developer duties:

• Meets with Business Intelligence Analysts and report requesters to understand their data needs
• Identifies and reviews the appropriate technological solutions for various reporting needs
• Understands the key business metrics for assigned service lines.
• Creates reports and dashboards using third‐party report writing tools such as Crystal reports, SSRS, PowerBI or Tableau
• Modifies and optimizes existing reports, as necessary
• Reviews peer reports for validity
• Tests report build in a specified testing environment and performs volume testing in live environments
• Remains abreast of vendor-specific upgrades and documentation, and determining how to implement the changes
• Remains abreast of industry best practices

General Responsibilities:

• Performs other related duties as assigned.

Minimum Qualifications:

Education and Experience:  Bachelor’s degree in engineering, physics, computer sciences, math, information systems, statistics, or related field and 5 or more years of experience developing with MS SQL and developing with BI Software.  Demonstrated experience managing and administering enterprise level BI systems.

Or equivalent combination of education and experience.  Four years of experience will be considered equivalent to a Bachelor's degree

Preferred Qualifications: Master’s degree in above fields or MBA preferred.  Healthcare experience preferred.

License(s)/Certification(s)/Registration(s) Required: Specific EHR modules certification required within 3 months of class completion.  Classes will begin within first 2 weeks of hire based on class availability.  Microsoft MCSA or MCSE SQL Certification preferred.

Knowledge, Skills and Abilities:

• Proficient in SQL and competence using related BI tools (e.g. SSAS, SSIS and BIML).
• Proficiency relational database concepts. In depth experience in constructing SQL stored procedures, views, and functions, including performance tuning, indexing and design patterns. 
• Ability to create data structures and modify data.
• Proficient at using various third party tools (e.g. Crystal Reports, PowerBI, Tableau, etc.).
• Understanding of data mining, and data warehousing.
• Proficiency and demonstrated experience with report writing tools.  
• Ability to gain an in‐depth understanding of the data model through data model classes geared toward content areas
• Ability to understand data structures that could benefit the entire reporting environment
• Excellent analytical, critical thinking, organization, and communication skills.
• Ability to work independently and within teams.
• Ability to solve complex problems and understand customer needs. 
• Strong understanding of healthcare business process and technology.
• Basic understanding of clinical workflows and terminology.
• Working knowledge of IT solutions and interfacing a plus.
• Must be able to drive to assigned sites to complete work. 
• Must be able to travel in state and out of state on occasion.
• Prior experience working with an accounts receivable system or prior experience working with an EMR system is desirable, but not required.

Current OU Health Employees - Please click HERE to login.

OU Health is an equal opportunity employer. We offer a comprehensive benefits package, including PTO, 401(k), medical and dental plans, and many more. We know that a total benefits and compensation package, designed to meet your specific needs both inside and outside of the work environment, create peace of mind for you and your family.