Bi Analyst Developer - (Ee) - Cape Town

Job RoleThe 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.ResponsibilitiesDefining 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.RequirementsQualificationsDegree/DiplomaTechnical Knowledge & ExperienceAt 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):-DatastageDB2SQLSAP Hana (DB)SAP Data ServicesCloudera Hadoop technologiesDatabase viewing toolsScripting languagesReport generation toolsKnowledge of BI processes and methodologies such as (but not limited to):-Agile developmentETLData integrationData modelling/Application modellingData analysis, visualization and reportingIngestionSDLC, release management and project managementAPI integration