Data Engineer (SQL Developer)
Chicago, IL
Applications have closed
Tempus
Tempus has built the world’s largest library of clinical & molecular data and an operating system to make that data accessible and useful, starting with cancer.About our teams:
Tempus is executing on the mission to create the world’s largest, integrated dataset of molecular and clinical data. At Tempus, products are owned and developed by small, autonomous teams composed of developers, designers, data scientists, and product managers. You and your team set the goals, build the software, deploy the code, and contribute to a growing software platform that will make a lasting impact in the field of cancer research and treatment.
Tempus builds software as nimble as our teams. Our modern tech stack allows our teams to iterate rapidly and lead our industry in innovation. Our decentralized, microservice architecture and emphasis on automation allow us to deliver advanced solutions with confidence, and at scale.
What You’ll Do
- Design, develop, and optimize data structures, ETL/ELT solutions, stored procedures, and functions using SQL and modern, cloud-based ETL/ELT technologies.
- Work with team architects and internal stakeholders across the company in areas such as data science, clinical and molecular SMEs, and source system data producers to refine business requirements during development.
- Evaluate completeness of source system data by performing a profiling analysis.
- Deploy code with established CI/CD change management guidelines.
- Monitor performance of production processes and recommend areas for improvement.
- Triage issues reported by users in production systems.
- Analyze existing SQL queries for performance improvement opportunities.
- Implement solutions to proactively monitor data quality with traceability to source systems.
- Maintain data warehouse ecosystem documentation such as ER Diagrams, data dictionaries, process descriptions, data catalog, etc. according to team standards.
Why we’re looking for you:
- Domain knowledge in healthcare or genomics.
- Knowledge of dimensional and relational database modeling concepts such as referential integrity, normalization, etc.
- Ability to translate business requirements into SQL code.
- Ability to adapt quickly in a rapidly changing environment while effectively managing multiple projects and priorities simultaneously.
- 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.
- Emphasis on data quality, unit testing, and creating testing frameworks for reliable data.
- Comfortable working with stakeholders and SMEs across the company.
- Enjoys a fast-paced environment with a variety of small projects and bigger initiatives.
- Flexible to changing priorities.
Bonus points for:
- Experience with AWS or GCP architecture
- Experience working with clinical and/or genomic data
- Experience writing and debugging Python (SQL is required)
- Familiarity with modern ELT tools such as DBT
- Familiarity working within containerized environments
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: AWS CI/CD Data management ELT ETL GCP Python Research SQL Testing
Perks/benefits: Flex hours
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Business Intelligence Engineer jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Data Manager jobs
- Open Data Analytics Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Senior Data Architect jobs
- Open Data Scientist II jobs
- Open Sr. Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Business Data Analyst jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open Data Product Manager jobs
- Open ETL Developer jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open GCP-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Java-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Kubernetes-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open Databricks-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs