ADP is hiring a Sr. Data Engineer in San Dimas, CA.
Job Setting: Hybrid, 3 days in office
Does the thought of working with one of the most comprehensive employment data sets in the US excite you? Are you inspired by transformation and making an impact on the lives of millions of people every day?Well, this may be the role for you. Ready to design what's next?
In this role, you'll acquire, clean, and analyze large data sets and do exploratory analysis to understand our data and if it meets project requirements. It's more than digits and dials - you're making huge decisions that impact millions of customers.
Every day you'll work with multiple stakeholders to identify, design, develop and implement advanced analytics projects that track the consumer conversion funnel from start to end. You'll work with your team to provide, interpret, and predict necessary metrics for decision-making. You'll code with machine learning tools like Python, R, and Scala to synthesize millions of data sets into patterns that answer ad hoc requests and then use Tableau for data visualization.
To thrive in this career, you should know how to identify errors and reactively fix them. You'll need to have some formal education in quantitative analytics and know design patterns and data structures. You have the skills to leverage existing models or create new models using the technologies above. But given the scale of our data sets and the complex problems we give you to solve, you will stay challenged and engaged with years of exciting projects ahead—all while growing your skills and progressing in a rewarding career.
Like what you see? Apply now!
Learn more about ADP at tech.adp.com/careers
A little about ADP: We are a global leader in HR technology, offering the latest AI and machine learning-enhanced payroll, tax, HR, benefits, and much more. We believe our people make all the difference in cultivating an inclusive, down-to-earth culture that welcomes ideas, encourages innovation, and values belonging. ADP has a deep commitment to diversity, equity, and inclusion as a global Best Places to Work, DiversityInc® Top 50 Company, Best CEO and company for women, LGBTQ+, multicultural talent, and more. Learn more about ADP's commitment on our YouTube channel: http://adp.careers/DEI_Videos
WHAT YOU'LL DO:
Here's what you can expect on a typical day:
Participate effectively in relevant aspects of software development life cycle (SDLC) including planning, construction, testing, reviews and demonstrations. Collaborate with team to design, develop, test and refine deliverables. Investigate and resolve application issues as needed Package, configure and deploying software Collaborate with clients, Product Managers, Architects, & Analysts to develop and review requirements & design. Review and create system, software and functional design specifications that address requirements. Write scripts/procedures/statements using DML and DDL (SQL statements) against databases such as Oracle, SQLServer, DB2, etc. Design and develop multi-dimensional data models using star and snowflake schemas, denormalized data structures, slowly changing dimensions, etc. Use data integration tools and techniques such as ETL (Extract Transform Load), CDC (Change Data Capture), etc. Design and develop analytical data models to support static and ad-hoc reports, analytics and research, dashboards, data mining, trending, creation of key performance indicators, predictive modeling, etc. Deliver BI content via portals, thin/thick clients, email, mobile, etc Participate in project planning and release management. Expected to work on multiple projects at a time. Performs other related duties as assigned.TO SUCCEED IN THIS ROLE:
You'll have a Bachelor's degree OR equivalent. 3-5 years of directly related experience in Data Analytics / Business Intelligence Minimum of 3 years of hands-on experience with SQL Minimum of 3 years of hands-on experience with data engineering including ETL and data warehousing Minimum of 3 years of hands-on experience with building semantic-layer business intelligence solutions including metrics, dashboards and data visualizations Expert problem solving skills to rapidly create ad-hoc queries to answer complex business questions or debug data issues Experience developing complex queries against normalized and dimensional data model Ability to work co-operatively as part of a team, as well as independently Excellent verbal and written communication skills Working experience with Tableau and Alteryx
PREFERRED QUALIFICATIONS: Preference will be given to candidates who have the following:
Bachelor's Degree or its equivalent in education and experience with a major area of concentration in Computer Science, Engineering or Math Working experience with AWS, DataBricks, Snowflake Working experience with Python Working experience with Cognos Working experience in the HCM software or financial industry
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 find 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: https://youtu.be/ODb8lxBrxrY
(ADA version: https://youtu.be/IQjUCA8SOoA )
#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 $61,800.00 - $165,330.00 / Year
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.