Senior Data Automation Analyst

4 weeks ago

Cape Town, South Africa Collinson Full time

Collinson is the global, privately-owned company dedicated to helping the world to travel with ease and confidence. The group offers a unique blend of industry and sector specialists who together provide market-leading airport experiences, loyalty and customer engagement, and insurance solutions for over 400 million consumers.

Collinson is the operator of Priority Pass, the world’s original and leading airport experiences programme. Travellers can access a network of 1,500+ lounges and travel experiences, including dining, retail, sleep and spa, in over 650 airports in 148 countries, helping to elevate the journey into something special. We work with the world’s leading payment networks, over 1,400 banks, 90 airlines and 20 hotel groups worldwide.

We have been bringing innovation to the market since inception - from launching the first independent global VIP lounge access Programme, Priority Pass to being the first to sell direct travel insurance in the UK through Columbus Direct and creating the first loyalty agency of its kind in the travel sector with ICLP. Today we still invest heavily in innovation to ensure that we continue to deliver superior customer experiences.

Key clients include Visa, Mastercard, American Express, Cathay Pacific, British Airways, LATAM, Flying Blue, Accor, EasyJet, HSBC, Chase, HDFC.

Our mission is focused on doing good beyond profit, which for us means we seek out opportunities for our people to share in our success and that we give back to the communities and people within which we work.

Never short of ambition, the success of our business is delivered through the diverse and talented team of over 1,800 global colleagues.

**Purpose of the Job**

**Key Responsibilities**

1. Finance Data Analysis, Structuring & Reporting:

- Perform in-depth structuring using Microsoft Excel to manage and analyse data sets, model scenarios, and produce insights.
- Build, maintain, and refine complex Excel models with formulas, pivot tables, conditional formatting, and advanced functions to support various finance processes.

2. Process Automation with Power Automate:

- Design, implement, and maintain automated workflows in Power Automate to streamline repetitive tasks, reduce errors, and improve data accuracy in finance operations.
- Continuously monitor and troubleshoot workflows to optimize performance and adapt to changing business needs.
- Experience working with Microsoft Dynamics is desirable

3. Financial Data Management & Integrity:

- Ensure data accuracy and integrity in all financial models and automated workflows, implementing robust data validation and control measures.
- Work with the finance team to identify data gaps and opportunities for automation and implement enhancements using Excel and Power Automate.
- Perform regular audits and quality checks to ensure data accuracy across financial systems and workflows.

4. Cross-Department Collaboration:

- Collaborate with finance, accounting, and operations teams to understand financial data needs and automate reporting processes.
- Provide training and support to team members on best practices for using Excel and Power Automate in finance tasks.
- Act as a point of contact for troubleshooting Excel and Power Automate issues, and identify solutions that enhance team efficiency.

5. Continuous Improvement & Documentation:

- Stay up-to-date on new Excel and Power Automate features, integrating relevant updates into finance processes.
- Document all automated workflows, Excel models, and reporting processes for easy access and knowledge sharing across the finance team.
- Proactively seek opportunities to improve workflows and reporting efficiency, suggesting new tools or methods where beneficial.
- Education: Bachelor’s degree in Finance, Accounting, Business, Data Analytics, or a related field.
- Experience: Experience in a finance and accounting data analysis role with a proven track record of using Excel and Power Automate for process automation.
- Technical Skills:

- Advanced proficiency in Microsoft Excel (formulas, pivot tables, VBA macros, data visualization, etc.).
- Strong knowledge of Microsoft Power Automate, with experience creating, testing, and maintaining workflows.
- Familiarity with other Microsoft tools, such as Power BI, Power Query, and SharePoint is a plus.
- Analytical Skills: Ability to analyse large datasets, interpret data structures, and provide automation producing actionable insights.
- Attention to Detail: Highly organized with a focus on data accuracy and quality control.
- **Preferred Qualifications**:
- Experience with financial software (e.g. Microsoft Dynamics).
- Certification in Microsoft Office Specialist (Excel Expert) or Microsoft Power Automate is a plus

**Key Competencies**:

- Problem-Solving: Proactively identifies and resolves issues in workflows.
- Communication: Strong written and verbal communication skills, with the ability to translate complex data into clear insights.
- Time M

  • Junior Automation Analyst

    4 weeks ago

    Cape Town, South Africa DigiBlu Full time

    Role Overview The Junior Automation Analyst is responsible for assisting the Consulting Team throughout the automation lifecycle. This includes As-Is process discovery, process capture and mapping, data analysis, requirements elicitation and documentation, project administration, and workshop support. **Roles and Responsibilities** Provides support in the...

  • Senior Data Analyst

    4 weeks ago

    Cape Town, South Africa Progressive Edge Full time

    Senior Data Analyst (Digital Commerce) Cape Town Join a Digital Commerce team as a Senior Data Analyst and be part of a team that uses data to create a strategic advantage and leverage growth of their capabilities. Data, for this team, is at the core of enabling world-class shopping across digital channels. The Business has been set up to work in an Agile...

  • Senior Data Analyst Leader

    5 days ago

    Cape Town, Western Cape, South Africa Skatelescope Full time

    We are seeking an exceptional Senior Data Analyst to join our team at Skatelescope. This individual will be responsible for developing operator procedures and documentation as well as mentoring and training data analyst/operators under their supervision.In this role, you will play a crucial part in managing the performance of the data analyst/operator team,...

  • Senior Data Analyst Ii

    4 weeks ago

    Cape Town, South Africa Impact.com Full time

    **Our Company**: If you are looking to join a team where your opinion is valued, your contributions are noticed, and enjoy working with fun and talented people from all over the world then this is the place for you. If you have a desire to work in an organisation that is: - Passionate about its people - Focused on delivering the very best tech to our...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa Ecosave Full time

    **About Us** We are a trusted energy consultancy based in the UK, specialising in helping businesses reduce costs, improve energy efficiency, and achieve their sustainability goals. Our success is built on delivering accurate insights and reliable data to support informed decision-making for our clients. **Role Overview** We are looking for a highly...

  • Automation Developer

    6 hours ago

    Cape Town, Western Cape, South Africa NTT Data Full time

    **Job Overview**We are seeking a skilled and experienced .Net Developer to join our team at NTT Data. In this role, you will be responsible for designing and developing Process Automation systems, working closely with our development team to create innovative solutions.**Key Responsibilities**Design and Develop Process Automation SystemsCollaborate with the...

  • Senior Data Analyst

    3 days ago

    Cape Town, Western Cape, South Africa CTU Career Chatz Full time

    We are seeking a highly skilled Senior Data Analyst to join our team at CTU Career Chatz. The ideal candidate will possess an accounting background and expertise in financial reporting, data analysis, and software implementation.This role offers the opportunity to work with cutting-edge financial data modeling tools, streamline tax processes, and enhance...

  • Senior Data Analyst Specialist

    5 days ago

    Cape Town, Western Cape, South Africa Intellistaff Full time

    Intellistaff is seeking a highly skilled Senior Data Analyst Specialist to bridge the gap between business needs and technical solutions within data warehousing.Duties & ResponsibilitiesUnderstand business requirements, analyse data sources and collaborate with stakeholders to ensure effective design, development and maintenance of data warehouses.Act as a...

  • Data Analyst

    3 weeks ago

    Cape Town, South Africa 1-grid Full time

    **About us**: 1-grid is a leading web hosting company with a well-established customer base that is passionate about delivering top-quality hosting solutions to SMEs in South Africa. We're on a mission to grow businesses online with simple and reliable products, and we're looking for a mid-level **Data Analyst** to join our creative team and help us bring...

  • Senior Data Analyst – Financial Planning and Analysis

    1 week ago

    City of Cape Town Metropolitan Municipality, South Africa Robert Walters Full time

    Job title : Senior Data Analyst – Financial Planning and AnalysisJob Location : Western Cape, Cape TownDeadline : March 10, 2025Quick Recommended Links Jobs by Location Job by industries This role offers an exciting opportunity for someone with strong analytical skills, a passion for data, and an interest in financial planning. The successful candidate...

  • Process Automation Analyst

    3 weeks ago

    Stellenbosch, Western Cape, South Africa Heineken International B.V. Full time

    We Go Places! How about you? Immediate Superior: Robotics & Automation Lead Location: Stellenbosch Function: Digital & Technology Sub Function: Digital & Technology - Operations Type of Contract: Permanent Reference Number: 119350 Closing Date: 10/09/2024 The Robotic Process Automation Analyst/Developer functions on an automation team and will leverage...

  • Process Automation Engineer

    3 days ago

    Cape Town, Western Cape, South Africa NTT Data Full time

    About the RoleWe are looking for a talented Process Automation Engineer to join our team at NTT Data. As a key member of our development team, you will be responsible for designing and developing Process Automation systems.Your primary focus will be on designing, building, and testing components that interact with multiple third-party applications. You will...

  • Automation Solutions Specialist

    3 days ago

    Cape Town, Western Cape, South Africa NTT Data Full time

    About the RoleWe are looking for a talented Automation Solutions Specialist to join our team at NTT Data. As a key member of our development team, you will be responsible for designing and developing Process Automation systems.Your primary focus will be on designing, building, and testing components that interact with multiple third-party applications. You...

  • Senior Data Analyst

    2 weeks ago

    Cape Town, South Africa MCI Careers Full time

    POSITION OVERVIEW: MCI is a leading Business Process Outsourcing (BPO) company that specializes in delivering tailored solutions to meet the diverse needs of our clients. With a commitment to excellence and a focus on innovation, we have established ourselves as a trusted partner in the industry.POSITION RESPONSIBILITIES: **Key Responsibilities**: - **...

  • Senior Data Analyst

    3 weeks ago

    Cape Town, South Africa Rentoza Full time

    Welcome to Rentoza! We're a South African company that's changing the game in e-commerce. Our subscription service for digital goods and appliances is making access, affordability, and flexibility a reality for our customers. **The Role** We are seeking a highly skilled and experienced Senior Data Analyst to join our growing team. As a Senior Data Analyst,...

  • Process Automation Expert

    6 hours ago

    Cape Town, Western Cape, South Africa NTT Data Full time

    **About the Company**NTT Data is a leading IT services company that provides innovative solutions to our clients. We are committed to delivering high-quality services and products that meet the needs of our clients.**Job Description**Design and Develop Process Automation SystemsCollaborate with the Development TeamMaintain Coding Standards and Code...

  • Junior Data Analyst

    3 weeks ago

    Cape Town, South Africa Kudough Credit Solutions Full time

    **Qualifications** **Education and Experience**: - Data analyst experience 6 - 12 months OR relevant bachelor's degree **Full Job Description** **Key responsibilities**: - Help drive efforts for continuous data accuracy and quality improvement - Maintain and develop automated reports and their associated mailing lists, as well as dashboards - Develop...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa Fouche & Co Recruitment Full time

    We are looking for a Data Analyst with an Accounting Background to enhance financial reporting, streamline tax processes, and implement cutting-edge software solutions. This role offers exposure to financial data modeling, compliance, and process automation, making it ideal for someone who thrives at the intersection of finance and technology.Key...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa Fouche & Co Recruitment Full time

    We are looking for a Data Analyst with an Accounting Background to enhance financial reporting, streamline tax processes, and implement cutting-edge software solutions. This role offers exposure to financial data modeling, compliance, and process automation, making it ideal for someone who thrives at the intersection of finance and technology.Key...

  • Data Analyst

    1 day ago

    Cape Town, South Africa Fouche & Co Recruitment Full time

    We are looking for a Data Analyst with an Accounting Background to enhance financial reporting, streamline tax processes, and implement cutting-edge software solutions. This role offers exposure to financial data modeling, compliance, and process automation, making it ideal for someone who thrives at the intersection of finance and technology.Key...