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