Join our Talent Network
Skip to main content
Indiana University Health

Senior Data Engineer (Enterprise Analytics - Data Management)

System Services
Date Posted
15 June, 2023
Schedule & Shift
Full Time
Day
Requisition Number
352107
Save Job Saved
Share: share to e-mail

Senior Data Engineer (Enterprise Analytics - Data Management)

This job posting is no longer active.

Job Description

Overview

The senior data engineer is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in Data Warehouse and BI development implementations. He/she will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes. Tasks will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized. This position involves the delivery of big data integration projects and requires leveraging best practices expertise and experience at implementation; as well as effective technology know-how to support the ongoing activity of those working within business intelligence and analytics teams.

ESSENTIAL FUNCTIONS

  • Design, construct, install, test and maintain highly scalable data management systems
  • Develop and maintain logical & physical data model designs, data management standards and conventions, data naming standards and metadata (normalized, de-normalized and STAR-based structures)
  • Perform reverse engineering of physical data models from databases and SQL scripts
    Evaluate data models and physical databases for variances and discrepancies • Knowledge of the Healthcare Ecosystem and Use Cases - e.g., Care Workflows, Careplans, Prior Auth, Population Health, Segmentation/Stratification, Risk Computation, etc.
  • Understanding and knowledge of Terminology Standards such as ICD10, CPT, Snomed, LOINC, RXNorm, ERGs, RERGs, DRGs • Experience in a healthcare setting with deep exposure to Payer and Provider oriented terminologies (Nice to Have). • Validate business data objects for accuracy and completeness
  • Participate in higher level planning efforts. Play a role in definition of process/guidelines/standards • Direct support of business intelligence and analytics teams LEADERSHIP
  • Comfortable engaging with personnel at all levels of leadership
  • Ability to listen to others and incorporate good ideas regardless of source
  • Professional in all communication and interaction with others
  • Willing to admit mistakes and make course corrections quickly ANALYSIS & COMMUNICATION • Ability to assess/analyze information needs objectively
  • Ability to drill down and ask the right questions to arrive at root cause
  • Confident in front of both management and developer audiences; ability to customize communication for both
  • Ability to learn and adapt quickly to new business domains and technologies • Good written communication skills; ability to use correct grammar and structure communication in a way that makes it easy to understand
  • Ability to navigate difficult conversations, remain objective and achieve sound outcomes

TECHNOLOGY & CAPABILITIES REQUIRED 

  • SQL: wide variety of development from simple ad hoc queries to complex stored procedures and multidimensional analysis
  • Data integration: ETL and ELT development paradigms and platforms – Airflow, Azure Data Factory, Apache Spark, Databricks
  • Software development methodologies/concepts: SDLC, Agile, Scrum, Git, Continuous Integration
  • MPP Data Warehouse Platforms: Azure Synapse (SQL DW), Amazon Redshift, Snowflake, Teradata, Azure Data Lake
  • Programming/scripting languages: Scala, Python, and PowerShell
  • Cloud Platforms: Azure Data Lake, Azure SQL DW, Azure Databricks, Apache Spark, AWS (Redshift) • Data profiling/quality: Informatica, Microsoft
  • Performance Tuning: Expert in performance tuning of ETL/SQL code
  • Required experience in documentation of code or data models and data mapping, definition of process/guidelines/standards, create data dictionaries, etc.
  • Experience with history tables, fact vs. dimension tables (slowly changing dimensions, SCD type 2), Git and Source Control, Azure cloud, Data Lake, Data Factory, Synapse • Working knowledge of SOLID development principles and common data models such as HL7, OMOP, FHIR, OMOP on FHIR, etc.
  • Expertise in SQL

QUALIFICATIONS/ATTRIBUTES/ABILITIES

  • Bachelor's degree preferred or equivalent experience
  • Requires database experience such as but not limited to Oracle, SQL Server, etc
  • Hands-on experience with modern enterprise data architectures and data toolsets (ex: data warehouse, data marts, data lake, 3NF and dimensional models, modeling tools, profiling tools)
  • Comfortable with ambiguity; comfortable iterating toward a destination rather than knowing it ahead of time
  • Self-starter; takes advantages of all possible venues for continuous learning
  • Enjoys working with teams, both inside and outside of his/her immediate area • Hungry to learn/master new approaches to information management and delivery

REQUIRES
• Bachelor's degree preferred or equivalent experience.
• 5-7 years of experience required.
• Requires experience in designing and developing enterprise level applications, data extracts and interfaces using languages and technologies including but not limited to: Java, JEE, .NET, XML, JSP, ASP.net, IIS, COBOL, 4GL, HTML or SharePoint, ATG, Documentum, Search Engines as SOLR, Autonomy, Oracle, SQL Server, etc.
• Requires database experience such as but not limited to Oracle, SQL Server, etc.
• Healthcare, health insurance and health providers experience and understanding of processes is desired.
• Requires experience with enterprise integration tools such as Servicemix, Cloverleaf, HL7, etc.

 

We are an equal opportunity employer and value diversity and inclusion at IU Health. IU Health does not discriminate on the basis of race, color, religion, sex, sexual orientation, age, disability, genetic information, veteran status, national origin, gender identity and/or expression, marital status or any other characteristic protected by federal, state or local law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Qualifications for the Senior Data Engineer (Enterprise Analytics - Data Management) Role

Overview

The senior data engineer is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in Data Warehouse and BI development implementations. He/she will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes. Tasks will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized. This position involves the delivery of big data integration projects and requires leveraging best practices expertise and experience at implementation; as well as effective technology know-how to support the ongoing activity of those working within business intelligence and analytics teams.

ESSENTIAL FUNCTIONS

  • Design, construct, install, test and maintain highly scalable data management systems
  • Develop and maintain logical & physical data model designs, data management standards and conventions, data naming standards and metadata (normalized, de-normalized and STAR-based structures)
  • Perform reverse engineering of physical data models from databases and SQL scripts
  • qualifications__list
    Evaluate data models and physical databases for variances and discrepancies
  • Knowledge of the Healthcare Ecosystem and Use Cases - e.g., Care Workflows, Careplans, Prior Auth, Population Health, Segmentation/Stratification, Risk Computation, etc.
  • Understanding and knowledge of Terminology Standards such as ICD10, CPT, Snomed, LOINC, RXNorm, ERGs, RERGs, DRGs
  • Experience in a healthcare setting with deep exposure to Payer and Provider oriented terminologies (Nice to Have).
  • Validate business data objects for accuracy and completeness
  • Participate in higher level planning efforts. Play a role in definition of process/guidelines/standards
  • Direct support of business intelligence and analytics teams LEADERSHIP
  • Comfortable engaging with personnel at all levels of leadership
  • Ability to listen to others and incorporate good ideas regardless of source
  • Professional in all communication and interaction with others
  • Willing to admit mistakes and make course corrections quickly ANALYSIS & COMMUNICATION
  • Ability to assess/analyze information needs objectively
  • Ability to drill down and ask the right questions to arrive at root cause
  • Confident in front of both management and developer audiences; ability to customize communication for both
  • Ability to learn and adapt quickly to new business domains and technologies
  • Good written communication skills; ability to use correct grammar and structure communication in a way that makes it easy to understand
  • Ability to navigate difficult conversations, remain objective and achieve sound outcomes

TECHNOLOGY & CAPABILITIES REQUIRED 

  • SQL: wide variety of development from simple ad hoc queries to complex stored procedures and multidimensional analysis
  • Data integration: ETL and ELT development paradigms and platforms – Airflow, Azure Data Factory, Apache Spark, Databricks
  • Software development methodologies/concepts: SDLC, Agile, Scrum, Git, Continuous Integration
  • MPP Data Warehouse Platforms: Azure Synapse (SQL DW), Amazon Redshift, Snowflake, Teradata, Azure Data Lake
  • Programming/scripting languages: Scala, Python, and PowerShell
  • Cloud Platforms: Azure Data Lake, Azure SQL DW, Azure Databricks, Apache Spark, AWS (Redshift)
  • Data profiling/quality: Informatica, Microsoft
  • Performance Tuning: Expert in performance tuning of ETL/SQL code
  • Required experience in documentation of code or data models and data mapping, definition of process/guidelines/standards, create data dictionaries, etc.
  • Experience with history tables, fact vs. dimension tables (slowly changing dimensions, SCD type 2), Git and Source Control, Azure cloud, Data Lake, Data Factory, Synapse
  • Working knowledge of SOLID development principles and common data models such as HL7, OMOP, FHIR, OMOP on FHIR, etc.
  • Expertise in SQL

QUALIFICATIONS/ATTRIBUTES/ABILITIES

  • Bachelor's degree preferred or equivalent experience
  • Requires database experience such as but not limited to Oracle, SQL Server, etc
  • Hands-on experience with modern enterprise data architectures and data toolsets (ex: data warehouse, data marts, data lake, 3NF and dimensional models, modeling tools, profiling tools)
  • Comfortable with ambiguity; comfortable iterating toward a destination rather than knowing it ahead of time
  • Self-starter; takes advantages of all possible venues for continuous learning
  • Enjoys working with teams, both inside and outside of his/her immediate area
  • Hungry to learn/master new approaches to information management and delivery

REQUIRES

  •  Bachelor's degree preferred or equivalent experience.
  • 5-7 years of experience required.
  •  Requires experience in designing and developing enterprise level applications, data extracts and interfaces using languages and technologies including but not limited to: Java, JEE, .NET, XML, JSP, ASP.net, IIS, COBOL, 4GL, HTML or SharePoint, ATG, Documentum, Search Engines as SOLR, Autonomy, Oracle, SQL Server, etc.
  •  Requires database experience such as but not limited to Oracle, SQL Server, etc.
  •  Healthcare, health insurance and health providers experience and understanding of processes is desired.
  •  Requires experience with enterprise integration tools such as Servicemix, Cloverleaf, HL7, etc.

  • Job Page Content image

    Indiana University Health is Indiana’s most comprehensive health system, with 16 hospitals and nearly 40,000 team members serving Hoosiers across the state. Our partnership with the Indiana University School of Medicine gives our team members access to the very latest science and the very best training, advancing care for all. We’re looking for team members who share the things that matter most to us. People who are inspired by challenging and meaningful work for the good of every patient. People who are compassionate and serve with a purpose. People who aspire to excellence every day. People who are always ready to apply themselves.

    Related Jobs in the Area

    Program Manager-Data Management

    Indianapolis, IN, United States
    System Services

    Analyst-Information Services Data Senior

    Indianapolis, IN, United States
    System Services

    Program Manager-Information Services

    Indianapolis, IN, United States
    System Services

    Manager - IIS - Data Cloud Operations

    Indianapolis, IN, United States
    System Services

    Manager-IS Center of Excellence (CoE)

    Indianapolis, IN, United States
    System Services

    Clinical Program Manager (RN) - Information Services

    Indianapolis, IN, United States
    System Services

    System Administrator-Physical Security

    Indianapolis, IN, United States
    System Services

    System Administrator-Physical Security

    Indianapolis, IN, United States
    System Services

    Administrator-Information Services Senior

    Indianapolis, IN, United States
    System Services

    IT Audit Manager

    Indianapolis, IN, United States
    System Services

    Manager-Information Services

    Indianapolis, IN, United States
    System Services

    Developer-Information Services Senior

    Indianapolis, IN, United States
    System Services

    Developer-Information Services Senior

    Indianapolis, IN, United States
    System Services

    Senior Information Services Business Analyst - ERP HCM

    Indianapolis, IN, United States
    System Services

    Senior Information Services Business Analyst

    Indianapolis, IN, United States
    System Services

    Oracle HCM Payroll and Global HR Functional-Technical Sr. Analyst

    Indianapolis, IN, United States
    System Services

    IIS Project Manager-Corporate Real Estate

    Indianapolis, IN, United States
    System Services

    IIS Project Manager-Corporate Real Estate

    Indianapolis, IN, United States
    System Services

    EBS Senior Security Administrator

    Indianapolis, IN, United States
    System Services

    Senior Salesforce Developer

    Indianapolis, IN, United States
    System Services

    Interested in working for IU Health?
    Take the first step by joining our Talent Network today!

    Join our Talent Network