Description
Within the Business Intelligence Department, the BI solution analyst and developer will be in charge of transforming business requirements into BI solutions. Developing technical specifications and completing build activities on Oracle Back End using PL/SQL.
Run - BI support and services
Understand possible discrepancies highlighted by the business and explain it when it's possible
Analyse the assigned incidents
Propose corrections
Develop patch to fix the incidents
Propose BI enhancements
Delivery - Solution Analyst
Define the logical modelling
Transform the logical to physical model rationalization
Support the business requirements analysis
Rationalize the multiple data quality rules to a single logical model
Identify the use of abstract principles and determining the overall modelling approach to be used
Provide technical specification and deliver the solution using meta data methodologies
BI Developer (Oracle)
Understand the data structure and meaning in both source and target BI systems
Identify data sources
Assess data sources
Create source/target mappings
Apply business rules as transformations
Design and develop the solution following the best practices
Perform the unit test and the regression test
Perform data reconciliation
Work with production data to monitor and report on data conditions and qualit