Lead Data Analyst

2 weeks ago


Cape Town, Western Cape, South Africa Project Management Connection Full time

Overall purpose of the role:

  • Guided by the Scrum Master and Technical Lead, this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights.
  • Our client is looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into actionable insights with demonstrable business impact.
  • They will assist in specifying complex business rules using the specified toolsets to enable the data modelers to create complex analytical models. Hence, they need to understand and continuously seek to build knowledge of data and information.
  • The person fulfilling this role will not only analyse data models, but also test the outputs, investigate & troubleshoot data issues and devise solutions in line with best practice. A high competency in problem solving capabilities is thus essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to the team.
  • An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance.
  • You will be responsible for the endtoend tasks within the data analysis framework working with business representatives, product owners, etc. to define and elicit requirements, analyse data and create reports/dashboards.

Main responsibilities

Data Preparation

  • Acquire data from various data sources and combine & transform data into interpretable datasets, reports or dashboards
  • Assess the effectiveness and accuracy of new data sources and data gathering techniques
  • Extend the company's data with third party sources of information when required
  • Process, cleanse and verify the integrity of data used for analysis
  • Perform data profiling of data contained in source systems
  • Provide detailed analysis of all data implemented into the database
  • Provide the data mapping and associated transformation rules for each data item
  • Ensure that the business requirements and subsequent development activities are supported by accurate information.

Analysis and Visualisation

  • Interpret data, analyse results using analytical techniques and provide reports and/or dashboards
  • Identify, analyse, and interpret trends or patterns in complex data sets
  • Use data to answer key questions about the business.
  • Own and maintain dashboards, ongoing reporting, and ad hoc requests from the organization.
  • Assist Data Modelers to draw up detailed data models.

Stakeholder Engagement

  • Work directly with management and other business users to gather requirements, provide status updates, and build relationships
  • Present information using data visualisation techniques
  • Facilitate of requirements gathering workshops with the business
  • Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes

Coaching/Mentorship

  • Provides problem solving assistance to other team members
  • Coach and assist junior team members

Qualification and experience

  • Diploma/Bachelor Degree (Information Systems; Statistics; Data or Computer Science; Engineering) or equivalent (preferred but not essential)
  • Functional experience in analytics, data visualisation or reporting
  • 25 years of experience performing data analysis in a BI environment
  • Knowledge of and experience with reporting packages
  • Adept at queries, report writing and presenting findings for stakeholder use
  • Experience working with data in various data sources and databases
  • Ability to translate business requirements into nontechnical terms
  • Demonstrated experience in handling large data sets and relational databases with proven SQL skills
  • Ability to comply to and manage data assets under strict governance framework
  • Experience in agile development desired
  • Business experience in financial services would be advantageous
  • Ability to work with data profiling, data quality and reference data toolsets advantageous
  • DataStage and or other ETL / DI tools
  • DB2 and or other RDBS's
  • SQL
  • SAP Hana (DB)
  • SAP Data Services
  • Cloudera / Hadoop
  • Cloud deployments and integration (esp AWS)
  • Some knowledge of Teradata, Attunity, Cloudera, advanced visualisation technologies and data management experience is preferred and highly advantageous
  • Database viewing tools
  • Scripting languages, esp Python, Java, Sparc
  • Report generation tools

Knowledge of BI processes and methodologies such as (but not limited to):

  • Agile development
  • Data integration
  • Data modelling/Application modelling (Modelling in SAP HANA is preferred)
  • Data analysis, visualization and reporting
  • Ingestion
  • SDLC, release management and project management
  • API integration

Core competencies (Stage 2:
contributing independently)

**Living up to our Gro
  • Lead Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa BigTalent Full time

    A dynamic financial services concern based in Cape Town is seeking an experienced Analytics Lead to drive innovation and insights within the Analytics division.As the Analytics Lead, you will have the opportunity to work with fantastic, large, and rich datasets from various sources. Your primary responsibility will be to analyze the data, uncover trends and...

  • Lead Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa PBT Group Full time

    PBT Group has an opportunity for a Lead Data Analyst for a role in Cape Town.Guided by the Scrum Master and Technical Lead, this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights.We are looking for an individual with...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Games Global Full time

    We are seeking a skilled Analyst with experience in experimentation to join our team.As a Data Analyst you will support the full cycle of an experiment (from data-driven hypothesis generation to test design to analysis and interpretation) while also innovating on experimental methodologies that will obtain meaningful results.Responsibilities Create...

  • Report Analyst

    2 weeks ago


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

    FunctieomschrijvingAre you looking to make a career breakthrough? Are you tired of being stuck in a job that doesn't pay well and where your work is not valued? We believe this Report Analyst was created for you Please read through and apply nowThe Analyst role is responsible for creating reports that can be used to analyse and summarise the information...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa BVNK Full time

    About us:BVNK is a next-generation payments platform. We're on a mission to make payments as accessible as the internet.We bridge traditional and digital finance to make payments borderless, fast, and secure. Using our platform, businesses can incorporate stablecoins into their payment flows, and send and receive payments anywhere in the world.We are a...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Clockwork Media Full time

    If your numerical abilities are off the charts (see what we did there?), or you were a proud mathlete at school, we want you But mostly your brain. Clockwork is looking for a Data Analyst to join our dynamic team.Our new Data Analyst will develop analysis and reporting capabilities for all clients across all digital touchpoints - from web and SEO to paid...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Shoprite Full time

    ShopriteX has been established within Shoprite Group to accelerate the use of data in improving customer experience and business operations. ShopriteX has been set up to work in an agile way, with centres of excellence as well as product focused teams. We have a few roles for Data Scientist and Data Analysts within each product team as well as within the...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Fetola Full time

    Data Analyst (consultant/service provider):Type of contract: service provider to consult on an ad-hoc basis.Rate:hourly rate will be discussedClosing date:07 July 2023- "Our purpose is simple: we help people to grow the economy and create jobs by building businesses that last"._We pride ourselves on innovation, efficiency, and data-driven decision-making. As...

  • Data Analyst

    6 days ago


    Cape Town, Western Cape, South Africa ExclusivelyRemote Full time

    Data Analyst (Excel and Power BI)Position: Data AnalystHours: 15-25 hours per week (US hours, flexible)Employment Type: Project-based, ongoingWe are seeking a skilled Data Analyst with strong expertise in Excel and Power BI. This role is ideal for someone looking to work part-time, with flexibility around US hours.Key Responsibilities:Analyze complex data...


  • Cape Town, Western Cape, South Africa Ca Financial Appointments Full time

    Senior Stockbroking Operations profile sought to join a successful team. Great opportunity to work closely with the Chief Operating Officer of this team in an exciting phase. Ideal candidate is someone with a data analyst or business analyst background withinstockbroking or investments and is passionate about automation, data analytics and...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Initiate international Full time

    Join a team of data experts and help drive success for an international iGaming company. This team are looking for a talented and motivated Data Analyst (iGaming) to join their team in Cape Town. If you are passionate about data and have iGaming experience, this job could be perfect for youYour key job responsibilities as the Data Analyst (iGaming) in Cape...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Initiate international Full time

    Join a team of data experts and help drive success for an international iGaming company. This team are looking for a talented and motivated Data Analyst (iGaming) to join their team in Cape Town. If you are passionate about data and have iGaming experience, this job could be perfect for youYour key job responsibilities as the Data Analyst (iGaming) in Cape...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Amaris Consulting Full time

    Job description Amaris Consulting is looking to recruit a Data Analyst to expand its teams in South Africa. Principal Missions: Utilize data analysis tools to support data-driven decision-making. Develop and maintain data visualizations and reports for actionable insights. Optimize query performance and data models for efficient data processing. ...

  • Business Analyst

    2 weeks ago


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

    FunctieomschrijvingPlan and lead requirements elicitation, elaboration and clarification workshops with customer teams, translate business requirements into functional requirements,Advise customers on B2C and B2B commerce best practices and optimal business processes, managing requirements prioritisation and assisting the architect and lead developer by...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Teleroi Full time

    We are excited to announce a new job vacancy for the position of Data Analyst at Teleroi. As a data analyst, you will be responsible for collecting, processing, and performing statistical analyses on large datasets. The role involves interpreting data, identifying trends, and presenting insights to stakeholders to help inform business decisions.Key...

  • Lead Research Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Refinitiv Full time

    Lead Research Analyst (Portuguese language) page is loaded Lead Research Analyst (Portuguese language) Apply locations ZAF-Cape Town-1st Floor, The Apex POL-Gdynia-Baltic Business Ctr time type Full time posted on Posted 21 Days Ago job requisition id R YOU AND YOUR TEAM The job of a Research Analyst in World-Check is one where we appreciate language skills,...

  • Systems Analyst

    2 weeks ago


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

    The Systems Analyst will be responsible for implementing and maintaining a number of technology systems including but not limited to: - Azure, AWS (AWS Database, Redshift, ElasticSearch) - Oracle Databases and SQL databases - SAP applications in Finance/HR/CRM and Marketing. You'll also be responsible for data migration from various legacy systems into...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa PBT Group Full time

    I'm currently recruiting for a Senior_ Data Analyst _or Technical Business Analyst who possesses strong analysis skills, data ETL expertise, and is independent and quick to start up. TAbout the role: Responsible for mapping all legacy platform subprograms and related datasets required. Review existing tables and identify redundancies, as well as account for...

  • Risk Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Shoprite Full time

    Purpose of the Job The Risk Data Analyst I is an entry-level position within the Enterprise Risk Management (ERM) department. This role involves supporting the collection, analysis, and reporting of risk-related data. The analyst will assist in maintaining data accuracy and integrity, performing routine data processing tasks, and supporting senior...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa IQbusiness South Africa Full time

    "Can you transform complex financial data into actionable recommendations as a Data Analyst?"About you and the key skills we're looking for:As a Data Analyst role in banking and finance, your background encompasses a degree in Statistics, Mathematics, Finance, Economics, or Computer Science. Your proven record as a Data Analyst within finance highlights your...