Sr/Lead Data Engineer

Cti Consulting
Cincinnati, OH

Job Description- Data Engineer Level 3 (Model Behavior, Azure, Databrix, Synapse)

Position Overview

• We are looking for a highly skilled, hands-on Senior Data Engineer to join our Data & Analytics team.

• In this role, you will play a key part in building and scaling client's behavioral and Ecommerce data platform, enabling trusted analytics and making AI-ready data available across the organization.

• You will be responsible for designing and implementing robust, scalable data pipelines, modeling complex, high-volume datasets, and delivering high-quality, well-structured data products to power business insights and future AI capabilities.

• This is a delivery-focused engineering position demanding deep technical expertise in Azure, Databricks, and Synapse, combined with experience managing large-scale behavioral data in enterprise environments.

Translating business needs into technical specifications and platform capabilities is a critical part of this role.


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 datasets (digital behavior, Ecommerce transactions, marketing interactions) to support dashboards, experimentation, ML models, and marketing activation.

• Enforce data governance, discover ability, and stewardship using Unity Catalog and Alation, ensuring compliance and lineage tracking.

• Validate and reconcile data pipelines against established behavioral datasets such as Adobe Customer Journey Analytics (CJA) and Adobe Analytics.

• Partner with data architects, analysts, data scientists, and marketing teams to deliver trusted, reusable, and well-structured datasets that power BI dashboards and decision making.

• Mature the data ingestion, processing, orchestration, and curation capabilities leveraging Delta Lake optimization, Databricks Workflows, and Synapse for analytical consumption.

• Support and optimize semantic models and data marts that enable self-service analytics through AI/BI Dashboards and Power BI.

• Participate in agile delivery processes (sprint planning, backlog refinement, documentation), collaborating through Jira and Confluence.

• Document data assets, transformations, and pipelines for discoverability, transparency, and long-term maintainability.

Facilitate clear and continuous communication between business and engineering teams. Note to Vendors

• This contract role will be part of Customer Experience, supporting the Data & Analytics team.



Requirements

Required Qualifications

7+ years of experience in data engineering or similar roles, with hands-on delivery of cloud-based data solutions.

• Preferred Engineering certifications: Microsoft Certified: Azure Data Engineer Associate and Databricks: Databricks Certified Data Engineer Professional

• Strong expertise in Databricks and Azure Synapse, with practical experience in Sparkbased data processing.

• Proficient in modern data architectures (Lakehouse, ELT/ETL pipelines, real-time data processing).

• Advanced SQL skills for data transformation and performance optimization.

• Proven ability to model and manage large-scale, complex behavioral and Ecommerce datasets.

• Expert in BI and best practices for data enablement and self-service analytics.

• Hands-on experience with Unity Catalog and data cataloging tools (e.g., Alation) for governance and metadata management.

• Working knowledge of behavioral analytics platforms (Adobe Analytics, Adobe Customer Journey Analytics).

• Excellent communication skills with a talent for translating technical concepts into business value.

• Experience operating in agile delivery environments, balancing speed, scalability, and solution quality.

Proven leadership as a technical lead

Benefits



Posted 2025-11-07

Recommended Jobs

Explore Caring Connections in Scenic Chillicothe, OH!

NurseRecruiter
Chillicothe, OH

Speech Therapist Home Health job in Chillicothe, OH Embark on a fulfilling journey as a Speech Language Pathologist in scenic Chillicothe, OH. This travel nursing position offers a unique chance to e…

View Details
Posted 2025-07-30

Heat Treat/Induction Hardening Setup/Operator (SDKY) - 3rd Shift

U.S. Tsubaki Power Transmission, LLC
Sandusky, OH

Description: The TSUBAKI name is synonymous with excellence in quality, dependability and customer service. U.S. Tsubaki is a leading manufacturer and supplier of power transmission and motion contro…

View Details
Posted 2025-10-24

Temporary Support Associate

Coach
Columbus, OH

Coach is seeking a Temporary Support Associate in Columbus, OH to assist with retail operations and asset protection. This role involves supporting daily tasks, managing inventory, and providing excel…

View Details
Posted 2025-09-29

Supplier Partnership & Development -- Supplier Development Team Leader

GE Renewable Energy Power and Aviation
Cincinnati, OH

Job Description Summary The Supplier Development Team Leader manages a team dedicated to identifying opportunities to establish, improve, and standardize how GE Aerospace functions develop supplie…

View Details
Posted 2025-11-07

General Gastroenterology in Cincinnati Offering Above-Market Pay & Bonus

Enterprise Medical Recruiting
Ohio

A Top 15 US Health System in Cincinnati, Ohio is adding a General Gastroenterologist to join their well-established and growing team. This is an excellent opportunity to provide physician-led, patien…

View Details
Posted 2025-08-06

Full Time Urgent Care Physician Job Dayton, OH

Premise Health Premise Health
Dayton, OH

Premise's mission is to help people get, stay, and be well. We hope you will join us in our mission and experience why amazing health starts with amazing healthcare. For more information, visit As…

View Details
Posted 2025-10-21

Environmental Engineering Department Manager - Environmental Services

Burns & McDonnell
Columbus, OH

Description The Environmental Engineering Department Manager is responsible for the managerial direction and leadership of a department within a global practice or regional office. This includes s…

View Details
Posted 2025-10-24

Night Shift Server / Wait Staff

Waffle House, Inc.
Warren, OH

At Waffle House, we are not in the food business. We are in the People Business and we are hiring immediately for full time and part time servers for the Night Shift. Being in the People Business, w…

View Details
Posted 2025-09-22

Patient Care Coordinator

Care Alliance Health Center
Cleveland, OH

Mission Statement: To transform lives by providing exceptional, accessible, and compassionate healthcare experiences for all. Position Summary: Working with Care Alliance Health Center pat…

View Details
Posted 2025-09-10

Part-time Staff: Experiential Learning Specialist (Grant Funded)

Lakeland Community College
Kirtland, Geauga County, OH

Lakeland Community   College, serving approximately 8,000 students annually and located 25 miles east of Cleveland, Ohio, invites applications for this grant-funded (through June 2027), part-time sta…

View Details
Posted 2025-09-24