Azure Data Engineer — Synapse & ETL Expert (Remote)

Logoslabs; San Francisco (CA); Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive salary and bonuses

Generous paid-time-off

Flexible working hours

Work remotely

Continuing education, training, and/or

Company-sponsored coursework, exams, &

Job summary

Bluelight is seeking a Data Engineer to design and optimize ETL pipelines using PySpark within Azure Synapse. You will build scalable data warehouses, source data from REST APIs, SQL databases, and CSV files, and collaborate with architects on data models.

You will ensure data quality, implement governance, and monitor pipelines to meet SLAs in a dynamic, remote-friendly environment. Strong SQL, Azure Synapse, and BI tool experience required.

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field (or equivalent experience) with data eng certifications a plus.
• Strong experience using PySpark for ETL from REST APIs, SQL tables, and CSV files.
• Proficiency with Azure Synapse resources: Notebooks, Pipelines, Linked Services, Key Vault.
• Demonstrated ability to write complex SQL (SparkSQL and MS SQL) and optimize queries.
• Knowledge of data integration best practices and tools.
• Experience with version control systems such as Git (Azure DevOps).
• Excellent communication and collaboration in cross-functional teams.

Responsibilities

• ETL Data Engineering: Build and maintain PySpark ETL pipelines in Azure Synapse notebooks/pipelines.
• Data Warehousing: Design star schemas and facts/dimensions in an MPP SWL pool.
• Data Source Expertise: Retrieve data from REST APIs, SWL tables, and CSV files.
• Azure Synapse Analytics Expertise: Design and optimize notebooks/pipelines for performance.
• Data Fabric Concepts: Implement data lakes, lakehouses, delta lakes, and data cataloging.
• Data Modeling: Collaborate with data architects on models and schemas.
• Data Quality: Implement validation checks and data quality controls.
• Performance Tuning: Identify bottlenecks and optimize ETL jobs to meet SLAs.
• Monitoring and Troubleshooting: Monitor ETL jobs and resolve issues.
• Documentation: Maintain comprehensive data flows and transformations docs.
• Collaboration: Work with cross-functional teams to meet data requirements.
• Security and Compliance: Ensure data governance and privacy standards.

Skills

PySpark

Azure Synapse Analytics

SQL

Data Modeling

Data Quality

Monitoring & Troubleshooting

Git / Azure DevOps

Communication

Problem-solving

Agile Methodologies

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

Tableau

Azure Synapse Analytics Notebooks

Azure Synapse Pipelines

Git

Job description

Bluelight is seeking a Data Engineer to design and optimize ETL pipelines using PySpark within Azure Synapse. You will build scalable data warehouses, source data from REST APIs, SQL databases, and CSV files, and collaborate with architects on data models.

You will ensure data quality, implement governance, and monitor pipelines to meet SLAs in a dynamic, remote-friendly environment. Strong SQL, Azure Synapse, and BI tool experience required.