ETL Developer

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

We are seeking a skilled ETL Developer with strong expertise in data integration, data warehousing, and database development. The ideal candidate should have hands-on experience in designing, developing, and maintaining ETL pipelines, performing data transformations, and managing large-scale data processing solutions. The role involves ensuring data accuracy, optimizing workflows, and supporting enterprise data warehouse environments.

Roles & 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.

Preferred Qualifications:

• Knowledge of AWS Glue, Azure Data Factory, or Google Cloud Dataflow.
• Experience with Apache Spark and PySpark.
• Understanding of Data Lake and Lakehouse architectures.
• Familiarity with CI/CD pipelines and automated deployment.
• Knowledge of Agile/Scrum methodologies.
• Strong analytical and problem-solving skills.

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.