Report Writing and Integration Advisor

ADP South Africa is looking for a Report Writing and Integration **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 & This role supports Sage Premier & Sage300 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 We believe our people make all the difference in cultivating an inclusive, down-to-earth culture that welcomes ideas, encourages innovation, and values 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 Learn more about ADP's commitment on our YouTube channel: RESPONSIBILITIES:The main responsibilities of this role are analysing client requirements, creating reports using SQL & VBA, and testingGenerate and analyse reports for transformation from Sage Premier to Sage300 PeoplePrepare bespoke specification document as per C#, SQL & VBA coding and maintenance of C#, SQL scripts & VBA on an ongoing basisAnalyse errors or issues/changes and fix C#, SQL & VBA coding as per requirementCollaborate with the product team for faster resolution of defectsInteract with clients and understand their requirementsAmend existing SQL queries for performance improvements SKILLSETS REQUIRED:Expert in SQL - Data Query Language (DQL) CommandsMinimum of 3 -5 years' development experienceExperience in: Conditional selects / Subqueries / Multi-Table queries / Joins / Aggregate & string functions / Unions / Common Table ExpressionUse of Window FunctionsC# knowledgeExperience in VBA (Excel refresh and macro reports)Manual Testing SkillsStrong analytical and problem-solving skillsAbility to deliver projects on time and with the highest qualityGood communication skills to collaborate with different teamsQualification BSc (Computers) or equivalent BONUS POINTS FOR THESE:Product/process knowledgePayroll knowledgeKnowledge of DBMS and RDBMS concepts  YOU'LL LOVE WORKING HERE BECAUSE YOU CAN:Have courageous team 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 solutionDeliver at epic We deliver real user outcomes using strong judgement and good We're obsessed with the art of achieving simplicity with a focus on client happiness and productivityBe surrounded by curious We align ourselves with other smart people in an environment where we grow and elevate one another to the next We encourage our associates to listen, stay agile, and learn from mistakesAct like an owner & Mission-driven and committed to leading change, you will be encouraged to take on any challenge and solve complex No tasks are beneath or too great for We are hands-on and willing to master our craftGive back to Company-paid time off for volunteering for causes you care aboutJoin a company committed to equality and Our goal is to impact lasting change through our actionsLike what you see?  Apply now!