Data Pipeline Engineer: Python, SQL & AWS (Hybrid)

Secretaria de Serviços Prefeitura de São Paulo; Herndon (VA); Hybrid; USD 100,000 - 140,000; Full time

Job summary

Systems Engineering Services Corporation (SESC) in the United States is seeking a Hybrid Python/SQL/AWS Developer to design and optimize data pipelines and analytics workloads. You will work across Reston, VA and Washington, DC, contributing to scalable data platforms and trusted reporting for key stakeholders.

You will collaborate with data analysts and developers in an Agile environment, validating data quality, maintaining documentation, and supporting CI/CD for data solutions.

Qualifications

• Strong Python programming experience; able to design and implement data pipelines.
• Advanced SQL skills with complex queries and performance tuning.
• Solid understanding of BI concepts, reporting, and analytics.
• Hands-on experience with relational databases and database design principles.
• Experience with AWS data services and cloud-based data solutions.

Responsibilities

• Design, develop, and maintain data pipelines and ETL/ELT processes using Python and SQL.
• Develop and optimize SQL queries, stored procedures, and database objects for reporting and analytics.
• Perform data mapping and data quality validation to ensure data integrity.
• Work with AWS data services (Lambda, Redshift, Iceberg, Glacier) to build scalable data solutions.
• Collaborate with stakeholders to translate business requirements into technical solutions.
• Develop, execute, and maintain test cases for data validation and ETL processes.
• Create and maintain design docs, data dictionaries, and operational procedures.
• Participate in Agile ceremonies and contribute to process improvements.
• Track work items and defects using JIRA and coordinate enhancements.
• Troubleshoot production issues, perform root-cause analysis, and implement fixes.

Skills

Python

PyTest

SQL

AWS Data Services

Jira

BI concepts

Communication skills

Self-motivated

Tools

Jira

Job description

Systems Engineering Services Corporation (SESC) in the United States is seeking a Hybrid Python/SQL/AWS Developer to design and optimize data pipelines and analytics workloads. You will work across Reston, VA and Washington, DC, contributing to scalable data platforms and trusted reporting for key stakeholders.

You will collaborate with data analysts and developers in an Agile environment, validating data quality, maintaining documentation, and supporting CI/CD for data solutions.