Oct 27, 2020 | Information Technology (IT), Life Insurance
Seeking a BI Analyst Developer with an IT Degree/Diploma and at least 3 to 4 years of relevant experience for an EE position with a large corporate based in Cape Town.
Job Role
The BI Analyst Developer is an IT specialist with advanced analytical and technical skills who understands the data structures and various data sources.
The performance of the Analyst Developer (BI) can be measured by:-
Timely delivery of analysis, reports and data presentations to support business reviews.
Turnaround time for answering a given business demand.
User satisfaction.
Responsibilities
Defining the requirements for analysis within a given business area.
Design and develop ETL processes by performing detailed analysis using the ingestion toolsets of the organization.
Providing users with correct data to do their analysis on.
Performing root cause analysis of data issues and troubleshoot technical difficulties.
Identifying data anomalies and communicating back to the data owners.
Interpretation of specifications received (including data models, if applicable).
Create and maintain data model documentation.
Work with data sources (raw data).
Presenting results to the business unit leader in a preferred tool (such as Office Suite, BI Report or Dashboard).
Testing and debugging of programs.
Requirements
Qualifications
Degree/Diploma
Technical Knowledge & Experience
At least 3 to 4 years of relevant experience in a similar environment working with the relevant tools and techniques listed hereunder:-
Technical expert with a strong understanding of Data, Data structures and Data sources.
Knowledge and experience of structured data, such as entities, classes, hierarchies, relationships and metadata.
Knowledge of database management system (DBMS) physical implementation, including tables, joins and SQL querying.
Ability to combine data from multiple sources when needed for the analysis.
Familiarity with the use cases, business purposes and quality of the data.
Knowledge of technical toolsets to perform all duties such as (but not limited to):-
Datastage
DB2
SQL
SAP Hana (DB)
SAP Data Services
Cloudera Hadoop technologies
Database viewing tools
Scripting languages
Report generation tools
Knowledge of BI processes and methodologies such as (but not limited to):-
Agile development
ETL
Data integration
Data modelling/Application modelling
Data analysis, visualization and reporting
Ingestion
SDLC, release management and project management
API integration