Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Forsyth Barnes Consultancy

New

Data Engineer - ELT Pipelines & Snowflake on AWS

Posted Updated

Description

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.

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. 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.

Skills

Apply

See also

Data Engineering jobs by country — openings, pay and top skills →