Remote Data Engineer: Azure Synapse + PySpark

Bluelight Consulting LLC

Culiacán

Híbrido

MXN 420.000 - 720.000

Jornada completa

14 días+

Consigue una respuesta de este empleador

Tu currículum y tu carta de presentación, adaptados exactamente a lo que buscan contratar.

Supera los filtros ATS

Descripción de la vacante

Bluelight Consulting LLC in Mexico is seeking an ETL Data Engineer to design, develop, and maintain data integration workflows using Python (PySpark) and Azure Synapse Analytics. You will collaborate with data scientists and analysts to ensure accurate, timely data for business insights.

The role emphasizes scalable data architectures, data quality checks, and adherence to security and governance standards.

Formación

  • Experience in ETL data engineering using Python to extract, transform, and load from REST APIs, SQL databases, and CSV files.
  • Proficiency with Azure Synapse Analytics resources such as Notebooks and Pipelines.
  • Familiarity with data governance, data quality checks, and collaboration with data scientists and analysts.

Responsabilidades

  • Develop and maintain ETL data pipelines using Python (PySpark) within Azure Synapse Analytics.
  • Design data warehouses with star schemas and manage data models.
  • Extract data from REST APIs, SQL databases, and CSV files.
  • Optimize pipelines for performance and SLA adherence.
  • Monitor jobs, troubleshoot, and ensure data reliability.
  • Document data flows and collaborate with cross-functional teams.

Conocimientos

Data engineering
Python (PySpark)
SQL
Problem solving
Communication

Educación

Bachelor’s degree in Computer Science, Information Technology, or a related field

Herramientas

Azure Synapse Analytics
Azure Notebooks
Azure Pipelines
Power BI
Tableau
Git / Azure DevOps

Descripción del empleo

Bluelight is a leading software consultancy dedicated to designing and developing innovative technology that enhances users' lives. With a steadfast commitment to delivering exceptional service to our clients, Bluelight excels in its focus on quality and customer satisfaction. Our mission is not only to create cutting-edge applications but also to foster a collaborative and enriching work environment where each team member can grow and thrive. With a presence across the United States and Central/South America, Bluelight is in an exciting phase of expansion, continually seeking exceptional talent to join its dynamic and diverse community.

As an ETL Data Engineer, you will play a critical role in our client’s expanding data engineering team, designing, developing, and maintaining data integration processes primarily using Python (PySpark) and Azure Synapse Analytics to ensure the accuracy and availability of analytical data. Working closely with data scientists, analysts, and other stakeholders to deliver high-quality data for insights and decision-making, this position is ideal for a passionate software development professional who thrives in a fast-paced, dynamic environment where everyone's opinions and efforts are valued. By joining our client’s growing software consultancy, you will have the opportunity to contribute to challenging, market-standing projects within a collaborative community that deeply values hard work, continuous learning, personal growth, and professional development.


Responsibilities
  • 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: Monitoring 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.
Qualifications
  • Bachelor’s degree in Computer Science, Information Technology, or a related field; or equivalent work experience, with certifications related to data engineering or data science (e.g. Azure Data Engineer) being a plus.
  • Proven experience in ETL data engineering with significant expertise in using Python (PySpark) to perform data extraction, transformation, and loading from REST APIs, SQL database tables, and CSV files.
  • Proficiency in using Azure Synapse Analytics resources including Notebooks, Pipelines, Linked Services, and Azure Key Vault.
  • Demonstrated ability to write complex SQL queries, optimize query performance, and work with both SparkSQL and MS SQL to effectively extract, transform, and load data.
  • Knowledge of data integration best practices and tools.
  • Experience with version control systems, such as Git (Azure DevOps).
  • Strong problem-solving and analytical skills, with a keen attention to detail.
  • Excellent communication skills, both verbal and written, with the ability to work collaboratively in a team environment with shifting priorities.
  • Familiarity with big data technologies, machine learning, and data analysis preferred.
  • Experience with data visualization tools (e.g. Power BI, Tableau) and Agile Methodologies a plus.

Being a consultant in our team is a fun, challenging, and rewarding career choice. Your contributions are highly valued by clients, and the work you do often has a direct and significant impact on their business.

You will have the opportunity to work on a variety of projects for our incredible clients, which will accelerate your career growth. You’ll collaborate with modern technologies and work alongside some of the best professionals in the industry!

If you’re eager to be part of an exciting, challenging, and rapidly growing consultancy, we encourage you to apply. #LI-Remote

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Remote Data Engineer: Azure Synapse & PySpark
Remote Data Engineer: Azure Synapse & PySpark

Bluelight Consulting LLC • Chihuahua

Híbrido
MXN 600.000 - 1.100.000
Remote Azure Data Engineer: ETL & PySpark on Synapse
Remote Azure Data Engineer: ETL & PySpark on Synapse

Bluelight Consulting LLC • México

Híbrido
PHP 5.552.127 - 8.636.643
Remote Azure Data Engineer - PySpark & Synapse ETL
Remote Azure Data Engineer - PySpark & Synapse ETL

Bluelight Consulting LLC • Guanajuato

A distancia
MXN 1.046.389 - 2.092.779
Remote Data Engineer – Azure PySpark & ETL
Remote Data Engineer – Azure PySpark & ETL

Bluelight Consulting LLC • Mexicali

A distancia
MXN 400.000 - 700.000
Remote Azure PySpark Data Engineer
Remote Azure PySpark Data Engineer

Bluelight Consulting LLC • Región Centro, Chihuahua

Híbrido
MXN 782.881 - 1.304.802
Collaborative work environment
Opportunity for professional growth
Valued contributions to client projects
Remote Azure PySpark Data Engineer
Remote Azure PySpark Data Engineer

Bluelight Consulting LLC • Región Centro

A distancia
MXN 519.120 - 865.201
Remote Azure PySpark Data Engineer
Remote Azure PySpark Data Engineer

Bluelight Consulting LLC • Saltillo

Híbrido
MXN 1.211.282 - 1.557.362
Remote Azure PySpark Data Engineer - ETL & Analytics
Remote Azure PySpark Data Engineer - ETL & Analytics

Bluelight Consulting LLC • Monterrey

A distancia
MXN 600.000 - 1.200.000
Remote Azure Data Engineer: ETL & Synapse Expert
Remote Azure Data Engineer: ETL & Synapse Expert

Bluelight Consulting LLC • Mérida

A distancia
MXN 873.667 - 1.223.134
Remote Azure Data Engineer: ETL & Synapse Expert
Remote Azure Data Engineer: ETL & Synapse Expert

Bluelight Consulting LLC • Aguascalientes

Híbrido
MXN 698.934 - 1.048.401