Sr. Data Engineer

ADP is hiring a Sr. Data Engineer.

Want to make an application Make sure your CV is up to date, then read the following job specs carefully before applying.

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.

WHAT YOU'LL DO :

• 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 deploy 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.
• Perform 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 cooperatively as part of a team, as well as independently.
• Excellent verbal and written communication skills.
• Working experience with Tableau and Alteryx.

PREFERRED QUALIFICATIONS :

• 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.
• Deliver at epic scale.
• Be surrounded by curious learners.
• Act like an owner & doer.
• Give back to others.
• Join a company committed to equality and equity.

What are you waiting for? Apply today!

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.

Ethics at ADP : ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws.

J-18808-Ljbffr