SQL ETL Developer

Quantum Technologies. LLC; Greenwood Village (CO); On-site; USD 100,000 - 140,000; Full time

Job summary

Quantum Technologies. LLC is seeking a data engineer to design, develop, and maintain complex ETL transformations using advanced SQL in an AWS-based environment.

You will optimize SQL transformations with CTEs and window functions, work on large datasets, and collaborate across distributed teams to ensure data quality and reliable pipelines using Python, shell scripts, and Spark where applicable. This role emphasizes performance tuning, production-grade ETL, and adaptability in a fast-paced,

Qualifications

• Strong, hands-on experience with advanced SQL, including CTEs and window functions.
• Proven experience working with large datasets at scale.
• Experience performing ETL transformations in production environments.
• Familiarity with AWS data services, particularly Athena and/or EMR.
• Ability to work in an agile environment with shifting priorities and multiple workstreams.

Responsibilities

• Design, develop, and maintain complex ETL transformations using advanced SQL.
• Process and transform large-scale datasets efficiently.
• Build and optimize SQL-based data transformations leveraging CTEs and window functions.
• Support and enhance data pipelines running in an AWS-based environment.
• Work with SQL-driven Spark workloads where applicable.
• Utilize template-based shell and Python scripts to support ETL workflows.
• Collaborate across distributed teams to support evolving data needs and priorities.
• Troubleshoot performance and data quality issues across ETL processes.

Skills

Advanced SQL

CTEs

Window functions

Large-scale data

Tools

AWS (Athena/EMR)

ETL pipelines

Python scripting

Shell scripting

Spark

Job description

Responsibilities

• Design, develop, and maintain complex ETL transformations using advanced SQL
• Process and transform large-scale datasets (millions of rows) efficiently and reliably
• Build and optimize SQL-based data transformations leveraging CTEs and window functions
• Support and enhance data pipelines running in an AWS-based environment
• Work with SQL-driven Spark workloads where applicable
• Utilize template-based shell and Python scripts to support ETL workflows
• Collaborate across distributed teams to support evolving data needs and priorities
• Troubleshoot performance and data quality issues across ETL processes

REQUIREMENTS

• Strong, hands-on experience with advanced SQL, including CTEs and window functions
• Proven experience working with large datasets at scale
• Experience performing ETL transformations in production environments
• Familiarity with AWS data services, particularly Athena and/or EMR
• Ability to work in an agile environment with shifting priorities and multiple workstreams

Preferred Skills

• Python scripting experience
• Shell scripting experience
• Experience working with Spark (SQL-based Spark workloads preferred)
• Exposure to AWS analytics and big data services

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.