Data Engineer

Formulated Automation

Medellín

Remote

COP 232,411,000 - 365,218,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Formulated Automation is seeking a Data Engineer in Latin America to design and maintain scalable data pipelines and ELT workflows. You will ingest data from various sources, transform with SQL/dbt, and build robust data models.

You will work with marketers, analysts, and product managers to translate requirements, while adhering to CI/CD and governance standards. Proficiency in Python and SQL is essential.

Qualifications

  • 2+ years of experience as a Data Engineer in a production cloud environment.
  • Hands-on experience with at least one major cloud platform (AWS, GCP, or Azure).
  • Experience building SQL-based ELT workflows using version-controlled models (dbt or similar).
  • Strong Python programming skills for data engineering tasks.
  • Advanced SQL skills, including query optimization and performance tuning.
  • Experience querying, parsing, and flattening nested JSON data using SQL.
  • Familiarity with data from CRM systems, marketing automation platforms, web analytics, or advertising platforms.
  • Working knowledge of managed data services and data lake architectures within at least one major cloud provider.
  • Familiarity with Git, version control, and code review practices.
  • Comfortable using AI coding assistants as part of the development workflow.
  • Strong written and verbal communication skills to explain technical concepts to non-technical stakeholders.

Responsibilities

  • Build Data Pipelines & Systems: Design, build, and implement scalable, secure, and high-performance data pipelines.
  • Develop ELT Workflows: Load raw data into cloud data warehouses and transform it using SQL and dbt.
  • Work with Semi-Structured Data: Ingest webhook and API payloads through queues, API gateways, or managed ingestion tools.
  • Develop with Python: Build and maintain custom connectors, automation scripts, and transformation logic.
  • Design Data Models: Create and maintain schemas for cloud data warehouses and relational databases.
  • Support Identity Resolution: Contribute to data models that connect user identifiers for Customer 360 and attribution initiatives.
  • Manage Cloud Infrastructure: Deploy and maintain data infrastructure and object storage across AWS, GCP, or Azure.
  • Optimize Performance & Costs: Monitor database performance, optimize queries, implement indexing, and balance warehouse performance and costs.
  • Ensure Data Quality & Reliability: Implement data quality checks, monitoring, and alerting.
  • Collaborate with Stakeholders: Translate requirements from marketers, analysts, and product managers into reliable data structures.
  • Follow Engineering Best Practices: Participate in code reviews, use CI/CD workflows, write data tests, and follow privacy and governance standards.

Skills

Data Pipelines
ELT Workflows
Python
SQL
Cloud Platforms
Data Modeling
Data Quality
CI/CD
Git

Tools

dbt
Cloud Services (AWS/GCP/Azure)

Job description

Hi there! We are South and our client is looking for a Data Engineer!

Note To Applicants
  • Eligibility: This position is open to candidates residing in Latin America.
  • Application Language: Please submit your CV in English. Applications submitted in other languages will not be considered.
  • Professional Presentation: We encourage you to showcase your professional experience by including a Loom video in the application form. While this is optional, candidates who provide a video presentation will be given priority.
  • Interview Policy: The use of artificial intelligence (AI) tools during interviews are strictly prohibited.
  • Note: As part of the final stages of the selection process, contractors may be asked to provide professional references for a reference check. If you're selected, you may also be asked to update their LinkedIn profile.
About The Role

We help clients get more value from their analytics and marketing data. As a Data Engineer, you will build and maintain the data pipelines, infrastructure, and models that power these initiatives.

You will work on client engagements alongside strategists, architects, and fellow engineers to design and implement scalable, reliable, and efficient data solutions.

Key Responsibilities
  • Build Data Pipelines & Systems: Design, build, and implement scalable, secure, and high-performance data pipelines based on architectural guidance. Ingest data from databases and marketing APIs, handling rate limits, pagination, and incremental loads.
  • Develop ELT Workflows: Load raw data into cloud data warehouses and transform it using SQL and dbt.
  • Work with Semi-Structured Data: Ingest webhook and API payloads through queues, API gateways, or managed ingestion tools. Parse and flatten nested JSON within the data warehouse.
  • Develop with Python: Build and maintain custom connectors, automation scripts, and transformation logic.
  • Design Data Models: Create and maintain schemas for cloud data warehouses and work with relational databases when needed.
  • Support Identity Resolution: Contribute to data models that connect user identifiers, such as cookies, email addresses, and device IDs, to support Customer 360 and attribution initiatives.
  • Manage Cloud Infrastructure: Deploy and maintain data infrastructure and object storage across AWS, GCP, or Azure.
  • Optimize Performance & Costs: Monitor database performance, optimize queries, implement indexing, and improve infrastructure efficiency while balancing warehouse performance and costs.
  • Ensure Data Quality & Reliability: Implement data quality checks, monitoring, and alerting. Troubleshoot pipeline issues and maintain accurate, reliable data assets.
  • Collaborate with Stakeholders: Translate requirements from marketers, analysts, and product managers into reliable data structures and solutions.
  • Follow Engineering Best Practices: Participate in code reviews, use CI/CD workflows, write data tests, and follow privacy and governance standards, particularly when handling personally identifiable information (PII).
Requirements
  • 2+ years of experience as a Data Engineer in a production cloud environment.
  • Hands-on experience with at least one major cloud platform (AWS, GCP, or Azure), with the ability to adapt to others.
  • Experience building SQL-based ELT workflows using version-controlled models (dbt or similar) and automated data testing.
  • Strong Python programming skills for data engineering tasks.
  • Advanced SQL skills, including query optimization and performance tuning.
  • Experience querying, parsing, and flattening nested JSON data using SQL.
  • Experience working with data from CRM systems, marketing automation platforms, web analytics, or advertising platforms.
  • Working knowledge of managed data services and data lake architectures within at least one major cloud provider.
  • Familiarity with Git, version control, and code review practices.
  • Comfortable using AI coding assistants as part of the development workflow.
  • Strong written and verbal communication skills, with the ability to explain technical concepts and decisions to non-technical stakeholders.
USA Time Zone
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Releady • Bogotá ciudad

Hybrid
COP 84,443,000 - 101,146,000
Mid Data Engineer
Mid Data Engineer

Lean Solutions Group • Medellín

On-site
COP 190,223,000 - 317,038,000
Senior Data Engineer Lead
Senior Data Engineer Lead

ScotiaTech • Bogotá

On-site
COP 284,765,000 - 442,968,000
Senior Data Engineer
Senior Data Engineer

HatchWorks AI • Colombia

On-site
COP 60,000,000 - 90,000,000
Senior Data Engineer Lead
Senior Data Engineer Lead

Scotiabank • Bogotá

On-site
COP 120,000,000 - 180,000,000
Data Engineer (Lead) ID41785
Data Engineer (Lead) ID41785

AgileEngine, LLC. • Bogotá

Remote
COP 374,895,000 - 468,618,000
Professional growth with mentorship
Competitive USD-based compensation
Flextime and remote options
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • Perímetro Urbano Manizales

Hybrid
COP 227,147,000 - 324,496,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • Perímetro Urbano Barranquilla

Hybrid
COP 292,047,000 - 421,845,000
Professional growth
Competitive USD-based pay
Exciting projects with Fortune 500
+1
Senior Data Engineer
Senior Data Engineer

TTEC Digital • Colombia

On-site
COP 120,000,000 - 240,000,000
Data Engineer, Azure - Remote, Latin America
Data Engineer, Azure - Remote, Latin America

Bluelight • Metropolitana

Remote
COP 151,143,019 - 226,714,528
Competitive salary and bonuses
Generous paid-time-off policy
Flexible working hours
+1