Data Engineer, Azure - Remote, Latin America

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 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.

We are looking for a skilled individual to join our rapidly growing team at Bluelight. This position is ideal for someone who thrives in a fast-paced, dynamic environment where everyone's opinions and efforts are valued and appreciated. You will have the opportunity to contribute to challenging and meaningful projects, developing high-quality applications that stand out in the market. We value continuous learning, personal growth, and hard work, offering a collaborative environment that promotes professional development.

Key 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.

Required Skills & 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.

Company Benefits

• Competitive salary and bonuses, including performance-based salary increases.

• Generous paid-time-off policy

• Flexible working hours

• Work remotely

• Continuing education, training, conferences

• Company-sponsored coursework, exams, and certifications

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!