ETL DATA Engineer (Python & API Development)

Dutech Systems; Austin (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Dutech Systems in Austin is seeking an experienced Data Engineer to design, build, and optimize Python-based ETL pipelines and data integration solutions. You will develop REST APIs for data ingestion and collaborate with stakeholders to deliver reliable data systems.

Responsibilities include data transformation, validation, loading into data warehouses, and implementing quality checks with robust logging and monitoring. A strong background in SQL databases and cloud platforms is required.

Qualifications

• 8+ years in ETL development, data integration, and data engineering.
• Hands-on Python for ETL development and automation.
• Designing and maintaining ETL pipelines end-to-end.
• Proven experience building and consuming REST APIs for data integration.
• Strong SQL skills with Oracle/SQL Server/PostgreSQL/MySQL.
• Experience with JSON/XML/CSV data formats and data validation.
• Experience scheduling and automating ETL workflows.

Responsibilities

• Design, develop, maintain, and support Python-based ETL pipelines and data integration solutions.
• Develop and maintain REST APIs for data ingestion and system integration.
• Extract data from databases, APIs, flat files, cloud platforms, and other sources.
• Transform, cleanse, validate, and prepare data per business requirements.
• Load data into data warehouses and reporting systems.
• Implement data validation, quality checks, logging, and performance optimization.
• Schedule and automate ETL workflows and monitor production processes.
• Troubleshoot ETL issues and optimize pipeline performance and reliability.
• Collaborate with stakeholders to deliver data solutions.
• Create technical documentation and support deployments.

Skills

ETL development

Data integration

Python

REST APIs

SQL

Data quality

Workflow automation

Airflow

CI/CD

Agile

Education

Bachelor's degree in a related field

Tools

Airflow

SSIS

Informatica

Talend

AWS

Azure

GCP

Oracle

SQL Server

PostgreSQL

Job description

Skills: ETL Development, Data Engineering, Data Integration, Python, REST APIs, API Development, SQL, Oracle, SQL Server, PostgreSQL, MySQL, JSON, XML, CSV, Data Pipelines, Data Validation, Data Quality, Error Handling, Logging, Performance Optimization, Workflow Automation, Apache Airflow, SSIS, Informatica, Talend, AWS, Azure, GCP, Data Warehousing, Dimensional Modeling, Git, CI/CD, Agile

• Design, develop, maintain, and support Python-based ETL pipelines and data integration solutions .
• Develop and maintain REST APIs for data ingestion and system integration.
• Extract data from databases, APIs, flat files, cloud platforms, and other sources.
• Transform, cleanse, validate, and prepare data based on business requirements.
• Load data into data warehouses, operational databases, and reporting systems.
• Implement data validation, quality checks, error handling, logging, and performance optimization.
• Schedule and automate ETL workflows and monitor production processes.
• Troubleshoot ETL issues and optimize pipeline performance and reliability.
• Collaborate with business stakeholders, analysts, and development teams to deliver data solutions.
• Create technical documentation and support production deployments.

Required Qualifications

• 8+ years of experience in ETL development, data integration, and data engineering.
• Strong hands-on experience with Python for ETL development and automation.
• Extensive experience designing, developing, and maintaining ETL pipelines.
• Proven experience building and consuming REST APIs for data integration.
• Strong SQL skills with experience in Oracle, SQL Server, PostgreSQL, MySQL, or similar databases.
• Experience working with JSON, XML, CSV , and other structured/unstructured data formats.
• Experience with data validation, data quality, error handling, logging, and performance optimization.
• Experience scheduling and automating ETL workflows.

Preferred Qualifications

• Experience with Apache Airflow, SSIS, Informatica, Talend , or similar ETL tools.
• Experience with AWS, Azure, or GCP cloud platforms.
• Knowledge of data warehousing and dimensional modeling concepts.
• Experience with Git, CI/CD pipelines, and Agile methodologies .