Lead Analytical Data Engineer

ADP is hiring a Lead Analytical Data Engineer for our newly formed HR Outsourcing (HRO) Data and Analytics organization. The Lead Analytical Data Engineer will play a key role in growing our newest chapter of analytics engineering professionals while interacting with cross-functional teams to address complex business requirements. We’re seeking a value-seeking, self-motivated, and analytical professional who acts as a player and coach to multiple workstreams at the same time. The role demands the individual to possess technical skills required to perform the job effectively. The right candidate will be a technical expert, should have a passion for data & analytics, and work along with the team they manage.

What are we looking for?

An analytics and data engineering professional with a passion and track record for designing analytics and delivery methods to increase the accuracy of reporting and advanced analytics in an agile environment to unlock transformational growth. Someone with intellectual curiosity who wakes up excited to work with a team towards excellence and partner with leaders to drive business outcomes and deliver analytical solutions. The ideal candidate is business-minded, customer-centric, team-oriented, self-motivated, a strategic thinker, and results-driven.

WHAT YOU'LL DO:

• Support the enhancement of data workstreams. As a seasoned data engineer, you strive to contribute to the growth of the team and your own skills. You actively seek opportunities to share your knowledge and collaborate effectively with your colleagues to maintain a high level of productivity.
• Customer-focused. You align data strategies with business objectives, working closely with key stakeholders in business and analytics functions to help them leverage data for added value. Your role involves facilitating data access for data science and business intelligence applications.
• Effective Communicator. You possess strong communication skills, both written and verbal, enabling you to convey data-related information to various team members and leadership. Your ability to articulate working plans and priorities within the team is an asset.
• Deliver Results. You are proactive and hands-on, addressing potential issues and ensuring that tasks are completed with attention to detail. The end product you and your team produce are of high quality and thoroughly polished.
• Your daily tasks are versatile and can include interactions with the Chief Data Officer, participating in leadership meetings to discuss upcoming initiatives, and assisting your team in overcoming obstacles.
• Continuous Improvement. You are committed to documenting existing analytics and automation processes and suggesting and implementing best practices to enhance efficiency and optimization.
• Problem Solving. You are ready to tackle challenges as they arise and find effective solutions to overcome them.

Responsibilities

• Strategic Data Solution Development: Be the primary contributor to the development of data solutions with a strategic outlook, focusing on the broader scope of building and enhancing domains within the semantic layer of HRO.
• Documentation and Best Practices: Catalog existing analytics and automation processes and provide recommendations for best practice methods to optimize and improve these processes.
• Collaborative Stakeholder Engagement: Collaborate closely with Strategic Pod Operations, Data Science, Business Intelligence, and Senior Leadership to create comprehensive roadmaps and execute project plans within a fast-paced agile development environment.
• Data Engineering Expertise: Lead and create the development of data tables tailored to specific use-cases by skillfully engineering critical elements from multiple data domains. Ensure the ingestion of HRO-specific data is well-structured, compliant with data quality standards, and traceable from the consumption layer back to the raw data layer.
• Strategic Integration and Security: Partner with the Data Operations, Data Governance, and Strategic Pod Operations teams to streamline data integration, maintain data security, and access best practices. Contribute to the creation of end-to-end data analytics solutions.
• Technological Advancement: Conduct thorough research to identify and recommend cutting-edge technologies and processes that support rapid scaling and future growth initiatives.
• Prioritization and Delivery: Spearhead the prioritization of Business Needs, Leadership Questions, and Ad Hoc Requests to ensure on-time delivery and alignment with organizational goals.
• Quality Assurance: Drive the quality assurance and data quality efforts to enhance development timelines, reduce bugs, and maintain the reliability of our analytics products.
• Iterative Development: Bring your experience in developing v0.5 solutions, incorporating real-world feedback, and iterating to v1.0+ with a continuous improvement mindset.
• Exceptional Delivery: Leverage your successful track record of superior delivery and change management within an enterprise organization to drive positive change and growth.

To Succeed In This Role

• Educational Background: Possess a bachelor’s degree in computer science, engineering, business, statistics, or related fields; advanced degrees are preferred but not mandatory.
• Experience: Demonstrate a strong foundation in data analytics, engineering, and project management with a minimum of 8+ years of hands-on experience in the implementation, development, improvement, and support of data-related projects.
• Matrix Organization Experience: Showcase 3+ years of experience working in a matrix organization, where you directed the development team to achieve use case goals.
• Data Expertise: Exhibit deep experience with ETL (Extract, Transform, Load), Data Modeling, and Data Architecture, highlighting your ability to design and maintain data solutions.
• Industry Knowledge: Preference will be given to candidates with a background in PEO, Service, or Risk analytics, data engineering, data analytics and visualization, business intelligence, or analytical consulting.
• Problem-Solving Aptitude: Prove your ability to lead a team in leveraging data, analytics, and business acumen to address intricate business challenges.
• Data Warehouse and Big Data Experience: Possess hands-on experience in designing and maintaining data warehouses and/or data lakes using big data technologies such as Hadoop, Spark, and especially DataBricks. Demonstrate expertise in managing data housed in various relational databases.
• Data Pipeline Proficiency: Showcase your expert competence in building data pipelines and deploying/maintaining them using tools like Git and Jenkins.
• MLOps and Containerization Knowledge: Familiarity with MLOps infrastructure (e.g., Databricks, MLflow) and containerization, including experience in managing production pipelines and microservices using technologies like Docker and Kubernetes.
• Data Analytics Skills: Demonstrate experience and expertise in data mining methods, data modeling, and working with data warehouses, showcasing your ability to extract valuable insights.

Preferred Qualifications

• Proficiency in DataBricks: Hands-on experience and strong technical knowledge with DataBricks, particularly focusing on Apache Spark fundamentals, including Spark Architecture, its APIs, and how to leverage it for data processing and analysis. Proficiency in Pyspark/Python/SQL is essential for data manipulation, analysis, and transformation.
• AWS Certification: AWS certification is highly desirable, reflecting your expertise in cloud technologies and services.
• Framework Development: Experience in developing frameworks and utility services, including logging/monitoring is an asset, demonstrating your ability to create efficient and scalable solutions.
• Programming Skills: Proficiency in UNIX and the Python programming language is essential, as it is fundamental for data engineering tasks.
• Software Development Best Practices: Proven experience in delivering high-quality software following continuous delivery practices and using code quality tools such as JIRA, GitHub, and Jenkins is a strong advantage.
• Data Storage Solutions: Comfort with a variety of data storage solutions, including RDBMS (e.g., Oracle), Hive, HBase, Impala, and other options, showcases your versatility in handling different data storage needs.
• NoSQL Databases: Knowledge of NoSQL databases like MongoDB, HBase, Cassandra, etc., is a plus, highlighting your familiarity with a range of data storage technologies.
• Project Management Tools: Familiarity with Jira and Confluence is preferred, as it facilitates effective project management and documentation.
• Data Solutions Architecture: While not mandatory, experience as a data solutions architect is considered a significant advantage, demonstrating your ability to design comprehensive data solutions.
• Cloud Database Technologies: Experience with cloud database technologies, especially in the AWS environment, and the ability to develop solutions on cloud computing services and infrastructure in the data and analytics space is a valuable skill set.
• PySpark Expertise: Comfort with using PySpark APIs to perform advanced data transformations is a key technical requirement.

You'll Love Working Here Because You Can

• Have courageous team collaboration. Courage comes from how associates are willing to have difficult conversations, speak up, be an owner, and challenge one another's ideas to net out the best solution.
• Deliver at epic scale. We deliver real user outcomes using strong judgment and good instincts. We're obsessed with the art of achieving simplicity with a focus on client happiness and productivity.
• Be surrounded by curious learners. We align ourselves with other smart people in an environment where we grow and elevate one another to the next level. We encourage our associates to listen, stay agile, and learn from mistakes.
• Act like an owner & doer. Mission-driven and committed to leading change, you will be encouraged to take on any challenge and solve complex problems. No tasks are beneath or too great for us. We are hands-on and willing to master our craft.
• Give back to others. Always do the right thing for our clients and our community and humbly give back to the community where we live and work. Support our associates in times of need through ADP's Philanthropic Foundation.
• Join a company committed to equality and equity. Our goal is to impact lasting change through our actions.

What are you waiting for? Apply today!

Find out why people come to ADP and why they stay:

(ADA version: )

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 here to learn more about ADP’s culture and our full set of values.