ETL Data Engineer: Python/PySpark, Azure to Snowflake

Ellenco Estágios e Treinamentos; Bala Cynwyd (PA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Ellenco Estágios e Treinamentos is seeking a hands-on ETL Data Engineer to design and optimize scalable, cloud-native data pipelines using Python, PySpark, and Azure data services. This role emphasizes modern data warehouse architecture and high-performance processing in a changing Snowflake-oriented environment.

You will leverage Azure Synapse and Data Factory to build robust ELT workflows, integrate diverse data sources, and support BI tools like Power BI and Tableau in a hybrid work setting.

Qualifications

• Strong Python and PySpark experience.
• Deep ETL pipeline development and optimization.
• Strong SQL skills and query tuning.
• Experience with Azure data services (Synapse, Data Factory).
• Knowledge of data warehousing concepts and dimensional modeling.
• Familiarity with lakehouse patterns and cloud migrations is a plus.
• Excellent communication with technical and non-technical stakeholders.

Responsibilities

• Design, build, and maintain scalable ETL data pipelines using Python and PySpark.
• Develop and optimize ETL workflows within Microsoft Azure ecosystem.
• Leverage Azure Synapse Analytics for pipelines, notebooks, and distributed data processing.
• Build and manage data workflows using Azure Data Factory, including linked services, triggers, and monitoring.
• Develop secure and efficient data solutions leveraging Azure Key Vault.
• Integrate data from multiple sources including REST APIs, relational databases, flat files (CSV), and external systems.
• Design and implement scalable data warehouse models using star schema and dimensional modeling best practices.
• Ensure data quality, governance, lineage, security, and performance tuning across pipelines.
• Collaborate with data architects, analysts, and stakeholders to translate requirements into scalable data solutions.
• Support reporting and analytics use cases across tools such as Power BI and Tableau.
• Participate in modernization efforts including lakehouse architectures, Git-based development, and Azure DevOps CI/CD workflows.
• Explore and apply hands-on AI/ML techniques for data enrichment and automation.

Skills

Python

PySpark

SQL

ETL

Data warehousing

Dimensional modeling

Star schema

Azure Synapse

Azure Data Factory

Power BI/Tableau

CI/CD

Git

Communication

Tools

Azure Synapse Analytics

Azure Data Factory

Power BI

Tableau

Job description

Ellenco Estágios e Treinamentos is seeking a hands-on ETL Data Engineer to design and optimize scalable, cloud-native data pipelines using Python, PySpark, and Azure data services. This role emphasizes modern data warehouse architecture and high-performance processing in a changing Snowflake-oriented environment.

You will leverage Azure Synapse and Data Factory to build robust ELT workflows, integrate diverse data sources, and support BI tools like Power BI and Tableau in a hybrid work setting.