Data Engineer (Ref: 198498)

Forsyth Barnes Consultancy

Perímetro Urbano Barranquilla

On-site

COP 50,000,000 - 90,000,000

Full time

7 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

Edge Logistics is seeking a Data Engineer to design, build, and operate ELT pipelines moving data from on-prem and cloud sources into Snowflake, with production-ready datasets for BI and AI consumers.

You will work hands-on across AWS and Snowflake, setting technical standards and supporting data science teams. This 12-month engagement may convert to permanent, depending on performance and business needs.

Qualifications

  • 3+ years of hands-on data engineering experience building production ELT/ETL pipelines.
  • Strong SQL skills and solid working proficiency in Python.
  • Hands-on experience with Snowflake, AWS, and Azure, working with the tools outlined in this posting.
  • Experience with AWS services commonly used in data pipelines — Lambda, ECS or similar container services, Athena, S3, IAM.
  • Experience integrating data from REST APIs and relational databases (SQL Server experience a strong plus).
  • Experience with a transformation framework (dbt strongly preferred) and dimensional/star-schema modeling.
  • Familiarity with orchestration tools (Airflow, Step Functions, EventBridge Scheduler, or similar).
  • Comfort working in a fast-moving, still-being-built environment — this role will involve real ambiguity and the need to make sound judgment calls.
  • Strong written communication skills — you'll be documenting pipelines and standards for a team that's still forming.
  • Experience supporting data science and analytics teams, with an understanding of what they need from a data platform to be productive.
  • Working knowledge of data engineering industry best practices, with the ability to make solid recommendations and defend the decisions behind them to technical and non-technical stakeholders.
  • A penchant for efficiency — you automate repetitive work, simplify where you can, and optimize for performance and cost while being able to defend the technical decisions we make.

Responsibilities

  • Design, build, and maintain ELT pipelines landing data into Snowflake's raw layer and transforming it to curated datasets.
  • Build and operate transformation logic with dbt or equivalent.
  • Develop and maintain orchestration for pipeline scheduling, dependencies, retries, and alerts.
  • Build and maintain AWS-based ingestion infrastructure: Lambda, ECS, Athena, S3, IAM.
  • Establish and enforce data quality, testing, and monitoring practices.
  • Partner with the Director and BI lead to translate the enterprise architecture roadmap into shipped pipelines, models, and documentation.
  • Support data science and analytics teams by delivering reliable, well-modeled datasets and feature pipelines.
  • Recommend technical approaches grounded in industry best practices, and defend architectural decisions to stakeholders.
  • Continuously look for ways to simplify, automate, and optimize pipelines for performance, reliability, and cost.
  • Establish and enforce data governance and access control practices as Edge's Snowflake footprint grows.
  • Help evaluate and integrate new data sources as new business needs arrive.
  • Set and document engineering standards for a data engineering function that is still being built.

Skills

SQL
Python
Data pipeline design
Data governance
Data quality
Stakeholder communication
Problem solving

Tools

Snowflake
AWS
Azure
dbt
Airflow
EventBridge Scheduler
AWS Lambda
S3
ECS
IAM

Job description

About Us

Edge Logistics is a relationship-first freight brokerage that pairs real partnerships with smart technology to move freight for shippers across North America. Founded in 2014, Edge connects shippers of every size to top-tier carriers — balancing cost, capacity, and reliability across full truckload, LTL/partial, temperature-controlled, cross-border, and expedited freight. Edge is headquartered in Phoenix and Chicago with an additional hub in Columbia.

Job Description

We're hiring a Data Engineer to help design, build, and operate the ELT pipelines and orchestration that move data from our source systems - our on-prem SQL Server TMS (McLeod), AWS-hosted applications, and third-party market and telephony APIs - into Snowflake, and out to downstream BI and AI consumers. You'll work hands-on across AWS (Lambda, ECS, Athena, S3) and Snowflake, and you'll have a real hand in setting the technical standards for how Edge does data engineering going forward. This role is structured as a 12-month engagement with the opportunity to convert to a permanent position based on performance and business need.

Key Responsibilities
  • Design, build, and maintain ELT pipelines that land data from on-prem SQL Server (McLeod TMS) and external APIs (market rate/capacity data, carrier and telephony platforms, and others) into Snowflake's raw layer, and transform it through staging/silver into curated/gold, production-ready datasets
  • Build and operate transformation logic (dbt or equivalent) to create clean, well-documented, tested models — dimensional/star schemas where appropriate — that downstream teams can trust
  • Develop and maintain orchestration for pipeline scheduling, dependency management, retries, and alerting (e.g., EventBridge Scheduler, Airflow, or similar), so pipelines run reliably without manual babysitting
  • Build and maintain AWS-based ingestion infrastructure: containerized Lambda functions, ECS tasks, Athena queries against S3, and supporting services (ECR, Secrets Manager, IAM, SES)
  • Establish and enforce data quality, testing, and monitoring practices across pipelines — catching breakages before downstream users do
  • Partner with the Director and BI lead to translate the enterprise architecture roadmap into shipped pipelines, models, and documentation
  • Support data science and analytics teams by delivering reliable, well-modeled datasets and feature pipelines, and by removing data bottlenecks that slow their work
  • Recommend technical approaches grounded in industry best practices, and clearly explain and defend the reasoning behind architectural decisions to technical and non-technical stakeholders
  • Continuously look for ways to simplify, automate, and optimize pipelines, queries, and infrastructure for performance, reliability, and cost
  • Establish and enforce data governance and access control practices as Edge's Snowflake footprint grows
  • Help evaluate and integrate new data sources as new business needs — pricing intelligence, carrier scorecards, load risk models — come online
  • Set and document engineering standards (code review, version control, CI/CD, testing) for a data engineering function that is still being built
Requirements
  • 3+ years of hands-on data engineering experience building production ELT/ETL pipelines
  • Strong SQL skills and solid working proficiency in Python
  • Hands-on experience with Snowflake, AWS, and Azure, working with the tools outlined in this posting
  • Experience with AWS services commonly used in data pipelines — Lambda, ECS or similar container services, Athena, S3, IAM
  • Experience integrating data from REST APIs and relational databases (SQL Server experience a strong plus)
  • Experience with a transformation framework (dbt strongly preferred) and dimensional/star-schema modeling
  • Familiarity with orchestration tools (Airflow, Step Functions, EventBridge Scheduler, or similar)
  • Comfort working in a fast-moving, still-being-built environment — this role will involve real ambiguity and the need to make sound judgment calls
  • Strong written communication skills — you'll be documenting pipelines and standards for a team that's still forming
  • Experience supporting data science and analytics teams, with an understanding of what they need from a data platform to be productive
  • Working knowledge of data engineering industry best practices, with the ability to make solid recommendations and defend the decisions behind them to technical and non-technical stakeholders
  • A penchant for efficiency — you automate repetitive work, simplify where you can, and optimize for performance and cost while being able to defend the technical decisions we make
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer Sr- Remote Latam – ID #00199
Data Engineer Sr- Remote Latam – ID #00199

Werben HR • Bogotá

Remote
COP 100,000,000 - 120,000,000
Senior Big Data Software Engineer (Snowflake + DBT)
Senior Big Data Software Engineer (Snowflake + DBT)

SoftServe Inc. • Colombia

On-site
COP 90,000,000 - 150,000,000
Data Engineer - ELT Pipelines & Snowflake on AWS
Data Engineer - ELT Pipelines & Snowflake on AWS

Forsyth Barnes Consultancy • Perímetro Urbano Barranquilla

On-site
COP 50,000,000 - 90,000,000
Data Engineer
Data Engineer

AgileEngine, LLC. • Colombia

Remote
COP 450,973,000 - 579,822,000
Senior Data Engineer (Snowflake) - AA
Senior Data Engineer (Snowflake) - AA

Gorilla Logic, Inc. • Colombia

Remote
COP 295,673,000 - 427,084,000
Senior Data Platform Engineer Id92207
Senior Data Platform Engineer Id92207

AgileEngine, LLC. • Perímetro Urbano Barranquilla

On-site
COP 397,035,000 - 595,553,000
Professional growth
Competitive USD-based compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Cartagena de Indias

Hybrid
COP 292,047,000 - 421,845,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer (Middle/Senior) ID32276
Data Engineer (Middle/Senior) ID32276

AgileEngine, LLC. • Perímetro Urbano Bucaramanga

Hybrid
COP 129,462,000 - 226,559,000
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
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