Aworkado
Data Engineer (Salesforce / Snowflake Focus) 2153/2154In All Media
Apply now

Data Engineer (Salesforce / Snowflake Focus) 2153/2154

  • Location: Colombia, Costa Rica + 3 more
  • Workplace: Remote
  • Job type: Contract
  • Posted: Posted

  • Architect and scale data pipelines for GTM and Data Science
  • Requires 5+ years experience with Snowflake, AWS, and SQL
  • Salesforce integration and Airflow orchestration preferred
  • Remote in Colombia, Costa Rica, Argentina, Peru, or Nicaragua
  • Full-time contractor aligned with US Central Time

📌 Position: Data Engineer (Salesforce & Snowflake Focus)

📍 Location: Remote (Aligned with US Central Time)

📄 Contract Type: Full-time Contractor (Contract directly with In All Media)

🕒 Time Zone Alignment: US Central Time (CT)

🧭 About In All Media

In All Media is a global technology and design firm focused on building impactful digital solutions through remote, distributed teams worldwide. We partner with international clients across industries, providing long-term technical expertise, product innovation, and team augmentation.

Contract Details: This is a 100% remote contractor position. Your contract and engagement will be directly managed with In All Media.

🚀 Project Overview

In this role, you will architect, build, and scale reliable data pipelines and analytical data models that power Go-To-Market (GTM) operations, enterprise reporting, and Data Science initiatives. Operating within an AWS and Snowflake ecosystem, you will lead multi-source ETL/ELT integrations—with a strong focus on Salesforce and SaaS data flows—while enforcing rigorous data quality, CI/CD best practices, and high-performance query optimization across high-volume datasets.

🔍 Key Responsibilities

  • Batch ETL/ELT Pipeline Engineering: Design, build, and maintain scalable, reliable batch pipelines (hourly and daily incremental loads) that ingest and integrate multi-source enterprise and SaaS data into Snowflake and AWS data lakes.
  • Data Mesh & Analytical Data Modeling: Design, build, and evolve scalable dimensional and domain-oriented analytical data models—specifically structuring common Data Mesh domain models supporting GTM business functions and Salesforce integrations.
  • Performance & Query Tuning: Optimize large-scale distributed data processing and SQL query performance across tables spanning tens of millions of rows and hundreds of gigabytes (GB) to low terabytes (TB).
  • Data Quality, Testing & Observability: Own end-to-end data reliability by implementing automated data quality validation, pipeline testing, monitoring, and alerting within Git version-controlled CI/CD workflows.
  • ML & Data Science Enablement: Partner with Data Science and Machine Learning teams to productionize curated datasets and feature sets for downstream modeling.
  • Cross-Functional Collaboration: Communicate architectural decisions, data contracts, and delivery progress clearly with both technical engineering peers and non-technical GTM stakeholders.

💡 Must-Have Skills

  • Education & Hands-On Experience: Bachelor’s degree with 5+ years of related data engineering experience, or a Master’s degree with 3+ years of experience.
  • Core Programming & Databases: Strong SQL skills paired with hands-on proficiency in Python, Java, or Scala, plus extensive experience working across relational, SQL, and NoSQL databases.
  • Snowflake & AWS Cloud Platforms: Mandatory production experience with Snowflake and AWS managing modern data warehouses or lakehouses.
  • Workflow Orchestration: Deep expertise in pipeline orchestration frameworks such as Apache Airflow (or equivalent enterprise schedulers).
  • Large-Scale Batch & Distributed Processing: Expert understanding of incremental loading strategies (hourly/daily), query/performance tuning, and distributed processing across datasets with tens of millions of rows (hundreds of GB to low TB).
  • Analytical Data Modeling: Strong foundation in dimensional and analytical data modeling, including designing scalable domain-oriented models.
  • Multi-Source & Salesforce Integration: Hands-on experience building ETL/ELT pipelines integrating diverse data sources across AWS, Snowflake, and Salesforce.
  • Engineering Best Practices & AI Tooling: Proven track record enforcing automated data validation, monitoring/alerting, Git version control, CI/CD pipelines, and leveraging AI-assisted coding tools (Cursor, Claude) to accelerate development, debugging, and documentation.

🌟 Nice-to-Have Skills

  • Salesforce-to-Snowflake Integration (Strongly Preferred): Direct experience extracting Salesforce data into Snowflake at scale—including deep familiarity with the Salesforce object model, API rate limits, incremental extraction, and deleted-record handling.
  • SaaS API Ingestion: Strong Snowflake and Airflow background pulling data from external SaaS APIs (managing rate limits, incremental watermarks, and schema drift).
  • Streaming & Modern Data Stack: Operational familiarity with event streaming (Apache Kafka or similar), dbt, data catalogs, or data observability platforms.
  • ML Infrastructure & Domain Background: Experience supporting ML pipelines or feature stores, or prior background in online marketplaces, search, advertising, or recommendation systems.
  • Infrastructure as Code (IaC) & Containers: Hands-on experience with Terraform and Kubernetes.

🌐 Time Zone & Collaboration

This role requires full-time business-hour alignment with US Central Time (CT) to ensure real-time collaboration with US engineering leadership, active participation in daily standups, and live architectural syncs.

💬 Language

All interviews, technical documentation, architectural reviews, daily team syncs, and operational communications will be conducted in English.

Apply now

About the job

Location

Colombia
Costa Rica
Argentina
Peru
Nicaragua

Job type

Contract

Workplace

Remote

Experience

Senior

First posted on

In All MediaIn All Media

Imagine the future of business. Ideas for a Digital Renaissance.

Company size

1,001-5,000 employees

Founded in

2015

Industry

Information Technology & Services

Headquarters

Austin, Texas

Social media

Company profileVisit inallmedia.com

Similar remote jobs

View all remote jobs
Senior
Full Time
Remote
Muttdata
MuttdataPosted
Colombia
United States
Data Engineer, Ai & Analytics
Mid-level
Full Time
Remote
Power Digital Marketing
Power Digital MarketingPosted
Argentina
United States
Data Engineer, Ai & Analytics
Mid-level
Full Time
Remote
Power Digital Marketing
Power Digital MarketingPosted
Mid-level
Full Time
Remote
Power Digital Marketing
Power Digital MarketingPosted
Senior
Full Time
Remote
SunnyData
SunnyDataPosted
Senior
Full Time
Remote
SunnyData
SunnyDataPosted