Job Information
ADP Senior Data & BI Reporting Engineer in San Dimas, California
ADP is hiring a Senior Data & BI Reporting Engineer.
In this role, you will be responsible for acquiring, cleansing, and analyzing large data sets using technologies like Databricks, S3, Python, Oracle and do exploratory analysis to understand our complex data structures and relationships and create data reporting using tools like Tableau. You'll work with multiple stakeholders to identify, design, develop and implement ad-hoc data reporting solutions and provide data required for decision-making. You'll synthesize data sets into patterns that answer ad hoc requests.
No two days are the same. You will work alongside a team of passionate, creative developers to design data extraction, develop data models, and provide data for reporting and analysis. You will also use data to help drive business decisions and improve operational processes.
To thrive in this role, you’ll need to be an expert in data technologies like Databricks, Snowflake, SQL, Python, and Tableau and have a strong background in data engineering, data analytics and reporting solution development. Our best developers are enthusiastic creators who stay current on new codes. They’re always looking for new ways to make tools better for our users, knowing that what we do touches their lives in an important way.
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. A global Best Places to Work, DiversityInc® Top 50 Company, Best CEO and company for women, LGBTQ+, multicultural talent, and more, ADP has a deep commitment to diversity, equity, and inclusion. 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 in the life of a Senior Data & BI Reporting Engineer at ADP.
Data Reporting and Analytics
Analyze data patterns between disparate complex data sources and structures.
Design and develop data extractions and complex transformations using ETL tools to do data research from various data sources with prior experience in Cloud technologies like AWS, Databricks etc.
Create robust data reporting solutions through Cognos and Tableau to support analytics, research, dashboards, data mining, trending etc.
Create and present analysis to individuals in business language to drive business decisions.
Follow SDLC cycle and ensure robust data testing and accuracy.
Collaborate with business team to design, develop, test and refine deliverables.
Design data trending charts using complex datasets.
Develop complex queries against Mainframe, Oracle, DB2, S3, Databricks etc.
Understand the enterprise applications architecture design and development best practices for analytical applications.
Administration
Administer IBM Cognos reporting environment.
User set-up and security.
Problem Solving
Comfortable working with complex data scenarios with tech that has never been used before. Inevitable challenges will arise, and we'll rely on you to look for a solution.
Expert problem-solving skills required to interpret complex information and present the best way to move forward.
Technical and Business acumen to participate in the analysis, design, testing and implementation of new and existing business process.
Innovation with ability to “think outside the box” is important.
Communication & Teamwork
Communication skills with ability to clearly explain complex issues and drive consensus.
Ability to work co-operatively as part of a team, as well as independently.
Learning You’re always learning and operating with a "figure it out" mentality.
A college degree in Computer Science, Engineering, Statistics, or Math is great but not required. What's more important is having the skills and experience to do the job. To be successful in this role , you'll have 5-7 years of experience in the same or similar role driving complex data reporting and analytics using SQL, Databricks, Python, Tableau etc.
TO SUCCEED IN THIS ROLE:
Bachelor's Degree or its equivalent in education and experience with a major area of concentration in Computer Science, Engineering, Statistics, or Math. Isn't required but could set you apart.
5 - 7 years of directly related experience in working with complex data engineering and analytics.
Minimum of 5 years of hands-on experience with SQL, Databricks, Snowflake, Python, Tableau etc.
Knowledge of advanced scripts/procedures/statements using DML and DDL (SQL statements) against databases such as Oracle, SQL Server, DB2, etc.
YOU'LL LOVE WORKING HERE BECAUSE YOU CAN:
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 navigating 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-PP1
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.