Data Engineer: Python + SQL ETL Pipelines

Robotic Technologies Automation; Alpharetta (GA); Presencial; USD 83.000 - 131.000; Jornada completa

Descripción de la vacante

ROBOTIC PROCESS AUTOMATION LLC is seeking a Data Engineer to design, build, and maintain robust ETL pipelines using Python and SQL in Alpharetta, GA. You will develop reusable scripts for data extraction, transformation, and loading, and ensure clean, reliable datasets for analytics and reporting.

The role requires expert SQL skills, experience with multiple databases (PostgreSQL, MySQL, SQL Server), and familiarity with Power BI integration and migration tasks.

Formación

• Hands-on years of experience designing, building, and maintaining robust data pipelines using Python and SQL.
• Expert in writing complex SQLs and optimizing database interactions.
• Experience integrating data from diverse sources including APIs and multiple databases.
• Experience creating reusable ETL scripts for data extraction, transformation, and loading.
• Knowledge of data validation, version control (Git), and performance tuning.

Responsabilidades

• Design, build, and maintain robust data pipelines using Python and SQL.
• Write optimized, scalable SQL queries and stored procedures.
• Integrate data from APIs and multiple databases into unified ETL workflows.
• Collaborate with analysts, data scientists, and business stakeholders to provide clean datasets.
• Document data workflows and enforce best practices in coding and version control.

Conocimientos

Python

SQL

APIs

Git

Shell scripting

Data validation

Performance tuning

Power BI

Herramientas

PostgreSQL

MySQL

SQL Server

Descripción del empleo

ROBOTIC PROCESS AUTOMATION LLC is seeking a Data Engineer to design, build, and maintain robust ETL pipelines using Python and SQL in Alpharetta, GA. You will develop reusable scripts for data extraction, transformation, and loading, and ensure clean, reliable datasets for analytics and reporting.

The role requires expert SQL skills, experience with multiple databases (PostgreSQL, MySQL, SQL Server), and familiarity with Power BI integration and migration tasks.