Report Writing and Integration Advisor

6 months ago

Cape Town, South Africa ADP Full time

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**:
**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

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

  • Report Writing Specialist

    4 weeks ago

    Cape Town, South Africa Bantu x Batho Projects PTY Full time

    **About the Role**: **Qualifications**: - Bachelor’s degree in Communications, Finance, or a related field. - **Certified Professional Technical Writer** or equivalent certification (preferred). **Experience**: - Minimum 5 years of experience in report writing, preferably within financial or municipal contexts. - Strong understanding of financial...

  • Facilities Maintenance Manager

    1 month ago

    Cape Town, Western Cape, South Africa Integration Resourcing Full time

    At Integration Resourcing, we are seeking a seasoned Facilities Maintenance Manager to join our team. This is a unique opportunity to lead the maintenance and operational efficiency of a mixed-use property development in Cape Town.About the RoleThis is an exciting role that requires a high degree of technical knowledge, business acumen, and leadership...

  • Head of Marketing

    6 months ago

    Cape Town, South Africa Integration Full time

    **Head of Marketing - luxury safari lodges** Our Client is an award-winning collection of luxury lodges and camps (which they own) located in Botswana, Zambia and Zimbabwe. The camps are carefully positioned in untamed and pristine parts of Southern Africa - expect authenticity, adventure and exploration as well as all the comforts fit for the modern...

  • Travel Writer Copywriter

    6 months ago

    Cape Town, South Africa Integration Full time

    **Junior to Mid-weight Copywriter/Travel writer** Our Client is an award-winning collection of luxury lodges and camps (which they own) located in Botswana, Zambia and Zimbabwe. The camps are carefully positioned in untamed and pristine parts of Southern Africa - expect authenticity, adventure and exploration as well as all the comforts fit for the modern...

  • Senior Advisor

    4 months ago

    Cape Town, South Africa National Debt Advisors Full time

    National Debt Advisors is 1 of the top leading debt review companies in South Africa. Working with the absolute best Team to help thousands of South Africans become financially free. At National Debt Advisors we are committed to fairness, diversity and equal growth opportunities for all our employees. We are looking for a strong determined individual to...

  • Digital Marketing Manager

    7 months ago

    Cape Town, South Africa Integration Full time

    **Digital Marketing Manager - inhouse (mid weight)** Cape Town (hybrid) As one of Africa's premier safari operators, we are committed to providing our clients with unparalleled wildlife experiences while promoting conservation and ecological integrity. Join our marketing team as an innovative Mid-Weight Digital Marketing Manager and take our digital...

  • Financial Advisor Assistant

    6 months ago

    Cape Town, South Africa Kamo Placement Full time

    Western Cape, CPT - CBD - Annually Cost To Company (Market related, Negotiable) To deliver exceptional Administration Support to Financial Advisers, in their goal to secure new Clients and service an existing Client base **JOB DESCRIPTION**- Screening of all other requirements relating to the financial transaction.- - Screening of confirmations of...

  • Advisor - Human Resources, Labour Relations and

    6 months ago

    Cape Town, South Africa Secondments Recruitment Full time

    **Job Advert Summary**: Reporting to the Senior Advisor: HR, LR & Dispute Resolution, this role will provide generalist HR advice and support and monitor legislative, policy and procedural compliance in municipalities to strengthen the institutional capacity and governance in municipalities, to address municipal and capacity challenges and also to coordinate...

  • Database Integration Specialist

    3 days ago

    Cape Town, Western Cape, South Africa People Solved Full time

    At People Solved, we are seeking a talented Database Integration Specialist to join our team. As a key member of our data analytics group, you will play a critical role in integrating new sources of data into our company databases.The successful candidate will have experience with relational databases, writing T-SQL queries, stored procedures, and functions....

  • Senior Energy Advisor

    2 months ago

    Cape Town, Western Cape, South Africa Assegai Recruitment Full time

    Job Title: Senior Energy AdvisorJob Description:We are seeking a Senior Energy Advisor to join our team at Assegai Recruitment. The successful candidate will have experience in working on various Lender's Technical Advisory and Owner's Engineering services for utility scale renewable energy projects (Wind and Solar).Responsibilities:Project Management and...

  • Strategic Advisor Growth Specialist

    2 weeks ago

    Cape Town, Western Cape, South Africa HR Genie Full time

    Overview:The Strategic Advisor Growth Specialist plays a pivotal role in driving revenue growth for designated financial advisors, while also fostering the integration of newly recruited advisors into the firm. This role is responsible for implementing strategic initiatives and leveraging advanced technology to enhance advisor performance, expand client...

  • Integration Engineer

    3 weeks ago

    Cape Town, South Africa First Quantum Minerals LTD Full time

    Job title : Integration EngineerJob Location : Western Cape, Cape TownDeadline : December 19, 2024Quick Recommended Links Jobs by Location Job by industries Job description: Purpose of the role: Reporting to the Group Data Analytics Lead, the Integration Engineer will develop a strategy alongside the Integration Architect and partner with delivery teams to...

  • Integration Engineer

    3 weeks ago

    Cape Town, South Africa First Quantum Minerals LTD Full time

    Job title : Integration Engineer Job Location : Western Cape, Cape Town Deadline : December 19, 2024 Quick Recommended Links Jobs by Location Job by industries Job description: Purpose of the role: Reporting to the Group Data Analytics Lead, the Integration Engineer will develop a strategy alongside the Integration Architect and...

  • Junior Financial Advisor

    2 months ago

    Cape Town, South Africa The Recruitment Council Full time

    Job Title: Junior Financial AdvisorReporting To: Regional HeadPurpose of the Job:The Junior Financial Advisor plays a pivotal role in contributing to the overall profitability of the business by supporting advisory partners with documentation and compliance requirements for both existing and new clients. This position requires a proactive individual with a...

  • Tourplan Consultant

    6 months ago

    Cape Town, South Africa Integration Full time

    **Tourplan Consultant** Our Client is an award-winning collection of luxury lodges and camps (which they own) located in Botswana, Zambia and Zimbabwe. The camps are carefully positioned in untamed and pristine parts of Southern Africa - expect authenticity, adventure and exploration as well as all the comforts fit for the modern traveller. Their Head...

  • Sustainability and Impact Officer: Conservation

    6 months ago

    Cape Town, South Africa Integration Full time

    Our Client operates 18 luxury tented bush camps and lodges (and counting) amid untamed wilderness areas in Botswana, Zambia and Zimbabwe. They promote and influences safari travel to Africa on a global scale while operating with a strong focus on conservation and an environmentally sustainable footprint that celebrates the culture of communities in the areas...

  • Nature Conservation Officer

    6 months ago

    Cape Town, South Africa Integration Full time

    Nature Conservation Officer Our Client is a mixed-use development in Cape Town combining office, retail, residential and leisure components in an integrated, stimulating and aesthetically pleasing urban environment. They are looking for a Nature Conservation Officer to assist in the management, promotion and improvement of the environmentally important...

  • Legal Advisor

    2 months ago

    Cape Town, South Africa Allan and Gill Gray Philanthropy Full time

    Purpose of Role Allan & Gill Gray Philanthropies Africa (AGGP) is a multi-national philanthropic group of companies with its operations in South Africa, Kenya, Ethiopia and Rwanda. The vision of AGGP is to attack poverty by investing in, nurturing and empowering entrepreneurs and leaders who benefit society by helping to accelerate meaningful employment...

  • Legal Advisor

    2 months ago

    Cape Town, South Africa Allan and Gill Gray Philanthropy Full time

    **Purpose of Role**: Allan & Gill Gray Philanthropies Africa (AGGP) is a multi-national philanthropic group of companies with its operations in South Africa, Kenya, Ethiopia and Rwanda. The vision of AGGP is to attack poverty by investing in, nurturing and empowering entrepreneurs and leaders who benefit society by helping to accelerate meaningful employment...

  • Compliance and Reporting Expert

    1 week ago

    Cape Town, Western Cape, South Africa Kontak Recruitment Full time

    Job DescriptionThe company is a distributed power and remote monitoring company in the mobile telecommunications industry seeking an experienced Compliance and Reporting Expert to oversee financial operations, including accurate reporting, general ledger management, tax compliance, and cash flow management. This role also supports budgeting, forecasting,...