ETL Developer

Valiant Technologies LLC; Denver (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

Valiant Technologies LLC is seeking an experienced ETL Developer to design, build, and optimize data integration pipelines across diverse sources and cloud platforms. You will work with data warehouses and modern Lakehouse architectures to ensure data accuracy and timely delivery for BI and analytics.

The role requires hands-on SQL, Spark/PySpark, and knowledge of data quality practices, with opportunities to influence enterprise data workflows and migration efforts.

Qualifications

• Hands-on experience designing and implementing ETL pipelines.
• Strong knowledge of data warehousing concepts and data modeling.
• Proficient with SQL, stored procedures, and database scripting.

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 BI 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

Data Integration

Data Warehousing

SQL Queries

Apache Spark

PySpark

Lakehouse

Data Lake

CI/CD

Agile/Scrum

Data Quality

Cloud Platforms

Tools

AWS Glue

Azure Data Factory

Google Cloud Dataflow

SQL Server

PostgreSQL

BigQuery

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.