Senior Data Systems Analyst

2 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

    4 weeks 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

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

  • Senior Systems Analyst

    3 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 Systems Analyst

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

  • Systems Analyst

    4 weeks 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 Business Analyst

    4 weeks 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

    4 weeks 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...

  • System Analyst

    4 weeks 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 upgrades...

  • Senior Data Analyst

    4 weeks ago

    Cape Town, South Africa e-Merge IT Recruitment Full time

    A leader in the healthcare market committed to increasing access to affordable primary healthcare for all South Africans through its retail pharmacy and pharmaceutical wholesale businesses are looking to recruit a **Senior Data Analyst** to work within their Internal Audit department supporting the department goals to increase efficient and effective use of...

  • Senior Data Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa Progressive Edge Full time

    Senior Data Analyst (Digital Commerce)Cape TownJoin 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 way,...

  • Senior Systems Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa H & S Labour Brokers Full time

    _Senior Systems Analyst_PermanentSkilled / Middle ManagementCape TownSalary NegotiableThe main purpose of the job is to perform signal-level modelling, design and testing of systems and algorithms that comprise the signal path in radio telescopes. This covers analysing how each subsystem / algorithm along the signal path, from antenna to data product,...

  • Senior Data Analyst

    2 weeks ago

    Cape Town, Western Cape, 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 Specialist Analyst Developer

    4 weeks ago

    Cape Town, South Africa Dimension Data Full time

    FunctieomschrijvingAre you looking for a challenging role that will take you to the top of your field? Are you sick of being micro managed? We believe this Senior Specialist Analyst Developer was created for you! Please read through and apply.As a Senior Specialist Analyst Developer, you'll be responsible for implementing solutions using Microsoft...

  • Senior Business Analyst

    2 weeks ago

    Cape Town, Western Cape, 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 Systems Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa Six Sense Full time

    Western Cape, Cape Town Annually Cost To Company (Market related)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+ yearsExperience: Recognized expertise in radio astronomy and/or radar signal processing and analysis domain. Radio astronomy principles and...

  • Senior Systems Analyst

    2 weeks ago

    Cape Town, South Africa Phanda Personnel CC Full time

    **Purpose of the job**: The main purpose of the job is to perform signal-level modelling, design and testing of systems and algorithms that comprise the signal path in radio telescopes. This covers analysing how each subsystem / algorithm along the signal path, from antenna to data product, modifies the signal and its quality, including analysing external...

  • Senior Data Analyst

    4 weeks ago

    Cape Town, South Africa Clicks Group Limited Full time

    **Listing reference**: 016992**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 at...

  • Senior Data Analyst

    3 weeks 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

    7 days ago

    Cape Town, South Africa Clicks Group Limited Full time

    **Listing reference**: 016439**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 at...

  • Senior Data Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa e-Merge IT Recruitment Full time

    A leader in the healthcare market committed to increasing access to affordable primary healthcare for all South Africans through its retail pharmacy and pharmaceutical wholesale businesses are looking to recruit a Senior Data Analyst to work within their Internal Audit department supporting the department goals to increase efficient and effective use of data...