Develop and maintain ETL processes in Azure Synapse notebooks and pipelines using PySpark
Design star schema data warehouse structures in an MPP SQL pool
Extract data from REST APIs, SQL database tables, and CSV files
Implement data quality checks and validation processes
Tune ETL notebooks and pipelines to meet SLAs and fix bottlenecks
From the employer’s posting
Develop and maintain ETL data engineering processes using Python (PySpark) within Azure Synapse Analytics Notebooks, and/or Azure Synapse Analytics Pipelines
design and build effective data storage structures in a Massively Parallel Processing (MPP) SWL Pool
Extract data from various sources, including REST APIs, SWL database tables, and CSV files
Implement data quality checks and validation processes
Identify and resolve performance bottlenecks and optimize ETL data notebooks/pipelines to meet SLAs
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.
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).
Preferred experience
Familiarity with big data technologies, machine learning, and data analysis preferred.
Qualification wording
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).
Familiarity with big data technologies, machine learning, and data analysis preferred.
Education & alternatives
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.
Open 5 monthsWe first saw this posting 171 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
Status in our records
Live
First seen by us
Jun 3, 2026171 days ago
Recorded sightings
127
Last seen by us
Nov 21, 2026
Jun 3, 2026today
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
Time since we first saw it
Day 171
656
Up longer than most. Similar jobs usually come down between day 6 and day 56.
Well past Bluelightconsulting’s usual: its jobs come down by about day 17.
From 14,770 similar postings that came down, and 168 of Bluelightconsulting’s. Coming down is not always a hire.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Python
SQL
Azure
Power BI
Tableau
PySpark
Where the posting names them
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
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.
- 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.
- 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.
- 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.
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.
- 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.
- 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.
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
Employment type
Full-Time
Demand for Data Engineer roles
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
Pay
No pay amount identified in the saved description.
Location & working pattern
Valparaíso, Chile
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
Employment type
Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.