Looking for a job

Erik Ferguson

@erikferguson

Data Engineer at J.Crew who architected AWS pipelines for e-commerce analytics and operationalized batch and real-time ML pipelines.

United States

Message

At J.Crew, I architected AWS data pipelines and modeled customer, order, product, and marketing data for e-commerce metrics including CAC, ROAS, LTV, retention, and conversion funnels. I also operationalized batch and real-time ML pipelines with reusable feature datasets for marketing science, analytics, and business users.

At Billtrust, I orchestrated AWS ETL/ELT workflows integrating APIs, databases, files, and event-driven sources. Earlier, I developed Python and SQL reporting workflows at Kroll and validated enterprise data in a regulated environment at Citi.

Experience

Work history, roles, and key accomplishments

Lead Data Engineer

J.Crew

Oct 2025 - Aug 2026 (10 months)

Architected end-to-end AWS data pipelines and modeled customer, order, product, and marketing data for commercial analytics. Operationalized ML pipelines and established SLAs, validation, and anomaly detection workflows.

AWS Redshift S3 Glue Athena Lambda Python SQL DBT Airflow Docker Amazon EKS AWS ECS CI CD ML Pipelines Data Quality Anomaly Detection Cost Optimization

Senior Data Engineer

J.Crew

Jul 2024 - Sep 2024 (2 months)

Resolved data-quality and performance issues in Python/SQL pipelines and BI models supporting marketing, customer, and operational reporting.

Python SQL Data Quality Performance Optimization BIツール Reporting

Data Engineer

Billtrust

Sep 2022 - Jul 2024 (1 year 10 months)

Orchestrated ETL/ELT with Python, SQL, Spark, Redshift, S3, dbt, and Airflow on AWS, integrating APIs, databases, files, and event-driven sources. Designed configurable ingestion jobs with quality controls and standardized containerized deployments.

Python SQL Spark Redshift S3 DBT Airflow AWS ETL ELT Terraform Docker CI CD GitHub Actions Data Quality Lineage Monitoring

Managing Consultant / Data Analyst II

Kroll

Nov 2020 - Aug 2022 (1 year 9 months)

Developed Python and SQL workflows for financial and operational reporting, reconciling source data and documenting mappings, controls, and procedures. Translated stakeholder requirements into analytical solutions.

Python SQL Financial Reporting Data Reconciliation Stakeholder Management Analytical Solutions

Data Management Analyst II

Citi

Nov 2019 - Nov 2020 (1 year)

Validated enterprise data with SQL and investigated quality issues in a regulated environment, maintaining metadata, lineage, and access-governance controls.

SQL Data Validation Data Quality Metadata Management Data Lineage Access Governance