#127646 - Data Engineer
Lifted, an Upwork Company™ · Bogotá, Bogota D.C., Colombia
Technology, Information and Internet · 201-500 employees
About the role
The Data Engineer will build and maintain production data pipelines and optimize ETL/ELT workflows for Go-to-Market revenue operations. They will also model complex business data, ensure data quality, and collaborate with engineering and product teams to support analytics.
What they look for
Requirements
Candidates must have strong hands-on experience with SQL, Snowflake, Python, and cloud data platforms like GCP or AWS. Experience with data transformation tools such as dbt or Airflow and familiarity with CRM data structures are also required.
Full description
Job Description
We are seeking a hands-on Data Engineer to build and maintain the data infrastructure and intelligence layer supporting Go-to-Market revenue operations. This role will work with Snowflake, cloud data platforms, CRM data, and ETL/ELT pipelines to support lead routing, identity resolution, campaign segmentation, revenue analytics, and sales tooling.
 
The ideal candidate can independently develop reliable data pipelines, model complex business data, optimize queries, and maintain high standards for data quality and schema management.
 
Enterprise experience strongly preferred.
 
KEY RESPONSIBILITIES
 
* Build and maintain production data pipelines across Snowflake, cloud data platforms, and Salesforce-related data environments.
* Develop and optimize ETL/ELT workflows for transforming and integrating business data.
* Model and maintain Go-to-Market data assets, including parent-company relationships, advertiser identity, lead enrichment, and revenue data.
* Write and optimize SQL queries for reporting, analytics, and operational use cases.
* Use Python to transform, validate, and automate data-processing workflows.
* Support data quality, validation, schema management, and troubleshooting across data marts.
* Identify and resolve data inconsistencies across source systems and downstream datasets.
* Collaborate with engineers and product managers on technical deliverables.
* Participate in Jira-based planning, tracking, and delivery workflows.
Qualifications
MUST-HAVE SKILLS
 
* Strong hands-on SQL experience, including complex queries and query optimization.
* Strong production experience with Snowflake.
* Strong Python scripting experience for data transformation and processing.
* Experience developing and maintaining ETL or ELT data pipelines.
* Experience with dbt, Airflow, or a comparable transformation or orchestration platform.
* Hands-on experience with a GCP or AWS cloud data platform.
* Familiarity with CRM data structures, including leads, contacts, accounts, and opportunities.
* Experience supporting data quality, validation, or schema-management activities.
* Ability to collaborate effectively with engineering and product stakeholders.
 
NICE-TO-HAVE SKILLS
 
* Experience writing Salesforce SOQL queries.
* Experience with Salesforce Data Cloud.
* Knowledge of Salesforce data models.
* Experience with ZoomInfo or Dun & Bradstreet data enrichment.
* Experience supporting Go-to-Market or revenue analytics.
* Experience with lead enrichment, identity resolution, campaign segmentation, or sales operations data.
Additional Information
REQUIRED TOOLS AND PLATFORMS
 
* SQL
* Snowflake
* Python
* dbt, Airflow, or a similar ETL/ELT platform
* GCP or AWS
* CRM data environments
* Jira
 
LOCATION, TIME, AND ENGAGEMENT
 
* Remote contract engagement.
* Applicants must be located in LATAM.
* Full-time commitment of 40 hours per week.
* Required working hours are 9:00 a.m. to 5:00 p.m. U.S. Central Time.
* Contract end date is March 31, 2027.
