Description
End-to-End Data Pipeline Development Design, build, and maintain robust data pipelines for ingestion, transformation, and delivery. Integrate data from multiple sources using SQL, APIs, Python scripts, and connectors. Ensure scalability, efficiency, and reliability of data workflows. Data Modeling & Preparation Clean, validate, and structure data for analytics and reporting. Develop and maintain data models optimized for Power BI/Tableau. Create efficient tables, views, and optimized SQL queries for performance. Dashboard Development (Power BI / Tableau) Design and develop interactive dashboards and reports in Power BI and/or Tableau. Translate business requirements into visual insights and KPIs. Optimize dashboards for usability, performance, and scalability. Automation & Scheduling Implement automated workflows for data refreshes and report updates. Manage scheduling tools and orchestrate recurring data processes. Monitoring & Alerting Set up automated alerts and KPI monitoring mechanisms. Monitor end-to-end pipeline health and quickly resolve failures or performance issues. Performance Optimization & Troubleshooting Diagnose and resolve issues across the data pipeline and dashboards. Optimize query performance, data refresh times, and dashboard responsiveness. Collaboration & Stakeholder Support Work closely with business stakeholders to understand requirements and deliver insights. Provide guidance on data availability, quality, and reporting best practices. Documentation & Governance Document data flows, pipelines, models, and dashboards. Ensure adherence to enterprise security, compliance, and governance standards (e.g., ADP policies). Required Skills Strong experience in Python (scripting, automation, data processing) Advanced SQL skills (complex queries, optimization, data modeling) Hands-on experience with Power BI and/or Tableau (dashboard development) Experience with data pipelines / ETL / ELT processes Experience working with APIs (REST/JSON integrations) Strong understanding of data modeling and analytics design Experience with automation, scheduling, and monitoring tools ##LI-DNIEnd-to-End Data Pipeline Development Design, build, and maintain robust data pipelines for ingestion, transformation, and delivery. Integrate data from multiple sources using SQL, APIs, Python scripts, and connectors. Ensure scalability, efficiency, and reliability of data workflows. Data Modeling & Preparation Clean, validate, and structure data for analytics and reporting. Develop and maintain data models optimized for Power BI/Tableau. Create efficient tables, views, and optimized SQL queries for performance. Dashboard Development (Power BI / Tableau) Design and develop interactive dashboards and reports in Power BI and/or Tableau. Translate business requirements into visual insights and KPIs. Optimize dashboards for usability, performance, and scalability. Automation & Scheduling Implement automated workflows for data refreshes and report updates. Manage scheduling tools and orchestrate recurring data processes. Monitoring & Alerting Set up automated alerts and KPI monitoring mechanisms. Monitor end-to-end pipeline health and quickly resolve failures or performance issues. Performance Optimization & Troubleshooting Diagnose and resolve issues across the data pipeline and dashboards. Optimize query performance, data refresh times, and dashboard responsiveness. Collaboration & Stakeholder Support Work closely with business stakeholders to understand requirements and deliver insights. Provide guidance on data availability, quality, and reporting best practices. Documentation & Governance Document data flows, pipelines, models, and dashboards. Ensure adherence to enterprise security, compliance, and governance standards (e.g., ADP policies). Required Skills Strong experience in Python (scripting, automation, data processing) Advanced SQL skills (complex queries, optimization, data modeling) Hands-on experience with Power BI and/or Tableau (dashboard development) Experience with data pipelines / ETL / ELT processes Experience working with APIs (REST/JSON integrations) Strong understanding of data modeling and analytics design Experience with automation, scheduling, and monitoring tools
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.
