Senior Data Engineer: Snowflake & AI-Powered Pipelines

Lifted (an Upwork Company); Colombia; Remote; COP 267,530,000 - 423,589,000; Full time

Job summary

Lifted (an Upwork Company) is seeking an experienced Data Engineer to design and maintain secure, scalable data pipelines and analytics-ready datasets supporting people insights. This role blends hands-on engineering with data modeling, platform reliability, semantic-layer design, and governed access for BI tools and AI-enabled interfaces.

You will work with Snowflake, dbt, Python, PySpark, and Airflow to build warehouse models, data quality tests, and governed AI-ready data experiences.

Qualifications

• 5+ years of relevant data-engineering experience.
• Snowflake data modeling, datamarts, and warehouse design.
• dbt experience for data transformations.
• Strong Python experience with OOP.
• Airflow experience for pipeline orchestration.
• Experience with REST APIs and external data ingestion.
• BigQuery querying and optimization.
• Secure handling of large-scale sensitive data.
• Real-time or near-real-time data processing.
• Strong SQL and highly optimized queries.
• Excellent technical documentation skills.
• Advanced English communication skills.

Responsibilities

• Develop and maintain secure, efficient data pipelines.
• Build ETL using Python, dbt, Terraform, AWS services.
• Ingest data from APIs, cloud systems, and Google Sheets.
• Create Snowflake warehouse models and datamarts.
• Develop data-quality tests and improve processes.
• Monitor pipelines to maintain uptime.
• Design semantic views, ontology layers.
• Build governed data experiences with LLM-native interfaces.
• Configure secure data-source interfaces for internal AI tooling.
• Document data models, pipelines, and decisions comprehensively.

Skills

5+ years experience

Snowflake data modeling

dbt data transformations

Python / PySpark

Airflow orchestration

REST API data ingestion

BigQuery querying

security of sensitive data

real-time data processing

SQL optimization

technical documentation

English communication

Tools

Snowflake

dbt

Python

PySpark

Airflow

Google BigQuery

REST APIs

Terraform

AWS Glue / EMR

S3

Job description

Lifted (an Upwork Company) is seeking an experienced Data Engineer to design and maintain secure, scalable data pipelines and analytics-ready datasets supporting people insights. This role blends hands-on engineering with data modeling, platform reliability, semantic-layer design, and governed access for BI tools and AI-enabled interfaces.

You will work with Snowflake, dbt, Python, PySpark, and Airflow to build warehouse models, data quality tests, and governed AI-ready data experiences.