EMR Analyst, Data Warehousing - Senior at AdventHealth

Date Posted: 9/17/2019

Job Snapshot

  • Job Schedule
  • Job Category
  • Date Posted:
  • Job ID:
  • Job Family
    Information Systems
  • Travel
    Yes, 25 % of the Time
  • Shift
    1 - Day
  • Application Zone
    1-Shared Services
  • Organization
    AdventHealth Information Technology

Job Description


EMR Analyst, Data Warehousing - Senior

AdventHealth Information Technology

Location Address: Inspiration Avenue, Altamonte Springs FL

Top Reasons To Work At AdventHealth Corporate

•         Great benefits

•         Immediate Health Insurance Coverage

•         Career growth and advancement potential

•         Award-winning IT Department

Work Hours/Shift:

Full-Time, Monday – Friday


You Will Be Responsible For:

Routine (Monthly/Annually)

•               Go to person for subject matter expertise in our EMRs (Cerner, Athena, etc.)

•               Go to person for Data Model expertise in our EMRs

•               Develops, tests and implements complex SQL code for data extraction from our EMR systems

•               Performs code reviews and enhancements prior to code releases

•               As assigned, responsible for the development, maintenance, tuning and support of ETL processes from source systems to targets

•               Troubleshoots, tunes and supports existing data warehouses and BI applications

•               Shares knowledge and programing methodology with peers to improve coding performance, reusability and standardization



•         Strong understanding of Data within our EMRs

•         Strong understanding of our EMR data models

•         Proficiency in database design concepts and techniques for OLAP versus OLTP

•         Understanding of entity relationship diagrams and resulting system performance strategies

•         Advanced database development knowledge

•         Strong analytical and problem-solving skills with ability to clearly articulate solution alternatives

•         Exceptional interpersonal skills and a team player

•         Excellent written and verbal communication skills

•         Ability to demonstrate mentorship and provide guidance to peers


•         Performance tuning experience in SQL Server, Oracle and/or Big Data environments (Apache Impala/ Apache Hive)


•         Master’s Degree in Computer Science or related field, or Bachelor’s Degree in Computer Science or related filed with 5 years’ experience

•         Foreign equivalent is acceptable in lieu of a US degree



•               2+ year experience in Cerner reporting writing through CCL and/or SQL is a big plus

•               This is the great opportunity for those who want career advancement and to move onto the next generation of Data Warehouse technology beyond CCL.

•               ETL experience using Informatica

•               Familiarity with BI tools including but not limited to QlikView, OBIEE, and Power BI

•               Fluency with best practices for ETL design and development such as data profiling, data cleansing, change data capture, and performance optimization

•               Ability to evaluate and implement solutions balancing reuse, extensibility, reliability and performance

•               Flexible, open to suggestions, and eager to learn or share knowledge

•               Orientation toward self-motivation, organization and attention to detail



Works as a member of Data Warehousing and Business Intelligence teams within the Corporate Analytics department. Go to person for all questions related to EMR data and EMR data models including but not limited to Cerner and Athena. Works with the business to gather detailed requirements that will be used to solve complex business problems. Works with subject matter experts across the company to write complex SQL code to satisfy business requirements. Performs code reviews and applies SQL tuning and optimization methodologies. Works with the application and DBA teams on system tuning recommendations including but not limited to indexing and partitioning strategies. As a member of the Data warehousing team this person may be asked to work on informatica ETL or other assignments as necessary. Relies on experience and judgment to plan and accomplish goals. Provides direction and guidance to less experienced team members.

This facility is an equal opportunity employer and complies with federal, state and local anti-discrimination laws, regulations and ordinances.

Location | Organization | Category | Job Function