Senior Data Engineer

Position Title:

Senior Data Engineer

Department:

IT Care Delivery Applications

Job Description:

Job Description

This position may be performed remotely from the following locations within the United States of America:  Arkansas, Colorado, Florida, Georgia, Indiana, Kansas, Louisiana, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, North Carolina, Ohio, Oklahoma, South Carolina, Tennessee, Texas, Utah, Vermont, Virginia, West Virginia, and Wisconsin.  

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 m