Senior Data Engineer

Ah; United States; On-site; USD 97,000 - 181,000; Full time

Job summary

AdventHealth is seeking a data analytics professional to support consumer-facing digital products, focusing on data pipelines, AI readiness, and governed data workflows. You will contribute to reliable, scalable Cloud Data environments and BI tooling.

You will assemble large datasets, optimize SQL, translate EMR data, and build reusable data models while mentoring teammates and ensuring data quality and compliance.

Qualifications

• Bachelor's degree in Computer Science or related field.
• 2+ years building data pipelines with Snowflake; Azure Data Factory familiarity.
• 3+ years in data engineering with SQL scripting and programming languages.
• Experience with Hadoop, Spark, Kafka.
• Strong analytical, problem-solving and communication skills.
• Knowledge of regulatory and transplant-related domains.

Responsibilities

• Assemble large, complex data sets from operational and cloud sources.
• Optimize SQL query performance with Enterprise Data Services and Cloud Data teams.
• Develop statistical analytics to identify patterns.
• Translate business logic from EMR databases into conformed datasets.
• Develop and enforce SOPs for data management.
• Design workflows in Alteryx for BI reporting to migrate datasets to the Cloud Data platform.
• Provide training and mentorship to team members on technical data skills.
• Ensure data quality and end-to-end data validation.

Skills

SQL

Python

Snowflake

dbt modeling

Alteryx

BI tools

Data analysis

Team leadership

Communication

PDSA

Education

Bachelor's degree

Tools

Azure Data Factory

Hadoop

Spark

HiveQL

Salesforce SOQL

Tableau

QlikView

Crystal Reports

Job description

Our promise to you:

Joining AdventHealth is about being part of something bigger. It’s about belonging to a community that believes in the wholeness of each person, and serves to uplift others in body, mind and spirit. AdventHealth is a place where you can thrive professionally, and grow spiritually, by Extending the Healing Ministry of Christ. Where you will be valued for who you are and the unique experiences you bring to our purpose-minded team. All while understanding that together we are even better.

All the benefits and perks you need for you and your family:

• Benefits from Day One: Medical, Dental, Vision Insurance, Life Insurance, Disability Insurance

• Paid Time Off from Day One

• 403-B Retirement Plan

• 4 Weeks 100% Paid Parental Leave

• Career Development

• Whole Person Well-being Resources

• Mental Health Resources and Support

• Pet Benefits

Schedule:

Full time

Shift:

Day (United States of America)

Address:

893 HOPE WAY

City:

ALTAMONTE SPRINGS

State:

Florida

Postal Code:

32714

Job Description:

Responsible for supporting data analytics related to consumer-facing digital products. This position provides data-driven direction by offering analytical solutions and information tools to leadership and clients. The focus is making Supply Chain and Business Services data business-ready and AI-ready through reliable pipelines, governed data models, and practical AI tools and workflows. Strong engineering judgment and the ability to validate AI-generated code are important. Additionally, this role involves researching and extracting pertinent datasets from multiple source systems. In addition, this position expands and optimizes the Cloud Data pipelines and infrastructure. Additionally, this role supports enhanced decision-making and improves consumer outcomes.

• Provide training, mentorship, and guidance to team members on technical data skills to support ongoing learning and capability development.
• Assembles large, complex data sets from operational and Cloud Data sources to meet business requirements.
• Optimizes and tunes SQL query performance in collaboration with Enterprise Data Services and Cloud Data teams.
• Assists stakeholders with data-related technical issues using various project management methodologies.
• Develops statistical analytics solutions to identify patterns and problems using advanced statistical and BI platforms.
• Translates business logic from multiple transactional EMR databases into conformed Consumer datasets.
• Performs end-to-end data validation to ensure data accuracy.
• Develops reusable Developer Dataset and Developer Data Model processes for standardization.
• Understands and applies multiple data modeling approaches to optimize data delivery and automate processes.
• Provides ad-hoc data analysis and support to business functions.
• Designs and develops workflows in Alteryx for BI reporting tools to migrate datasets into the Cloud Data platform.
• Extracts and blends data from various CRM sources into meaningful datasets for solutioning.
• Develop, implement, and enforce standard operating procedures (SOPs) for data management to ensure consistency, quality, and compliance across analytics operations.
• Provide training, mentorship, and guidance to team members on technical data skills to support ongoing learning and capability development.
• Ensure the productivity, stability, and uptime of data solutions supporting revenue cycle analytics, proactively identifying and addressing performance issues.
• Other duties as assigned.

Knowledge, Skills, and Abilities:

• Advanced knowledge of SQL, database technologies, and data warehouse design philosophies [Required]
• Strong Python skills [Preferred]
• Strong Snowflake architecture and dbt modeling experience [Preferred]
• Comfort with agentic coding workflows, primarily in Codex [Preferred]
• Strong engineering judgement and the ability to validate AI-generated code [Preferred]
• Advanced knowledge of self-service analytic/ETL tools, specifically Alteryx Designer and BI Tools [Required]
• Successful history of manipulating, processing, and extracting value from large disconnected datasets [Required]
• Strong analytical, problem-solving, and troubleshooting abilities [Required]
• Ability to follow detailed procedures and ensure accuracy in documentation and data [Required]
• Strong understanding of current developments and trends in Information Technology in one or more of the following domains: Data Warehousing, ETL/ELT, Data integration, Data modeling / Database design [Required]
• Ability to work in SQL, Oracle SQL, and DB2 [Required]
• Dimensional modeling / Star Schema [Required]
• Solid and soft skills, verbal and written communication, and the ability to translate complex technical topics into understandable terminology are necessary [Required]
• Strong attention to detail that ensures follow through on all initiatives implemented and projects taken [Required]
• Mastery of desktop applications, including MS Office (Word, PowerPoint, Excel, and Access) and Crystal Reports [Required]
• Team leadership/facilitating skills [Required]
• Methodical approach to problem-solving with excellent analytical skills [Required]
• Ability to read, think and comprehend technical manual(s), bylaws, regulations, and instructions [Required]
• Knowledge of Plan-Do-Study-Act (PDSA) methodology [Required]
• Knowledge of organ procurement and transplant center activities [Required]
• Knowledge of regulatory agencies [Required]
• This position must have the proven ability to lead specific functions of large projects and initiatives [Required]
• Understanding of transplant regulations and operations [Required]

Education:

• Bachelor's [Required]

Field of Study:

• in Computer Science, Management Information Systems, Business Analytics, mathematics or similar analytical field

Work Experience:

• 2+ experience building and managing data pipelines using snowflake, with familiarity in azure data factory or similar cloud-based data integration tools. [Preferred]
• 2+ hands-on data modeling experience, including integrating multiple data sources and subject areas; preferably within revenue cycle or other complex technical environments required. [Preferred]
• 3+ years of related experience with big data specific sql workbench and real-time applications (hadoop impala, hue) [Required]
• 4+ years experience in a data engineering or similar role with extensive experience in sql scripting as well as experience with object oriented/function scripting languages (pyton, java, c++) [Required]
• 6+ years of experience in working with analytics with masters degree [Preferred]
• Experience building and optimizing Big Data pipelines, architectures, and datasets. [Required]
• Experience in building, publishing and managing reports/dashboards leveraging QlikView or any other BI tool (Ex. Tableau) [Preferred]
• Experience with big data tools: Hadoop, Spark, Kafka, etc. [Required]
• Experience with extracting and blending data from Salesforce Objects (SOQL) [Required]
• Experience with HiveQL or Big Data [Preferred]

Physical Requirements:

• Physical Requirements - https://tinyurl.com/23km2677

Pay Range:

$97,219.20 - $180,835.20

Background Screening Requirement (Florida Law)

Certain positions are subject to Florida Level 2 background screening, including fingerprinting, as required by state law.

Applicants may review general information about Florida’s background screening requirements at the Florida Care Provider Background Screening Clearinghouse: https://info.flclearinghouse.com/

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