Data Analyst
H2R Africa
Pretoria, South Africa
1d ago
source : Executive Placements

Engage with business stakeholders to elicit requirements

Define functional and information requirements for data warehouse and BI solution

Define business rules, calculation and logic required in the developed data warehouse

Conduct document analysis, Original Report Analysis of the excel macros and calculations to deliver the report, as well as interpretation of existing data files

Analyse data contained in various reports or data files determine the information requirements

Analysis of original Report Data Lineage

Populate the Business Glossary, Data Catalogue and Data Dictionary for the reports

Revised Data Lineage to ensure the correct use of authoritative master data and representative transaction information

Define Business Rules & Calculations, Business Information Aggregation and Business Report Structures

Technical Specification :

Data Landing definition of the trusted source data required to produce curated data Document source to target maps for BI reports (understand as-is STTM as input to build to-be STTM)

Create Physical Data Model of the Data Mart

Document Data Quality checks and rules required to ensure trustworthy data

Interpret and translate code within Excel (VBA / Macros) to serve as input for functional requirements.

Bachelors degree in Computer Science, Management Information Systems, Computer Engineering or an equivalent qualification

8 to 10 years experience in Data Warehousing, Extract, Transform and Load (ETL) development, Business Intelligence and dashboard designs

SQL Server / Oracle (T-SQLor PL / SQL) programming skills including SQL objects development, performance tuning, data analysis and integration


Report this job

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

My Email
By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Application form