Job Openings Senior Data Analyst II

About the job Senior Data Analyst II

EMPLOYMENT TYPE:

Permanent (Hybrid working model)

COMPANY:

A large financial services company

LOCATION:

Cape Town

JOB OVERVIEW:

We are looking for an individual with experience in using a variety of data tools and analysis methods to create information assets to be consumed by descriptive and advanced analysts.If you believe you have what it takes, then come join the team and assist us to mature our data analytics capability as you grow your skills and competencies in this exciting field.

You will be responsible for the end-to-end tasks within the data analysis framework working with business representatives, product owners, etc. to define and elicit requirements, analyze data and assist developers in creating information.

DESCRIPTION OF POSITION:

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 Visualization

  • Interpret data, analyze results using analytical techniques and provide reports and/or dashboards
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Use data to answer key questions about the business.
  • Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalized, relational, dimensional, application level, subject-level, integrated, etc.)
  • 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 visualization techniques
  • Facilitate requirements gathering workshops with the business
  • Collaborate with internal and external stakeholders to analyze information needs, functional requirements and business processes

KNOWLEDGE AND SKILLS:

  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Strong knowledge of and experience with reporting packages (Business Objects), databases (SAP HANA, Cloudera), querying (SQL)
  • Manage raw vault design practices and ensure consistency and standardization of Hubs and Satellites within Raw Vault Layer
  • Oversee Analyst 'Chapter' to monitor DV and Kimball maturity across Hubs
  • Refine RV design and build processes, focusing on review process, governance gates and test automation 

QUALIFICATIONS REQUIRED:

Bachelors degree (statistics/data or computer science/engineering) or equivalent

EXPERIENCE REQUIRED:

  • Practical experience in analytics, data modelling and data profiling
  • 7+ years of experience performing data analytics
  • Experience with reporting packages (Business Objects), databases (SAP HANA, Cloudera), querying (SQL)
  • Experience working with data in various data sources and databases
  • Experience working in an agile environment

ADVANTAGEOUS SKILLS:

  • Business experience in financial services

**Please note : If you have not heard from us within 2 weeks, please consider your application unsuccessful.