ADP is hiring a Lead Data Operations Engineer – Sales and Marketing.

 

The Lead Data Operations Engineer will develop and support our sales and marketing data lake house and data pipelines through integration, analytics and reporting using both on premises and cloud-based technology.   Operating within a cross-functional agile team, the Engineer will interface with product owners, data architects, data scientists and developers to define and understand data engineering requirements and implement solutions. The Engineer will perform data wrangling – ingesting, cleansing, and combining data from many sources- enabling additional segmentation, measurement, and activation capabilities across the client experience spectrum. The Engineer will also produce advanced data analysis and metrics and support the data pipeline CI/CD system.

 

Main responsibilities:

Interface with product owners, data architects, data scientists and developers to define and understand data engineering requirements and implement solutions Implement solutions to aggregate and consolidate vast, complex data sets to empower business leaders to make better, data-informed decisions. Develop Python notebooks to perform data wrangling – ingesting, cleansing, and combining data from many sources- enabling additional segmentation, measurement, and activation capabilities across the client experience spectrum Integrate and optimize performance of  python notebooks in highly complex Databricks workflows Provide operational support for 24/7 Business Critical data pipelines Create and improve processes and standards to automate and optimize data delivery and scalability. Create solutions to provide visibility and metrics (KPIs) providing insights into data pipeline operational efficiency. Analyze data to identify and interpret associations, trends, and patterns.

Qualifications:

3+ years of experience in Python/PySpark for data engineering on Databricks with Unity Catalog. 6+ years of experience in data engineering or database administration, ETL, business intelligence, and advanced SQL with traditional databases like Oracle, SQL Server, Postgres and others. Extensive experience in writing complex SQL queries to extract, transform and load data from large heterogenous data sources to meet business requirements. Exposure to marketing data domain knowledge- sales automation, sales processes, Salesforce.com integrations with Databricks, Salesforce Data cloud and zero-copy options is desirable. Experience with Databricks on AWS web services, and with Redshift is desirable Experience visualizing data with PowerBI is desirable. Knowledge about database architecture and schema design to create and load data to tables. Basic knowledge of API configuration to extract and load data into databases. Bachelor's Degree -- Computer Science or equivalent 

#LI-RG2

Base salary offers for this position may vary based on factors such as location, skills, and relevant experience. Some positions may include additional compensation in the form of bonus, equity or commissions. We offer the following benefits: Medical, Dental, Vision, Life Insurance, Matched Retirement Savings, Wellness Program, Short-and Long-Term Disability, Charitable Contribution Match, Holidays, Personal Days & Vacation, Paid Volunteer Time Off, and more. The compensation for this role is $79,800.00 - $213,930.00 / Year*

A little about ADP: We are a comprehensive global provider of cloud-based human capital management (HCM) solutions that unite HR, payroll, talent, time, tax and benefits administration and a leader in business outsourcing services, analytics, and compliance expertise. We believe our people make all the difference in cultivating a down-to-earth culture that embraces our core values, welcomes ideas, encourages innovation, and values belonging. We've received recognition for our work by many esteemed organizations, learn more at ADP Awards and Recognition

Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP: ADP is committed to an inclusive, diverse and equitable workplace, and is further committed to providing equal employment opportunities regardless of any protected characteristic including: race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, protected veteran status or disability. Hiring decisions are based upon ADP’s operating needs, and applicant merit including, but not limited to, qualifications, experience, ability, availability, cooperation, and job performance.

Ethics at ADP: ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws. We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace. Click https://jobs.adp.com/life-at-adp/ to learn more about ADP’s culture and our full set of values.