Senior Data Engineer - ETL (Python + Snowflake) | Remote

Bluelightconsulting; Santiago; A distancia; CLP 25.000.000 - 40.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Competitive salary and bonuses

Generous paid-time-off policy

Flexible working hours

Work remotely

Continuing education, training, and

Company-sponsored coursework, exams, &

Certifications

Descripción de la vacante

Bluelight is seeking a skilled Data Engineer to design, build, and maintain scalable ETL/ELT pipelines using Python (PySpark), Snowflake, and cloud-native tech in a dynamic consultancy environment. You will ingest data from REST APIs, databases, and cloud storage, applying dimensional modeling to support enterprise data warehouses.

Preferred candidates have Snowflake proficiency, SQL mastery, Azure experience, and a collaborative mindset to drive robust data solutions for diverse clients.

Formación

• Education: Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related field (or equivalent professional experience).
• Core Experience: Proven experience developing end-to-end data pipelines extracting/transforming/loading data from REST APIs, relational databases, cloud storage, and flat files.
• Snowflake Proficiency: Demonstrated hands-on experience with virtual warehouses, streams, tasks, stages, Snowpipe, secure data sharing, and performance optimization.
• SQL: Advanced SQL development skills with the ability to write complex queries, tune performance, and optimize large-scale workloads.
• Data Modeling: Experience with dimensional modeling techniques (star schemas, fact tables, dimension tables).

Responsabilidades

• Design, develop, and maintain scalable ETL/ELT pipelines using Python (PySpark), Snowflake, and cloud-native technologies.
• Build reliable, efficient, and reusable data ingestion, transformation, and loading processes.
• Utilize Snowflake’s architecture to design, build, and optimize modern cloud data solutions.
• Implement and manage Snowflake objects (databases, schemas, tables, views, streams, tasks, stages, stored procedures).
• Leverage virtual warehouses, data sharing, time travel, and automated scaling to balance performance and cost efficiency.
• Apply dimensional modeling (star schemas, facts, dimensions) to build scalable enterprise data warehouses.
• Extract and ingest structured and semi-structured data from REST APIs, relational databases, SaaS apps, flat files, and cloud storage.
• Develop robust ingestion frameworks.
• Collaborate with data architects and stakeholders to create logical and physical data models aligned with business goals.
• Partner with cross-functional teams (data architects, data scientists, analysts, business stakeholders) to understand requirements and provide technical expertise.

Conocimientos

Snowflake

Python

PySpark

SQL

Azure

ETL/ELT design

REST APIs

Data Modeling

CI/CD

Power BI

Educación

Bachelor’s degree in Computer Science or related field

Herramientas

Git

Azure DevOps

Snowflake UI

Descripción del empleo

Bluelight is seeking a skilled Data Engineer to design, build, and maintain scalable ETL/ELT pipelines using Python (PySpark), Snowflake, and cloud-native tech in a dynamic consultancy environment. You will ingest data from REST APIs, databases, and cloud storage, applying dimensional modeling to support enterprise data warehouses.

Preferred candidates have Snowflake proficiency, SQL mastery, Azure experience, and a collaborative mindset to drive robust data solutions for diverse clients.