Senior Analytics Engineer

Talentify; Salt Lake City (UT); On-site; USD 140,000 - 190,000; Full time

Job summary

ARUP Laboratories, based in Salt Lake City, UT, seeks a Sr. Analytics Engineer to transform clinical and operational data into scalable data products. You will partner with IT staff, Medical Directors, and Lab Managers to refine models for modern analytics tooling.

The role emphasizes data pipeline design, query optimization across data lake/warehouse, and ontology modernization for Laboratory Operations, Revenue Cycle, Genomics, and Quality Control.

Qualifications

• Bachelor's degree required.
• Master's degree preferred.
• Advanced degrees or specialized certifications.
• Expert SQL & Modeling: mastery of complex SQL and deep experience with modern transformation frameworks (e.g., dbt).
• Cloud Infrastructure: hands-on experience designing data infrastructure in a major cloud provider (AWS, GCP, or Azure).
• Programming Proficiency: Python or R for data manipulation, automation, and API integrations.

Responsibilities

• Apply software engineering best practices to the data transformation layer using dbt.
• Architect and optimize the query layer for performant analytics across data lake and warehouse with Athena, Redshift, or BigQuery.
• Own ingestion and orchestration frameworks stitching disparate clinical data sources (Glue, Airflow, Dagster).
• Lead modernization of ARUP’s data ontology for Laboratory Operations, Revenue Cycle, Genomics, and Quality Control.
• Contribute to the long-term technical roadmap for the data platform and scalable cloud storage/compute.
• Collaborate with leadership to collect requirements and code STATE data products.
• Other duties as assigned

Skills

SQL

dbt

Python

R

Modeling

Data Warehousing

Education

Bachelor's Degree

Master's Degree

Tools

dbt

Athena

Redshift

BigQuery

Glue

Airflow

Dagster

Job description

Schedule

Monday - Friday (40 hrs/wk)
8:00 AM - 5:00 PM

Department

Biocomputing - 331

Primary Purpose

The Sr. Analytics Engineer is responsible for modeling our complex clinical and operational data into data products that capture how a world-class laboratory functions. Works with Information Technology Staff, Medical Directors, and Lab Managers to understand the nuances of our laboratory operations to augment our data model for modern analytics tooling.

About ARUP

ARUP Laboratories is a national clinical and anatomic pathology reference laboratory and an enterprise of the University of Utah and its Department of Pathology. Based in Salt Lake City, Utah.

ARUP proudly hires top talent to create a work environment of diversity, professional growth and continuous development. Our workforce is committed to the important service we provide to over one million patients each month. We always strive for excellence and have a strong desire to have involvement with the advances in medicine and the role laboratory services plays within each patient’s life. We never forget that there is a patient behind every specimen we receive.

We are looking for individuals who want to contribute to ARUP's culture of accountability, integrity, service, and excellence. Consider joining our dynamic team.

Essential Functions

Apply software engineering best practices (version control, modularity, and automated testing, etc) to our data transformation layer using industry-standard frameworks such as dbt.

Architect and optimize the query layer to ensure performant analytics across our data lake and warehouse using serverless or managed technologies like Athena, Redshift, or BigQuery.

Own the ingestion and orchestration frameworks that stitch together disparate clinical data sources using modern tools such as Glue, Airflow, or Dagster.

Lead the modernization of ARUP’s data ontology for specific clinical and business domains such as Laboratory Operations, Revenue Cycle, Genomics, and Quality Control.

Contribute to the long-term technical roadmap for our data platform, informing high-level decisions on how to scale cloud-based storage and compute to handle high-volume data.

Collaborate with leadership to collect requirements and write the code for Secure, Timely, Accurate, Trusted, and Extensible (STATE) data products.

Other duties as assigned

Physical and Other Requirements

Stooping: Bending body downward and forward by bending spine at the waist.

Reaching: Extending hand(s) and arm(s) in any direction.

Mobility: The person in this position needs to occasionally move between work sites and inside the office to access file cabinets, office machinery, etc.

Communicate: Frequently communicate with others.

PPE: Biohazard laboratory environment that requires use of personal protective equipment in accordance with CDC and OSHA regulations and company policies.

ARUP Policies and Procedures: To conduct self in compliance with all ARUP Policies and Procedures.

Sedentary Work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects.

Fine Motor Control: Picking, pinching, typing or otherwise working, primarily with fingers rather than with the whole hand as in handling.

Vision: Having close, far, and peripheral visual acuity to perform a variety of tasks such as make general observations of depth and distance.

Qualifications

Education

Required

Bachelor's Degree

Preferred

Master's Degree

Experience

Required

Preferred

Advanced degrees or specialized certifications

Expert SQL & Modeling: Mastery of complex SQL and deep experience with modern transformation frameworks (e.g., dbt). You should have experience managing large-scale projects with hundreds of models and complex dependency graphs

Cloud Infrastructure: Hands-on experience designing and maintaining data infrastructure within a major cloud provider (e.g., AWS, GCP, or Azure), including a strong understanding of IAM, VPCs, and encryption

Programming Proficiency: Professional-level experience with Python or R for data manipulation, automation, and API integrations

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.