Lead Data Engineer

ADP • Alpharetta, GA

88d

About The Position

ADP is hiring a Lead Data Engineer in our Alpharetta, GA office. This is a hybrid role. As a Lead Data Engineer, you will spearhead the design and delivery of a data hub/marketplace aimed at providing curated client service data to internal data consumers, including analysts, data scientists, analytic content authors, downstream applications, and data warehouses. You will develop a service data hub solution that enables internal data consumers to create and maintain data integration workflows, manage subscriptions, and access content to understand data meaning and lineage. You will design and maintain enterprise data models for contact center-oriented data lakes, warehouses, and analytic models (relational, OLAP/dimensional, columnar, etc.). You will collaborate with source system owners to define integration rules and data acquisition options (streaming, replication, batch, etc.). You will work with data engineers to define workflows and data quality monitors. You will perform detailed data analysis to understand the content and viability of data sources to meet desired use cases and help define and maintain enterprise data taxonomy and data catalog. This role requires clear, compelling, and influential communication skills. You will mentor developers and collaborate with peer architects and developers on other teams.

Requirements

• Bachelor's degree in computer science, information technology, or a similar field.
• 8+ years of experience integrating and transforming contact center data into standard, consumption-ready data sets.
• Advanced knowledge of cloud-based data engineering and data warehousing solutions, especially AWS, Databricks, and/or Snowflake.
• Highly skilled in RDBMS platforms such as Oracle, SQLServer.
• Familiarity with NoSQL DB platforms like MongoDB.
• Understanding of data modeling and data engineering, including SQL and Python.
• Strong understanding of data quality, compliance, governance and security.
• Proficiency in languages such as Python, SQL, and PySpark.
• Experience in building data ingestion pipelines for structured and unstructured data.
• Ability to design and develop scalable data pipelines.
• Knowledge of cloud-based and on-prem contact center technologies.
• Experience with code repository and project tools such as GitHub, JIRA, and Confluence.
• Working experience with CI/CD process, with hands-on expertise in Jenkins, Terraform, Splunk, and Dynatrace.
• Detail-oriented with strong analytical, problem-solving, and organizational skills.
• Ability to clearly communicate with both technical and business teams.

Nice To Haves

• Knowledge of Informatica PowerCenter, Data Quality, and Data Catalog.
• Knowledge of Agile development methodologies.
• Having a Databricks data engineer associate certification.

Responsibilities

• Define and design complex data integration solutions with general direction and stakeholder access.
• Work independently and as part of a global, multi-faceted data warehousing and analytics team.
• Develop a service data hub solution for internal data consumers.
• Design and maintain enterprise data models for contact center-oriented data lakes and warehouses.
• Collaborate with source system owners to define integration rules and data acquisition options.
• Work with data engineers to define workflows and data quality monitors.
• Perform detailed data analysis to understand content and viability of data sources.
• Help define and maintain enterprise data taxonomy and data catalog.
• Mentor developers and collaborate with peer architects and developers.

Benefits

• Courageous team collaboration.
• Deliver at epic scale.
• Be surrounded by curious learners.
• Act like an owner - doer.
• Give back to others.
• Join a company committed to equality and equity.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees