Data Engineer – Salesforce, Snowflake

This is a fully remote position, open to applicants in Colombia, +4 more countries.

📋 Description

• Design, construct, and enhance dependable data pipelines and analytical data models for GTM operations, enterprise reporting, and Data Science projects.

• Create, develop, and sustain scalable batch ETL/ELT pipelines featuring hourly and daily incremental loads.

• Acquire and integrate data from multiple enterprise and SaaS sources into Snowflake and AWS data lakes.

• Develop and advance dimensional and domain-focused analytical Data Mesh models that support GTM functions and Salesforce integrations.

• Enhance distributed data processing and optimize SQL query performance across extensive datasets.

• Establish automated data quality checks, pipeline testing, monitoring, and alerting within Git-managed CI/CD workflows.

• Collaborate with Data Science and Machine Learning teams to implement curated datasets and feature sets into production.

• Articulate architectural choices, data contracts, and project progress to both technical and non-technical GTM stakeholders.

• Work according to US Central Time business hours, engage in daily standups, and participate in live architectural syncs.

⛳️ Requirements

• Bachelor’s degree with over 5 years of relevant data engineering experience, or a Master’s degree with at least 3 years of experience.

• Proficient SQL skills.

• Practical experience in Python, Java, or Scala.

• Significant experience with both relational and NoSQL databases.

• Essential production experience with Snowflake and AWS while managing modern data warehouses or lakehouses.

• Extensive expertise in Apache Airflow or similar enterprise scheduling tools.

• In-depth knowledge of hourly/daily incremental loading techniques, query optimization, and distributed processing involving millions of rows and data sizes ranging from hundreds of GB to low TB.

• Strong grounding in dimensional and analytical data modeling, including scalable domain-oriented models.

• Practical experience in developing ETL/ELT pipelines that integrate AWS, Snowflake, and Salesforce.

• Familiarity with automating data validation, monitoring/alerting, Git version control, and CI/CD pipelines.

• Experience using AI-assisted coding tools such as Cursor and Claude.

• Proficiency in English for interviews, technical documentation, architectural reviews, daily team syncs, and operational communications.

• Preferred: Experience with Salesforce-to-Snowflake integration, Salesforce object model, API rate limits, incremental extraction, handling deleted records, SaaS API ingestion, Kafka, dbt, data catalogs, data observability platforms, ML pipelines or feature stores, online marketplaces, search, advertising, recommendation systems, Terraform, and Kubernetes.

🏝️ Benefits

• Fully remote work environment.

• Full-time contractor engagement directly managed by In All Media.

• Alignment with US Central Time.

• Opportunity to collaborate with international clients and distributed teams globally.