Business Intelligence/Data Analyst

City of Cape Town, Western Cape 7 February

Talent ID

  • Description

    Join this top investment company as a Business Intelligence/Data Analyst in the Information Technology Services Dept.
    Role summary:
    • Stays informed of the ways the organization uses its data.
    • Develops data models to meet the needs of the organization's information systems and maintains the integrity of the data.
    • Includes reviewing and ensuring that data loaded into the data warehouse is accurate.
    • You will participate in the troubleshooting and tweaking of current data warehouse applications to spot and correct errors.
    • Manages the flow of information between departments through the use of relational databases and ensures that reporting solutions are functioning properly.
    • Assisting in developing, maintaining, and supporting the enterprise’s data warehouse system, as well as related data marts.
    • Other tasks include testing, documentation and dimensional modelling.
    • Must possess a minimum of Computer Science, Information systems/Technology, Engineering first degree or a degree from other related fields.
    • Possess not less than 5 years’ work experience supporting and developing data warehouses
    • Experience creating metadata, developing ETL processes, and using several reporting tools; and performing data cleansing functions
    • 5 or more years’ experience working with OLAP tools.
    • Strong knowledge of the fundamentals of data warehouse, and experience supporting and developing data warehouses
    • Business analysis and or related technical experience in Business Intelligence, analytics or reporting is desirable.
    • Proficient working independently and in a team setting
    • Possess excellent skill in communicating in writing and speaking with clients, senior managers, and staff.
    • Knowledge of the industry and multiple business functional areas.
    • Preference will be given to appropriately qualified, previously disadvantaged candidates in order to achieve the numerical goals and targets to address client’s employment equity plan
    • Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments
    • Designs dimensional models with conformed dimensions, following the business’ processes
    • Develops and automates ETL processes that involves error and reconciliation handling.
    • Designs, builds and maintains the reporting environment
    • Writes reports, adds new fields, creates filters, measures and objects; and creates dashboards to improve current data warehouse
    • Creates processes for maintaining or/and capturing metadata
    • Studies and understands the company’s business processes and applications, including their effect on data and reporting, and applies the knowledge gained in designing data warehouses and reports
    • Identifies and documents all requirements for both fresh and current data warehouse components and reports by working with end users
    • Creates reports and assists clients with data warehouse
    • Performs capacity planning, supporting, troubleshooting, and ETL performance modification
    • Assembles performance statistics, analyses them, and makes recommendations for improvements
    • Establishes system documentation and ensures it is continually sustained.
    Work Planning
    • Participates in work stream planning process including inception, technical design, development, testing and delivery of BI and reporting solutions.
    • Develops work plans or reviews other work plan timelines and manages workflows to meet timeframes.
    • Participates in project management estimation process.
    • Manages and plans for service demand forecasts.
    • Conducts analyses of functional business processes and functional requirements and participates in the development of business cases in the support of process changes and/or IT projects.
    Business Requirements and Analysis
    • Evaluates internal and external requirement in order to provide appropriate solutions.
    • Provides input to business requirements for the design of solutions.
    • Identifies and provides input to new technology opportunities that will have an impact on the enterprise wide BI systems.
    • Advises on how BI (processes, practices and technologies) play a critical role in improving business management and optimization.
    • Explores the data and discovers patterns, meaningful relationships, anomalies and trends.
    • Designs organization-wide “views” and custom reports.
    • May perform analysis for a wide range of requests using data in different formats and from various platforms.
    • Researches business problems and creates models that help analyse these business problems.
    • Develops best practices for report deployments.
    • Leads or provides direction for the planning, designing, and execution of user testing efforts.
    • Oversees the implementation (i.e., testing, issues resolution) of new systems or modifications.
    • Analyses testing results to ensure the solution meets the needs of the business. • Provides support to test teams.
    Information Quality Assurance
    Recommends quality metrics and ensures quality metrics are documented and tracked. Creates data quality standards, as needed.
    • Good problem solving and analytical skills
    • Well-developed communication skills
    • Ability to work under pressure with limited supervision
    • Ability to maintain service standards
    • Ability to work accurately and in detail
    • Ability to work in a team environment
    • Action orientated
    • Planning and organising
    • Ability to liaise with all levels of mana
    If you are an SA citizen and meet the job requirements, please email your CV to *********************
    If you don’t hear from us within 2 weeks, please consider your application unsuccessful.

  • Requirements

  • Minumun level of education: Diploma /Bachelor's/ N6
  • Years of experience: 5
  • Language(s): English
  • Availability for travel: No
  • Availability for change of residence: No

Similar ads

Full Time - Permanent contract - Negotiable

9 March

Full Time - Permanent contract - R 20.000,00 monthly

6 March

- Permanent contract - Negotiable

6 March

Ad summary

  • Business Intelligence/Data Analyst

  • Recruiter

    Talent ID

  • Province

    City of Cape Town, Western Cape

  • Work type

    Full Time

  • Type of contract

    Permanent contract

  • Salary


  • Apply now

Related search