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.

• 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.

• 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.

• 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.