Senior Analytics Engineer

Arup; Salt Lake City (UT); On-site; USD 120,000 - 150,000; Full time

Job summary

ARUP Laboratories, based in Salt Lake City, Utah, seeks a Sr. Analytics Engineer to model complex clinical and operational data into data products for analytics tooling.

You will collaborate with IT staff, Medical Directors and Lab Managers to refine data models and enable scalable analytics across the organization. The role focuses on advancing data ontology, modern data platforms, and STATE data products, with responsibilities spanning data ingestion, transformation, and governance.

Qualifications

• Bachelor's degree in Computer Science or related field.
• Six+ years of professional data/analytics engineering experience in a cloud environment.
• Advanced SQL and modeling with modern transformation frameworks (dbt).
• Experience architecting scalable data models and managing large projects with many models.
• Hands-on cloud data infrastructure knowledge (AWS/GCP/Azure), IAM, VPCs, encryption.
• Proficiency in Python or R for data manipulation and automation.

Responsibilities

• Apply software engineering best practices to the data transformation layer using dbt.
• Architect and optimize the query layer for analytics across data lake/warehouse (Athena/Redshift/BigQuery).
• Own ingestion and orchestration frameworks stitching disparate clinical data sources (Glue, Airflow, Dagster).
• Lead modernization of ARUP's data ontology for clinical and business domains.
• Contribute to long-term roadmap to scale cloud storage and compute for high-volume data.
• Collaborate with leadership to deliver STATE data products.
• Other duties as assigned.

Skills

SQL mastery

dbt expertise

Python or R

Data modeling

Cloud infrastructure

Education

Bachelor's Degree in CS or related

Master's Degree preferred

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 or better in Computer Science or related field.

Preferred

Master's Degree or better in Computer Science or related field.

Experience

Required

Six plus (6+) years of professional experience in data engineering, analytics engineering, or a related technical field, with a proven track record of architecting scalable data models in a cloud environment

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.