Red Clover · 7 hours ago
Lead Data Engineer
East Rutherford, NJ
Full-time
Onsite
Senior Level, Lead/Staff
$125K/yr - $150K/yr
8+ years expRed Clover is a dynamic, growing international delivery and technology solutions provider. The Data Architect / Lead Data Engineer will own the design, implementation, scalability, and business impact of the company’s data platform, shaping how data flows to drive decision-making across the business.
Management Consulting
Responsibilities
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
Qualification
Required
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
Preferred
Experience in logistics, e-commerce, supply chain, fulfillment, or adjacent domains is strongly preferred
Company
Red Clover
Red Clover is an organizational Change Management and Human Resources Consulting serving clients in NYC and NJ.
2-10 employees
Funding
Current Stage
Early StageRecent News
Company data provided by crunchbase