Red Clover

Lead Data Engineer

Red Clover  •  $125k - $150k/yr  •  East Rutherford, NJ (Onsite)  •  4 months ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Lead Data Engineer

Department: Technology

Employment Type: Full Time

Location: East Rutherford, NJ

Reporting To: Head of Technology

Compensation: $125,000 - $150,000 / year



Who We Are:
APC is a dynamic, growing international delivery and technology solutions provider. Established in 2001, APC has been simplifying international delivery for over 20 years, helping U.S. businesses build brands abroad, expand their consumer base, increase revenue, and their global reach. Our extensive, reliable worldwide delivery network and proprietary technology empower our brands to succeed. We are committed to expanding our footprint and continuously investing in innovative delivery and technology solutions as we aim to be the leading resource for cross-border solutions.
About the Role:
Reporting to the Head of Technology, the Data Architect / Lead Data Engineer will own the design, implementation, scalability, and business impact of APC’s data platform supporting a high‑volume, complex logistics operation. This is a hands‑on, senior technical role responsible for shaping how data flows from raw operational systems through trusted analytics and into production‑grade models that drive decision‑making across the business.

You will lead the evolution of the data stack end‑to‑end, balancing architectural rigor with real‑world constraints such as imperfect data, operational urgency, and cost efficiency. Partnering closely with engineering, product, operations, finance, and leadership, you will translate complex business questions into durable data solutions that directly impact shipment performance, customer experience, pricing, and profitability. This role is well‑suited for someone who enjoys deep technical ownership, cross‑functional collaboration, and building systems that operate at scale in production environments.

About the Candidate:

You are a hands‑on, systems‑oriented data leader who enjoys working close to the business and taking ownership of complex, real‑world data challenges. You are comfortable operating at the intersection of architecture, engineering, analytics, and applied data science, and you thrive in environments where data is imperfect, scale is real, and impact is tangible.

You bring a strong sense of accountability and technical judgment, with the ability to make thoughtful tradeoffs and move initiatives forward. You communicate clearly with both technical and non‑technical partners, build trust through reliability and transparency, and enjoy mentoring others while setting a high bar for data quality and engineering discipline.

Key Responsibilities

Data Platform & Warehouse Leadership

  • Own the architecture, scalability, performance, and cost efficiency of the enterprise data warehouse and analytics platform.
  • Design and maintain dimensional and analytical data models supporting core logistics and financial use cases, including shipments, customs data, carrier performance, SLAs, revenue, and margins.
  • Establish and enforce best practices for data modeling, schema evolution, data quality monitoring, lineage, documentation, and cost governance.
  • Lead data platform migrations, upgrades, and modernization initiatives as needed.
  • Design, build, and operate reliable, observable ELT/ETL pipelines from internal systems, third-party APIs, and event streams, including change data capture where required.
  • Ensure pipeline resilience through strong handling of data freshness, schema drift, backfills, reprocessing, and failure recovery.
  • Integrate data across core operational platforms, including OMS, WMS, TMS, payments, CRM, and marketing systems.
  • Partner with application and platform engineers on event design, instrumentation, and data contracts.

Analytics Engineering & Business Enablement

  • Build and maintain trusted semantic layers, metrics definitions, and curated data marts for analytics, operations, finance, and executive reporting.
  • Define and operationalize canonical KPIs across shipment performance, carrier reliability, exceptions, margins, and customer lifecycle metrics.
  • Enable governed self-service analytics while preserving data accuracy, consistency, and trust.

Applied Data Science & Advanced Analytics

  • Develop and product-ionize analytical models for forecasting, operational optimization, anomaly detection, and customer behavior analysis.
  • Design experiments and analyses with clear business impact and measurable ROI, and operationalize outputs into dashboards or workflows.
  • Serve as technical owner for data architecture, tooling selection, and platform standards.
  • Mentor engineers and analysts, lead design reviews, and set pragmatic standards balancing speed, reliability, and cost.


Key Responsibilities:
Data Platform & Warehouse Leadership

  • Own the architecture, scalability, performance, and cost efficiency of the enterprise data warehouse and analytics platform.
  • Design and maintain dimensional and analytical data models supporting core logistics and financial use cases, including shipments, customs data, carrier performance, SLAs, revenue, and margins.
  • Establish and enforce best practices for data modeling, schema evolution, data quality monitoring, lineage, documentation, and cost governance.
  • Lead data platform migrations, upgrades, and modernization initiatives as needed.
  • Design, build, and operate reliable, observable ELT/ETL pipelines from internal systems, third-party APIs, and event streams, including change data capture where required.
  • Ensure pipeline resilience through strong handling of data freshness, schema drift, backfills, reprocessing, and failure recovery.
  • Integrate data across core operational platforms, including OMS, WMS, TMS, payments, CRM, and marketing systems.
  • Partner with application and platform engineers on event design, instrumentation, and data contracts.
  • Build and maintain trusted semantic layers, metrics definitions, and curated data marts for analytics, operations, finance, and executive reporting.
  • Define and operationalize canonical KPIs across shipment performance, carrier reliability, exceptions, margins, and customer lifecycle metrics.
  • Enable governed self-service analytics while preserving data accuracy, consistency, and trust.
  • Develop and productionize analytical models for forecasting, operational optimization, anomaly detection, and customer behavior analysis.
  • Design experiments and analyses with clear business impact and measurable ROI, and operationalize outputs into dashboards or workflows.
  • Serve as technical owner for data architecture, tooling selection, and platform standards.
  • Mentor engineers and analysts, lead design reviews, and set pragmatic standards balancing speed, reliability, and cost.

Skills, Knowledge and Expertise

  • 8+ years of experience in data engineering, analytics engineering, or applied data science roles, with demonstrated ownership of production data systems.
  • Proven experience designing and operating a scalable data warehouse or analytics platform in a production environment.
  • Advanced SQL expertise, including query optimization, indexing and partitioning strategies, dimensional modeling, and slowly changing dimensions.
  • Strong experience building and maintaining data pipelines using modern data tooling and orchestration frameworks.
  • Proficiency in Python or a similar language for data processing, modeling, and automation.
  • Experience working with large‑scale, high‑volume operational datasets and managing data quality in real‑world conditions.
  • Strong systems thinking and the ability to design for reliability, performance, and cost control.
  • Demonstrated ability to translate business problems into effective technical solutions.
  • Experience in logistics, e‑commerce, supply chain, fulfillment, or adjacent domains is strongly preferred.

Core Competencies


Communicates Effectively
Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences Manages Complexity: Making sense of complex, high quantity, and sometimes contradictory information Business Insight: Applying knowledge of business goals and the marketplace to advance the organization’s goals Financial Acumen: Interpreting and applying understanding of key financial indicators to make better business decisions

Red Clover

About Red Clover

We work with companies to achieve their most challenging organizational and business change goals.

For many of our clients, it’s about achieving aggressive growth targets, including all-but-unachievable hiring plans. For others, it’s business transformation that is a make-it-or-break-it for their ongoing survival in a changing marketplace. For our smaller entrepreneurs, it’s helping them develop and implement a people strategy that gets them off the ground, without getting into trouble along the way.

Red Clover specializes in Organizational Change Management and Strategic Human Resources Consulting Services. Whether it’s organizational growth, reorganization or downsizing, we leverage decades of corporate and consulting experience in leadership, business ownership, consulting and HR roles to both strategically advise and tactically support our clients.

What's your business case for change?

Industry
Consulting & Advisory
Company Size
11-50 employees
Headquarters
Parsippany, New Jersey
Year Founded
2015
Social Media