Azure Data Engineer - ETL & Synapse Expert

Bluelightconsulting; Colombia; A distancia; COP 89.280.000 - 156.240.000; Jornada completa

Descripción de la vacante

Bluelight is seeking an ETL Data Engineer to design, develop and maintain data integration pipelines using Python (PySpark) and Azure Synapse Analytics. You will work closely with data scientists and analysts to deliver reliable, scalable data for reporting and insights, while optimizing notebooks and pipelines and ensuring data quality and governance across the business across the Americas.

You will optimize ETL notebooks and pipelines, implement data quality checks, model data, and ensure

Formación

• ,

Responsabilidades

• ETL Data Engineering: Develop and maintain ETL data engineering processes using Python (PySpark) within Azure Synapse Analytics Notebooks, and/or Azure Synapse Analytics Pipelines, to ensure efficient data extractions, transformation, and loading.
• Data Warehousing: Apply your expertise in data warehousing, understanding star schemas, facts, and dimensions, to design and build effective data storage structures in a Massively Parallel Processing (MPP) SWL Pool.
• Data Source Expertise: Extract data from various sources, including REST APIs, SWL database tables, and CSV files.
• Azure Synapse Analytics Expertise: Utilize your deep knowledge of Azure Synapse Analytics to design and optimize data notebooks/pipelines for scalability and performance.
• Data Fabric Concepts: Contribute to the implementation and understanding of other Data Fabric concepts, such as data lakes, lakehouses, delta lakes, and data cataloging, to enhance data management capabilities.
• Data Modeling: Collaborate with data architects to create data models and schemas that align with business requirements.
• Data Quality: Implement data quality checks and validation processes to maintain data accuracy and consistency.
• Performance Tuning: Identify and resolve performance bottlenecks and optimize ETL data notebooks/pipelines to meet SLAs.
• Monitoring and Troubleshooting: Monitor ETL jobs, diagnose issues, and implement solutions to ensure data pipeline reliability.
• Documentation: Maintain comprehensive documentation of ETL data engineering processes, data flows, and data transformations.
• Collaboration: Work closely with cross‑functional teams to understand data requirements and provide support for data‑related initiatives.
• Security and Compliance: Ensure data security and compliance with data governance and privacy standards.

Conocimientos

ETL Engineering

SQL queries

Data modeling

Data quality

Communication

Team collaboration

Educación

Bachelor’s degree in Computer Science / Information Technology

Herramientas

Azure Synapse Analytics

Azure Synapse Notebooks

Azure Synapse Pipelines

Linked Services

Azure Key Vault

Power BI

Tableau

Descripción del empleo

Bluelight is seeking an ETL Data Engineer to design, develop and maintain data integration pipelines using Python (PySpark) and Azure Synapse Analytics. You will work closely with data scientists and analysts to deliver reliable, scalable data for reporting and insights, while optimizing notebooks and pipelines and ensuring data quality and governance across the business across the Americas.

You will optimize ETL notebooks and pipelines, implement data quality checks, model data, and ensure