Senior Data Systems Analyst

4 weeks ago

Cape Town, South Africa InfoBluePrint Services (Pty) Ltd Full time

**Job Summary**

In this role, you will use your extensive knowledge of SQL, ETL and ELT processes to understand the flows of data that occur from the various systems utilised by the business to downstream BI environments and reports. You will have to be able to produce meaningful and comprehensible data flow metadata from the various sources and assist the Data Modellers in mapping the source flows to the Entities and Attributes produced in the Physical Data Models. The Senior Data Analyst will have to work with multiple systems and databases; and will also have to be able to perform data profiling, where necessary, to assist Data Modellers in gaining a complete understanding of the content and quality of the identified data sources.

**Responsibilities**
- Obtains the access required to extract metadata from existing databases and transformation processes.
- Attends daily stand-up meetings
- Attends trainings, if required (e.g., on Data Lineage Extraction tool), related to the responsibilities of the position.
- Analyses identified reports to extract various report elements and to map these to data elements identified in the physical data models.
- Analyses existing databases and transformation code to extract and document data lineage between all identified systems.
- Creates comprehensible and usable documentation and uses techniques and tools such as diagrams and matrices to convey information to project stakeholders.
- Distils the high-level business data flows from the documented technical data flows and produces documentation of these flows that are understandable to non-technical stakeholders.
- Assesses data quality in identified data sources.

**Education and Experience**
- Bachelor’s degree in Information Technology / Computer Science, or sufficient work experience in the field to obviate the need for a formal degree.
- 5+ years of relevant experience, with previous professional experience as a Data Analyst.
- Expert SQL skills, with data modelling and development experience a plus.
- Demonstrated analytical, problem-solving, organisational and interpersonal skills.
- Excellent communication skills, with the ability to explain key concepts in meetings and in writing to teammates from different functions and experience levels.
- Exceptional attention to detail, and the required tenacity to work through all documentation currently in existence, and where such documentation does not exist, to work through stored procedures and other code artefacts to gain a complete understanding of the as-is lineage and data.

**Knowledge, Skills and Abilities**
- Excellent verbal and written skills.
- Strong analytical skills.
- Capacity to work with large amounts of data, extract relevant information and draw logical conclusions.
- Ability to pay attention to detail when working with data in order to make accurate conclusions.
- Strong understanding of ETL and ELT processes.
- Knowledge of SQL.
- Working knowledge of data analysis techniques, data modelling, querying, and workflows.
- Solid understanding of data sources, data organisation and storage.
- Demonstrated ability to work independently, within a team, and remotely.
- Creatively and professionally solve problems and evaluate initiatives.
- Able to take direction and respond effectively to constructive feedback.

  • System Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a System Analyst, you'll be responsible for maintaining and managing the company's IT infrastructure. You will be responsible for identifying issues and recommending solutions to maintain the network, database systems, servers and workstations in good working order. You will also have to manage the installation of new hardware as well as software...

  • Systems Analyst

    1 month ago

    Cape Town, 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...

  • Senior Systems Analyst

    4 weeks ago

    Cape Town, South Africa Salt Full time

    Exciting new opportunity available for a Senior Systems Analyst, this a Hybrid position which allows you to work from either my clients Cape Town or Durban office. **About The Role**: The Senior Systems Analyst works with current systems, designs new systems, and enhances the legacy environment. You will need to be proactive, should be able to communicate...

  • Senior Systems Analyst

    4 weeks ago

    Cape Town, South Africa Salt Recruitment Full time

    Exciting new opportunity available for a Senior Systems Analyst, this a Hybrid position which allows you to work from either my clients Cape Town or Durban office. **About The Role**: The Senior Systems Analyst works with current systems, designs new systems, and enhances the legacy environment. You will need to be proactive, should be able to communicate...

  • Senior Business Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Senior Business Analyst, you'll be responsible for analyzing and testing new software applications. You'll be tasked with ensuring that the application is working as intended before it goes live to customers. You will work closely with other development teams and the business analysts in order to ensure that all aspects of our product are functioning...

  • Senior Security Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    FunctieomschrijvingAre you fed up of working in the same job for years? Do you want to take that next step and become a Senior Security Analyst? This role is perfect for you if the following describes your experience:The Senior Security Analyst will be responsible for the analysis of network infrastructure, security and compliance issues. This includes...

  • Senior Data Analyst

    1 month ago

    Cape Town, South Africa Clicks Group Limited Full time

    **Listing reference**: click_015158**Listing status**: Online- **Position summary** **Industry**:Wholesale & Retail Trade - **Job category**:Internal Auditing**Location**:Cape Town - **Contract**:Permanent**EE position**:Yes**Introduction** - We are looking to recruit a Senior Data Analyst to work within our Internal Audit department. The role will be based...

  • Senior Data Analyst

    1 month ago

    Cape Town, South Africa Datonomy Solutions Full time

    We are looking for a Senior Data Analyst to join our team in Cape Town.3 days (Tuesday, Wednesday & Thursday) onsite in Southern Suburbs.Retail experienceAnalytical degree (maths, stats, engineering)Advanced SQLPower BiStrong interpersonal skills, as you will be working directly with stakeholders.

  • Senior Data Analyst

    3 weeks ago

    Cape Town, South Africa Datonomy Solutions Full time

    We are looking for a Senior Data Analyst to join our team in Cape Town . 3 days (Tuesday, Wednesday & Thursday) onsite in Southern Suburbs. Retail experience Analytical degree (maths, stats, engineering) Advanced SQL Power Bi Strong interpersonal skills, as you will be working directly with stakeholders.

  • Senior Systems Analysts

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    FunctieomschrijvingBusiness and technical requirements gathering and analysis thereof, and ensuring requirements and expectations are met, and that all possible scenarios are covered.Formulation of analysis documentation, Functional Specifications, Interface Specifications, and prototypes in accordance with industry standards and team best practices.Perform...

  • Data Analyst

    1 month ago

    Cape Town, South Africa RPO Recruitment Full time

    Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements. **Responsibilities**: - Develop and implement databases, data collection systems, data...

  • Senior Systems Analyst

    1 month ago

    Cape Town, South Africa Six Sense Full time

    Western Cape, Cape Town A well-established business is seeking a Senior Systems Analyst. **Qualification**: - B.Eng/B.Sc (Eng) with 9 years - M.Eng with 7+ years - PhD/D.Eng with 5 years **Experience**: - Recognized expertise in radio astronomy and/or radar signal processing anc analysis domain - Radio astronomy principles and instrumentation - Analyzing...

  • Systems Analyst

    1 month ago

    Cape Town, South Africa PBT Group Full time

    About PBT Group:PBT Group is a leading data specialist company that excels in delivering a range of data-centric solutions to clients across various industries. We are seeking a talented and experienced Systems Analyst to join our team in Cape Town, where you will play a crucial role in defining and enabling business change. This is an exciting opportunity...

  • Systems Analyst

    4 weeks ago

    Cape Town, South Africa Datonomy Solutions Full time

    Systems Analyst Systems Analyst that has come through the ranks of Business Analyst and help us look at everything realistically, and they're able to link the processes to the system, how everything is stitched together. Strong Systems Analysts have versatile skills that can be applied in many places in the program. Output/Core Tasks: - Understanding of...

  • Business Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Business Analyst, you will be working on a project that involves business process analysis and requirements gathering. You'll use the relevant software tools to gather information for your team to work from. You may also be required to help test new functionality or build prototypes of new features using web applications. Requirements ...

  • Junior Data Analyst

    4 days ago

    Cape Town, South Africa Tigonthrive Consulting Full time

    Tigonthrive Consulting is seeking a motivated and detail-oriented Junior Data Analyst to join our team. The Junior Data Analyst will assist in collecting, processing, and analyzing data to support our HR consulting services. This is a remote position with the potential for occasional travel for team meetings and client interactions. **Key...

  • Mobile Test Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Mobile Test Analyst, you'll help the development team ensure that our applications are functioning correctly on all devices and operating systems. You'll test apps on multiple mobile platforms including iPhone/iPad, Android and BlackBerry. You will also be required to follow up with developers for specific issues that may arise in their work flow or...

  • Data Analyst

    1 month ago

    Cape Town, South Africa Olive Branch Recruitment Full time

    Looking for a Data Analyst to join a growing Tech organization. This position is Hybrid and based in Cape Town. Should you meet the requirements and are passionate about making a difference in the lives of others, please be sure to apply. **Requirements**: Tech/B.Sc. Engineering, Maths; Stats; Actuarial Science 1 to 3 years of work experience Must have...

  • Intermediate Odoo System Analyst

    3 weeks ago

    Cape Town, South Africa Wenz Recruitment Full time

    Job Overview:The Intermediate Odoo System Analyst is a crucial role designed to ensure the smooth running of our Odoo ERP and connected systems. The position serves as a bridge between the user community and senior system analyst, providing hands-on support, facilitating solutions, and improving operational efficiency.Key Responsibilities:1. Operational...

  • Mi/data Analyst

    1 month ago

    Cape Town, South Africa TTEC Full time

    MI/Data Analyst Reporting Analyst **Responsibilities**: The Reporting Analyst is fully dedicated to and receives work from the Retail Contact Center Business Intelligence (RCC BI) team. The role solves complex business problems and issues using data from internal and external sources to provide insight to decision-makers. The Reporting Analyst work...