Data Engineer Level 3 - 25-03201

Job Description LeadStack Inc. is an award winning, one of the nation's fastest growing, certified minority owned (MBE) staffing services provider of contingent workforce. As a recognized industry leader in contingent workforce solutions and Certified as a Great Place to Work, we're proud to partner with some of the most admired Fortune 500 brands in the world. Job Title: Data Engineer Level 3 (W2 only) Location: Blue Ash, OH (Hybrid – 4 Days Onsite per Week) Duration: 12 Months Pay Rate: $60/hr – $85/hr on W2 Local only Job Description We are seeking a highly skilled and hands-on Senior Data Engineer to join our Data & Analytics team. In this role, you will play a key part in building and scaling the organization’s behavioral and Ecommerce data platform, enabling trusted analytics and making AI-ready data available across the enterprise. This is a delivery-focused engineering role that requires deep technical expertise in Azure, Databricks, and Synapse, along with experience managing large-scale behavioral data in complex enterprise environments. The ideal candidate will excel in translating business requirements into scalable technical solutions and platform capabilities. Required Qualifications • 7+ years of experience in Data Engineering or similar roles, with hands-on delivery of cloud-based data solutions. • Preferred certifications: Microsoft Certified: Azure Data Engineer Associate and Databricks Certified Data Engineer Professional. • Strong expertise in Databricks and Azure Synapse, with real-world experience in Spark-based data processing. • Proficiency in modern data architectures (Lakehouse, ELT/ETL pipelines, real-time data processing). • Advanced SQL skills for data transformation and performance tuning. • Proven track record of modeling and managing large-scale behavioral and Ecommerce datasets. • Deep understanding of BI best practices, data enablement, and self-service analytics. • Hands-on experience with Unity Catalog and data cataloging tools such as Alation for governance and metadata management. • Working knowledge of behavioral analytics tools, including Adobe Analytics and Adobe Customer Journey Analytics. • Excellent communication skills with the ability to translate complex technical details into business value. • Experience operating in agile delivery environments (Jira, Confluence). • Demonstrated technical leadership experience as a Lead Engineer. Key Responsibilities • Design, build, and maintain robust, scalable ELT/ETL pipelines and data transformations using Databricks, Spark, and Synapse. • Model high-volume, complex event-level data (digital behavior, Ecommerce transactions, marketing interactions) to enable dashboards, ML models, and marketing analytics. • Enforce data governance and lineage tracking using Unity Catalog and Alation. • Validate and reconcile data with behavioral datasets such as Adobe Customer Journey Analytics (CJA) and Adobe Analytics. • Partner with data architects, analysts, data scientists, and marketing teams to deliver reusable, high-quality datasets that support BI and decision-making. • Enhance data ingestion, processing, and orchestration capabilities using Delta Lake optimization, Databricks Workflows, and Synapse. • Support and optimize semantic models and data marts for AI/BI dashboards and Power BI self-service analytics. • Participate in Agile sprints, including planning, backlog refinement, and technical documentation. • Maintain detailed documentation of data assets, transformations, and pipelines to ensure transparency and long-term maintainability. • Facilitate clear, continuous communication between business and engineering teams to align priorities and deliver value. know more about current opportunities at LeadStack , please visit us on https://leadstackinc.com/careers/ Should you have any questions, feel free to call me on (513) 3184502 or send an email on waseem.ahmad@leadstackinc.com