Data Engineer

Frederick Fox is seeking a Data Engineer to build and operate reliable data systems supporting business intelligence and AI initiatives. The role focuses on ingestion pipelines, workflow orchestration, transformation and dimensional modeling, AI data preparation, data quality, governance, and collaboration with business and technical stakeholders.

Responsibilities

Design, build, and maintain ingestion pipelines from source systems into Snowflake

Orchestrate workflows in Dagster so they're observable, reliable, and operationally sound

Monitor pipeline health and data availability; investigate failures, fix root causes, and add alerting so issues surface early

Develop and maintain dbt models that turn raw data into clean, tested, well-documented datasets

Design dimensional models and data marts that support both reporting and machine learning

Implement data quality checks and testing standards so downstream consumers can trust datasets without re-verifying them

Structure feature datasets and training data pipelines

Partner with data science and AI teams on data quality, freshness, and structure requirements

Contribute to the semantic layer that gives analytics and AI consumers consistent access to business metrics and entities

Keep data lineage and governance in view

Build working knowledge of core business processes: product sales through dealership partners, claims administration, and cancellations

Engage directly with business stakeholders to understand data needs and translate them into sound technical designs

Apply business context to modeling decisions, pipeline priorities, and data quality standards

Advise on the strategic direction of the data engineering toolset, including platform updates and new capabilities

Stay current on best practices in data engineering, AI data preparation, and orchestration

Dashboards and reporting belong to analysts and BI developers, but you may occasionally build or troubleshoot a report, or help an analyst work through a modeling issue at the source

Preferred

Snowflake, dbt, and Dagster

AWS familiarity (storage, IAM, basic networking)

Python for pipeline development or scripting

Data quality frameworks, data contracts, or observability tooling

Experience supporting ML pipelines or AI data preparation

Medallion or similar layered architecture

Data governance or data catalog experience

Snowflake

dbt

Dagster

AWS

AWS storage

AWS IAM

Basic networking

Python

Pipeline development

Scripting

Data quality frameworks

Data contracts

Observability tooling

ML pipeline support

AI data preparation

Medallion architecture

Layered architecture

Data governance

Data catalogs

Company

National executive recruiting firm for finance, accounting, technology, and sales

Boynton Beach, Florida, USA

https://frederickfox.com/

Founded in 2019

51-200 employees

Qualifications

3–7 years of experience in data engineering or a closely related discipline

Strong SQL proficiency

Hands-on experience with a cloud data warehouse, a transformation/modeling framework, and a workflow orchestration tool

Ability to work with non-technical stakeholders and translate business needs into technical requirements

Clear written and verbal communication, including documentation others can use without a follow-up conversation

Snowflake, dbt, and Dagster

AWS familiarity (storage, IAM, basic networking)

Python for pipeline development or scripting

Data quality frameworks, data contracts, or observability tooling

Experience supporting ML pipelines or AI data preparation

Medallion or similar layered architecture

Data governance or data catalog experience

Required skills

SQL, Snowflake, dbt, Dagster, AWS, Python, Data Engineering, Data Quality, Data Modeling, Data Warehousing, Data Pipeline Development, Data Governance, Technical Requirements Translation

Preferred skills

Snowflake, dbt, and Dagster, AWS familiarity (storage, IAM, basic networking), Python for pipeline development or scripting, Experience supporting ML pipelines or AI data preparation, Medallion or similar layered architecture, Data governance or data catalog experience, Boynton Beach, Florida, USA, https://frederickfox.com, Growth Stage, Leadership Team, Bill Spengler, Managing Partner, Company data provided by, AI Tools, Customize Your Resume, Maximize your interview chances, Build Cover Letter, Make your application stand out, Analyze How Well You Fit, Understand your strength & weakness

Experience

3+ years