Facebook pixel

Senior Software Engineer
Data Quality
Confirmed live in the last 24 hours
Locations
Wrigleyville, Chicago, IL, USA
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Data Science
Data Structures & Algorithms
Google Cloud Platform
Management
Research
SQL
Python
Writing
Looker
Requirements
  • Domain knowledge in healthcare or genomics
  • Experience in quality control, unit testing, and creating testing frameworks for reliable data
  • Knowledge of dimensional and relational database modeling concepts such as referential integrity, normalization, etc
  • Ability to translate business requirements into SQL code
  • Experience with Business Intelligence tools like Looker
  • Exceptional SQL skills in an enterprise data warehouse environment
  • Experience with ETL/ELT and BI architectures, concepts and frameworks
  • Knowledge of data management best practices like incremental vs full loads, how to handle deleted data in source systems, insert-only vs merge architecture, etc
  • Background working with high volume and high velocity data warehouses
  • Ability to adapt quickly in a rapidly changing environment while effectively managing multiple projects and priorities simultaneously
  • Flexible to changing priorities
Responsibilities
  • Design, develop, and optimize data structures, ETL/ELT solutions, stored procedures, and functions using SQL and modern, cloud-based ETL/ELT technologies
  • Work with product managers, architects and internal stakeholders across the company in areas such as data science, clinical and molecular SMEs, and source system data producers to identify gaps and help maintain a backlog of tasks for development
  • Understand IT systems, analyze historical data, interpret trends, and identify patterns in complex data sets
  • Identify, evaluate and propose ways to improve overall visibility into data health and areas of opportunity to be surfaced at KPI levels
  • Deploy code with established CI/CD change management guidelines
  • Triage data quality issues reported by users in production systems
  • Analyze existing SQL queries for performance improvement opportunities
  • Maintain data warehouse ecosystem documentation such as ER Diagrams, data dictionaries, process descriptions, data catalog, etc. according to team standards
Desired Qualifications
  • Experience with GCP architecture
  • Experience working in a healthcare research or analytic/data science environment
  • Experience writing and debugging Python (SQL is required)
  • Familiarity with modern ELT tools such as DBT
  • Familiarity working within containerized environments
Tempus

1,001-5,000 employees

Data-driven precision medicine
Company Overview
Tempus is on a mission to provide the necessary tools to usher in an era of precision medicine. The company has built the world's largest library of clinical and molecular data and an operating system to make that information accessible and useful for patients, physicians, and researchers.