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

Data Engineering Lead

Aptimized • Wayne, NJ, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.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

    serp_jobs.job_alerts.create_a_job

    Data Engineering Lead • Wayne, NJ, US

    Job_description.internal_linking.related_jobs
    Senior Director- Data Engineering

    Senior Director- Data Engineering

    Smart IMS • Florham Park, NJ, US
    serp_jobs.job_card.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 ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Data Engineering Specialist (Hybrid)

    Data Engineering Specialist (Hybrid)

    Selective Insurance • Millburn, NJ, United States
    serp_jobs.job_card.temporary
    At Selective, we don't just insure uniquely, we employ uniqueness.Selective's unique position as both a leading insurance group and an employer of choice is recognized in a wide variety of awards a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Engineering Manager (AI & Data)

    Engineering Manager (AI & Data)

    Cyndx • New York, NY, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    ED, Head of Analytics Engineering

    ED, Head of Analytics Engineering

    Novartis Group Companies • East Hanover, NJ, United States
    serp_jobs.job_card.full_time
    This position will be located in the East Hanover, NJ site.Insights and Decision Science (IDS) team is dedicated to enabling improved decision-making at Novartis by. We collaborate closely with the ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Technical Data Lead

    Technical Data Lead

    Betis Group, Inc. • New York, NY, US
    serp_jobs.job_card.full_time
    The Technical Data Lead will play a pivotal role in driving the strategic direction and execution of data initiatives within the organization. This position is responsible for overseeing the design,...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Manager, Data Engineering

    Manager, Data Engineering

    Garner Health • New York, NY, US
    serp_jobs.job_card.full_time
    Healthcare quality is declining and soaring costs are crushing American families and businesses.At Garner, we've developed a revolutionary approach to evaluating doctor performance and a unique...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Engineering Technical Lead

    Engineering Technical Lead

    Insomnia Labs • New York, NY, US
    serp_jobs.job_card.full_time
    Engineering Technical Lead CreatorFi (Platform / Infra).Remote must align with 9 : 00am5 : 00pm Eastern Time (New York) core hours. Insomnia Labs is hiring anEngineering Technical Lead for CreatorFi, our ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Engineering Manager

    Data Engineering Manager

    Pennylane • New York, NY, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Manager, Data Engineering

    Senior Manager, Data Engineering

    Capital One • NEW YORK, New York, United States
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Engineering Team Lead (Hybrid)

    Data Engineering Team Lead (Hybrid)

    Selective Insurance • Short Hills, NJ, United States
    serp_jobs.job_card.temporary
    At Selective, we don't just insure uniquely, we employ uniqueness.Selective's unique position as both a leading insurance group and an employer of choice is recognized in a wide variety of awards a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Digital Data Systems and Applications Sr. Manager, Engineering

    Digital Data Systems and Applications Sr. Manager, Engineering

    Novartis Group Companies • East Hanover, NJ, United States
    serp_jobs.job_card.full_time
    This position will be located at East Hanover, NJ site and will not have the ability to be located remotely.Please note that this role would not provide relocation and only local candidates will be...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Engineering Director

    Data Engineering Director

    BDG • New York, NY, US
    serp_jobs.job_card.full_time
    Bustle Digital Group (BDG) is seeking a Director of Data Engineering to lead, expand, and optimize our data infrastructure. In this role, you will drive the development of scalable data pipelines, e...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Manager of Data Engineering and Analytics Consulting

    Manager of Data Engineering and Analytics Consulting

    Ippon Technologies • New York, NY, US
    serp_jobs.job_card.full_time +1
    We’re hiring a Manager of Data Engineering & Analytics Consulting!.Full Time / Direct Hire Only (No Agencies).Atlanta GA Metro, Washington DC Metro, Charlotte Metro, NYC, or Richmond, VA.Hy...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Director of Data Engineering

    Director of Data Engineering

    Taskrabbit • New York, NY, US
    serp_jobs.job_card.full_time
    Taskrabbit is a marketplace platform that conveniently connects people with Taskers to handle everyday home to-do's, such as furniture assembly, handyman work, moving help, and much more.At Tas...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Lead

    Data Lead

    Allara Health • New York, NY, US
    serp_jobs.job_card.full_time
    Trusted by over 40,000 women nationwide, Allara makes expert healthcare accessible by connecting patients with multidisciplinary care teams that have a deep understanding of hormonal, metabolic, an...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Lead Data Engineer

    Lead Data Engineer

    Capital One • NEW YORK, New York, United States
    serp_jobs.job_card.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,. At Capital One, you'll be part of a big group of makers, ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Director Data Engineering

    Director Data Engineering

    Cardinal Integrated • Secaucus, NJ, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Engineering Lead

    Engineering Lead

    Tagup • New York, NY, US
    serp_jobs.job_card.full_time
    Tagup is a defense technology company founded at MIT that is redefining logistics superiority with next-generation AI.We’re growing rapidly and are looking for change-makers passionate about ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Lead CT Tech

    Lead CT Tech

    Hackensack Meridian Mountainside Medical Center • Montclair, NJ, United States
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Head of Data Engineering & Analytics Consulting

    Head of Data Engineering & Analytics Consulting

    Ippon Technologies • New York, NY, US
    serp_jobs.job_card.full_time +1
    We’re hiring a Head of Data Engineering & Analytics Consulting!.Full-time / Direct Hire only (No Agencies).Atlanta, GA, New York, NY, Washington, DC, Richmond, VA, Charlotte, NC, Metropolit...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted