Position DescriptionADP 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: 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 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 solutionDeliver 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 productivityBe 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 mistakesAct 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 craftGive back to others. Company-paid time off for volunteering for causes you care aboutJoin a company committed to equality and equity. Our goal is to impact lasting change through our actions Like what you see?Apply now!
