Data Analyst
At a glance
Mid-level Data Analysis & BI role at exaze. Rivonia · full-time.
Pay not stated Data Analyst salary
dataroles summary, based on the employer's posting.
What you'll do
- Review Oracle warehouse queries and complex datasets to identify insights for BI solutions
- Trace source data to target fields and prepare migration specifications for the project team
- Record metadata and business meanings for report measures with business stakeholders
- Keep documentation of data workflows, dictionaries and analysis reports current
- Work with other teams to support data-led strategies and put them into practice
What you bring
- You have a senior Oracle background with data warehousing experience
- You have worked on data analysis and source-to-target mapping
- You can work with Oracle PLSQL and Excel
- You understand database platforms and data warehousing principles
Who this fits
This role suits an experienced Oracle data professional who can explain complex analysis to non-technical stakeholders. You'll work independently and manage several project tasks at once.
From the employer
Job Purpose:
The Data Analyst is responsible for analysing and interpreting large sets of data from various sources for extracting insights and document source to target mappings for BI Solutions.
The successful candidate will work closely with cross-functional teams to document PLSQL queries from schemas, facts and dimensional data structures for a BI Portal Migration project.
Key Responsibilities:
Collect, analyse, and interpret complex data sets by examining PLSQL queries from an Oracle Data warehouse
Document source to target mappings and create specifications for migration team
Collaborate with cross-functional teams to support the development and implementation of data-driven strategies
Collaborate with business stakeholders to document meta data and business definitions for report metrics
Create and maintain documentation of data processes, data dictionaries, and data analysis reports
Requirements:
Senior Oracle professional with Data warehouse background
Proven experience in data analysis and source to target mappings
Excellent analytical and problem-solving skills, with the ability to work with large and complex data sets.
Strong communication and interpersonal skills, with the ability to present complex data and analysis to non-technical stakeholders.
Proficiency in Oracle PLSQL, Excel.
Experience with data visualization tools such as PowerBI is a plus.
Knowledge of database management systems and data warehousing concepts.
Ability to work independently and manage multiple projects tasks simultaneously.