Talent.com
Data Engineering Lead
Data Engineering LeadAptimized • Wayne, NJ, US
Data Engineering Lead

Data Engineering Lead

Aptimized • Wayne, NJ, US
3 days ago
Job type
  • Full-time
Job description

Aptimized is seeking a highly skilled Data Engineering Onsite Lead to spearhead the design, development, and modernization of enterprise-scale data platforms. This role requires a hands-on technical leader who can architect, implement, and optimize data engineering solutions while working closely with business and technology stakeholders in an onsite capacity.

The successful candidate will lead end-to-end data engineering initiatives including data ingestion, integration, modeling, and advanced analytics enablement. This is a critical position for delivering scalable, performant, and secure data pipelines and warehouses, supporting both real-time and batch workloads, and aligning with the firm's cloud-first Data Strategy.

Key Responsibilities

Data Engineering & Advanced Integration

  • Architect, design, and implement high-performance ETL / ELT pipelines across structured, semi-structured, and unstructured data sources.
  • Lead migration and modernization of on-premises data warehouses to cloud-based ecosystems (Fabric, Azure Synapse, ADLS2).
  • Implement real-time streaming pipelines using technologies like Azure Event Hubs, Kafka, or Spark Structured Streaming.
  • Enforce data quality frameworks (DQ checks, anomaly detection, reconciliation processes) ensuring accuracy, completeness, and timeliness of data.
  • Optimize storage, compute, and query performance for large-scale data workloads.

Data Architecture & Strategy

  • Collaborate with data architects to design data Lakehouse architectures, dimensional and normalized data models, and metadata-driven ingestion frameworks.
  • Define and implement data governance policies, lineage tracking, and cataloging (using Purview or similar).
  • Establish and enforce naming conventions, coding standards, and design patterns for data engineering projects.
  • Drive adoption of CI / CD pipelines for data engineering assets and automate deployment processes with DevOps practices.
  • Business Intelligence & Analytics Enablement

  • Manage Power BI Administration, including workspace governance, user access control, security roles, and performance optimization.
  • Lead the development and optimization of Power BI, SSRS, and advanced analytics solutions.
  • Guide teams in building semantic models, KPIs, and advanced DAX calculations for enterprise BI.
  • Partner with Data Science and AI teams to provide curated, high-quality datasets for machine learning pipelines.
  • Translate complex business needs into scalable technical solutions with measurable business outcomes.
  • Leadership, Collaboration & Operational Excellence

  • Act as the onsite technical lead, coordinating closely with offshore and cross-functional teams to ensure alignment and delivery.
  • Mentor junior engineers on SQL optimization, distributed computing, cloud-native data services, and best practices.
  • Ensure compliance with data security, privacy regulations, and SOX / GDPR requirements in all engineering deliverables.
  • Identify opportunities for automation, performance improvement, and cost optimization across data pipelines and storage systems.
  • Provide technical leadership in architecture reviews, performance tuning sessions, and production incident resolution.
  • Qualifications & Experience

    Required :

  • 12+ years of progressive experience in Data Engineering / Business Intelligence with at least 5 years in a lead capacity.
  • Proven expertise in SQL Server, SSIS, Power BI, SSRS, and cloud-based data services (Fabric, Azure Data Factory, Synapse, ADLS2).
  • Experience with Power BI tenant administration : governance, access management, security, workspace design, and performance optimization.
  • Deep understanding of dimensional modeling, OLAP / OLTP systems, data lakes, and data Lakehouse patterns.
  • Strong skills in query performance tuning, parallel processing, partitioning, and indexing strategies.
  • Experience in designing and deploying CI / CD pipelines for data projects using Azure DevOps or GitHub Actions.
  • Excellent communication and onsite client-facing leadership skills, with the ability to interact with C-level stakeholders.
  • Preferred :

  • Experience with modern data orchestration tools (Synapse Pipelines).
  • Exposure to machine learning pipelines and integration with AI / ML platforms.
  • Certifications in Fabric, Azure Data Engineer, Azure Solutions Architect.
  • Aptimized is an equal opportunities employer and welcomes applications from all qualified candidates.

    J-18808-Ljbffr

    Create a job alert for this search

    Data Engineering Lead • Wayne, NJ, US

    Related jobs
    Data Engineering Lead

    Data Engineering Lead

    Consortia Group • New York, NY, US
    Full-time
    Data Engineering Lead – NYC (Hybrid).New York City (Hybrid : 3-4 days per week in office).This position blends hands-on engineering and strategic leadership, ideal for individuals with a strong back...Show more
    Last updated: 3 days ago • Promoted
    Senior Director- Data Engineering

    Senior Director- Data Engineering

    Smart IMS • Florham Park, NJ, US
    Full-time
    Senior Director, Data Engineering.Required Qualification & Skills : .Minimum 10 years' progressive relevant work experience in a quantitative business environment. Minimum 5 years' experience working ...Show more
    Last updated: 3 days ago • Promoted
    Lead Data Engineer - FanDuel Careers

    Lead Data Engineer - FanDuel Careers

    FanDuel • New York, NY, US
    Full-time
    At FanDuel Group, we give fans a new and innovative way to interact with their favorite games, sports and teams.We're dedicated to building a winning team and we pride ourselves on being able to ma...Show more
    Last updated: 9 days ago • Promoted
    Lead Data Engineering Consultant and Technical Manager - ref. #6002

    Lead Data Engineering Consultant and Technical Manager - ref. #6002

    Ippon Technologies SAS • New York, NY, US
    Full-time
    The Ippon story started in 2002 in Paris, France - cue in the accordion.Our founder and CEO Stéphane Nomis used his unique experience as an international Judo champion to create a culture based on ...Show more
    Last updated: 9 days ago • Promoted
    Data Engineering Manager, Analytics

    Data Engineering Manager, Analytics

    Meta • New York, NY, US
    Full-time
    We're looking for a leader in our Data Engineering team to work closely with Product Managers, Data Scientists and Software Engineers to support product launches and roadmaps by building the data a...Show more
    Last updated: 30+ days ago • Promoted
    Engineering Manager (AI & Data)

    Engineering Manager (AI & Data)

    Cyndx • New York, NY, US
    Full-time
    Cyndx is building the next-generation AI search and research platform for deal origination in investment banking.Our platform leverages cutting-edge data engineering, machine learning, and generati...Show more
    Last updated: 10 days ago • Promoted
    Engineering Manager- Backend (Data)

    Engineering Manager- Backend (Data)

    Uniswap Labs • New York, NY, US
    Full-time
    Uniswap Labs builds products that help millions of people access DeFi simply and securely - from the Uniswap Web App and Wallet to crypto infrastructure like the Uniswap Trading API, and Unichain.U...Show more
    Last updated: 9 days ago • Promoted
    Data Engineering Team Lead / Manager

    Data Engineering Team Lead / Manager

    Quanta Search • New York, NY, US
    Full-time
    The Data Engineering Team Lead / Manager role at Quanta Search.Our client - a fast-growing established hedge fund - is looking for a strong technology leader with engineering, development and managem...Show more
    Last updated: 9 days ago • Promoted
    Data Engineering Manager - Apple Ads

    Data Engineering Manager - Apple Ads

    Apple Inc. • New York, NY, US
    Full-time
    New York City, New York, United States Software and Services.At Apple, we work every day to create products that enrich people's lives. Our Advertising Platforms group enables people around the worl...Show more
    Last updated: 9 days ago • Promoted
    Data Engineering Manager

    Data Engineering Manager

    Pennylane • New York, NY, US
    Full-time
    Are you looking to have an impact on the daily life of millions of entrepreneurs in France (and tomorrow in Europe)? Are you looking for a work environment that values trust, proactivity, and auton...Show more
    Last updated: 30+ days ago • Promoted
    Engineering Tech Lead, AI Product

    Engineering Tech Lead, AI Product

    The Browser Company • New York, NY, US
    Full-time
    Browsers are unique in that they are one of the only pieces of software that you share with your parents as well as your kids. Which makes sense, they're our doorway to the most important things — t...Show more
    Last updated: 3 days ago • Promoted
    Senior Manager, Data Engineering

    Senior Manager, Data Engineering

    Capital One • NEW YORK, New York, United States
    Full-time +1
    Senior Manager, Data Engineering.Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative,.At Capital One, you'll b...Show more
    Last updated: 30+ days ago • Promoted
    Clojure Data Engineering Lead

    Clojure Data Engineering Lead

    Liberty Personnel Services, Inc. • New York, NY, US
    Full-time
    My client is seeking an experienced Technical Lead to spearhead the Data Engineering team.In this critical role, you will lead a team of 5 talented engineers to design, develop, and maintain comple...Show more
    Last updated: 3 days ago • Promoted
    Lead Data Engineer

    Lead Data Engineer

    Capital One • New York, NY, US
    Full-time +1
    Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital...Show more
    Last updated: 30+ days ago • Promoted
    Data Engineering Lead Analyst

    Data Engineering Lead Analyst

    National Black MBA Association • Jersey City, NJ, US
    Full-time
    The Applications Development Technology Lead Analyst is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with th...Show more
    Last updated: 3 days ago • Promoted
    Director Data Engineering

    Director Data Engineering

    Cardinal Integrated • Secaucus, NJ, US
    Full-time
    You will be part of a growing Data Engineering team that handles client data for internal and external users.The IT department services over 10 internal groups and the one will be a seasoned techno...Show more
    Last updated: 30+ days ago • Promoted
    Lead Data Engineer

    Lead Data Engineer

    EXL • Jersey City, NJ, US
    Full-time
    Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Manager-Strategic Hiring with expertise in diversity and inclusion. Lead the design, development,...Show more
    Last updated: 9 days ago • Promoted
    Lead CT Tech

    Lead CT Tech

    Hackensack Meridian Mountainside Medical Center • Montclair, NJ, United States
    Full-time
    Join our team as an evening shift, full-time, Cat Scan-A Lead CT Technician in Montclair, NJ.You may be eligible for a sign on bonus of up to $10,000. Thrive in a People-First Environment and Make H...Show more
    Last updated: 30+ days ago • Promoted