ETL Developer - Build Scalable Data Pipelines & Warehouses

Robotic Technologies Automation; Denver (CO); On-site; USD 110,000 - 140,000; Full time

Job summary

Robotic Technologies Automation is seeking an ETL Developer in Denver to design, implement, and optimize ETL pipelines that integrate data from diverse sources. The role focuses on data accuracy, scalable workflows, and seamless warehouse operations in a cloud-enabled environment.

You will work with data engineers and analysts to deliver reliable data for BI reporting, ensure data quality, and support migrations and deployments in enterprise systems.

Qualifications

• Hands-on experience designing, developing, and maintaining ETL pipelines.
• Strong SQL skills including complex queries and stored procedures.
• Experience with data warehousing and cloud data platforms.

Responsibilities

• Design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources.
• Build and optimize data integration workflows for structured and unstructured datasets.
• Develop complex SQL queries, stored procedures, and database scripts for data processing.
• Work with data warehouses, relational databases, and cloud-based data platforms.
• Implement data cleansing, validation, transformation, and reconciliation processes.
• Develop automated data pipelines to support business intelligence and reporting requirements.
• Integrate data from APIs, flat files, databases, and external systems.
• Monitor ETL job execution and troubleshoot data loading failures.
• Perform performance tuning to improve ETL workflow efficiency.
• Collaborate with data engineers, data analysts, and business stakeholders to understand data requirements.
• Implement data quality checks and ensure consistency across source and target systems.
• Support data migration, system upgrades, and production deployments.
• Maintain technical documentation, data mappings, and workflow specifications.
• Participate in code reviews, testing, and continuous improvement initiatives.

Skills

ETL design & development

SQL proficiency

Data integration & data quality

Analytical problem-solving

Tools

AWS Glue

Azure Data Factory

Google Cloud Dataflow

Apache Spark

PySpark

Job description

Robotic Technologies Automation is seeking an ETL Developer in Denver to design, implement, and optimize ETL pipelines that integrate data from diverse sources. The role focuses on data accuracy, scalable workflows, and seamless warehouse operations in a cloud-enabled environment.

You will work with data engineers and analysts to deliver reliable data for BI reporting, ensure data quality, and support migrations and deployments in enterprise systems.