Senior Analytics Engineer

Schedule:Monday - Friday (40 hrs/wk)8:00 AM - 5:00 PMDepartment: Biocomputing - 331Primary 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 assignedPhysical 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.QualificationsEDUCATIONBachelor's Degree or better in Computer Science or related fieldMaster's Degree or better in Computer Science or related fieldEXPERIENCESix 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 environmentAdvanced degrees or specialized certificationsExpert 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 graphsCloud 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 encryptionProgramming Proficiency: Professional-level experience with Python or R for data manipulation, automation, and API integrationsJob SummaryRequisition Number: SENIO022671Job Category: Information SystemsSchedule: Full-Time