ADP South Africa is looking for a Report Writing and Integration Advisor.

*The role is hybrid and can be based in either CAPE TOWN OR PRETORIA*

THE ROLE:

The team is completely responsible for the end-to-end development of bespoke reports as per client requirements, developed in SQL & VBA.

This role supports Sage Premier & Sage300 People.

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

RESPONSIBILITIES:

• The main responsibilities of this role are analysing client requirements, creating reports using SQL & VBA, and testing

• Generate and analyse reports for transformation from Sage Premier to Sage300 People

• Prepare bespoke specification document as per C#, SQL & VBA coding and maintenance of C#, SQL scripts & VBA on an ongoing basis

• Analyse errors or issues/changes and fix C#, SQL & VBA coding as per requirement

• Collaborate with the product team for faster resolution of defects

• Interact with clients and understand their requirements

• Amend existing SQL queries for performance improvements

SKILLSETS REQUIRED:

• Expert in SQL – Data Query Language (DQL) Commands

• Minimum of 3 -5 years’ development experience

• Experience in: Conditional selects / Subqueries / Multi-Table queries / Joins / Aggregate & string functions / Unions / Common Table Expression

• Use of Window Functions

• C# knowledge

• Experience in VBA (Excel refresh and macro reports)

• Manual Testing Skills

• Strong analytical and problem-solving skills

• Ability to deliver projects on time and with the highest quality

• Good communication skills to collaborate with different teams

• Qualification BSc (Computers) or equivalent

BONUS POINTS FOR THESE:

• Product/process knowledge

• Payroll knowledge

• Knowledge of DBMS and RDBMS concepts

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 judgement 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. Company-paid time off for volunteering for causes you care about

• Join a company committed to equality and equity. Our goal is to impact lasting change through our actions

Like what you see? Apply now!

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.