Must-Have Skills
o Strong ability to query, transform, validate, and optimize data for analytics, reporting, and pipeline workflows
o Experience building scalable data pipelines, automation scripts, and data processing workflows
o Hands-on experience designing and maintaining cloud data warehouse structures, tables, and performant data models
o Experience developing modular data transformations, testing, and documentation within modern ELT workflows
o Familiarity with AWS cloud services supporting scalable data storage, processing, and pipeline orchestration
o Experience building reliable workflows for extracting, transforming, loading, and validating data from multiple sources
o Ability to monitor pipeline health, troubleshoot workflow issues, and proactively improve reliability and data quality
Key Responsibilities
Technical Execution & Leadership
- Resource will provide technical execution and analytics leadership in support of the ADP Engineering team’s (part of the Central Analytics Organization) workstreams within the Marketplace domain and related initiatives
Data Pipeline Development
- Develop and optimize data pipelines
- Build scalable pipelines using Python and dbt to support efficient data transformation and integration
Data Management & Modeling
- Design and maintain database tables, Snowflake structures, and data models to support reporting and analytics needs
ETL / ELT Processes
- Develop robust ETL/ELT workflows for extracting, transforming, and loading data while maintaining data quality and consistency
Data Monitoring & Observability
- Improve pipeline reliability through monitoring, observability, and proactive issue resolution
Reporting & Dashboards
- Build dashboards and provide updates that support actionable insights and business decision-making
Collaboration & Communication
- Partner cross-functionally to align on requirements
- Communicate progress and ensure transparency across initiatives
