Analyst Programmer (Copy)SSRS reports SSAS CubesRole title Analyst ProgrammerLocation ISD Office - Auckland ParkReporting structure Business Systems -
Microsoft BI ManagerROLE SUMMARYDevelopment, maintenance and support of the Enterprise Datawarehouse, including the developmentand loading of various ODS's, developing and maintaining SSRS reports and development and loading ofSSAS cubes.
KEY RESPONSIBILITIESExternal and Internal Customer SupportLiaise with customer base ( Netcare management) on system requirements and integration with business processes.
Interact with technical department and other members of the Business Systems department on performancemonitoring and improvements, bandwidth consumption, and related hardware and technical issues.
Discuss and resolve queries with technical team and customer base.Scoping / strategy sessions with the customer base / technical team and Business Systems to determine the longer term strategy of Enterprise Data Warehouse within the global corporation.
Training of customer base in relevant technologies / tools where applicable.Existing Systems and TechnologyAssist in identifying, interpreting and providing business intelligence systems to enable organisation wide decision making.
Implement development and operational processes and standards within the Microsoft BI team.Analysis and improvement of Enterprise Data Warehouse using formal analysis methodologies to ensure best practice standards are maintained and / or implemented.
The ability to analyze and work with large data sets doing queries, data cleansing, transformation and presentation.Identification of problems, opportunities and / or gaps in the tools and technologies employed by Business Systems.
Review and recommend suitable technical specifications for system tools and technology.Database design and development, including SQL queries, stored procedures.
Microsoft SSAS Cube development, design and utilisationSQL Server administration and monitoring functions.SKILLS PROFILEPrinted copies of this document are uncontrolled and must be destroyed after useEDUCATIONMatric / Grade 12 qualificationTertiary qualification in Information Technology (Preferable)WORK EXPERIENCEMinimum of 3 years experience in database technology (MS SQL), reporting technology (SSRS) and Multidimensional Modelling (MS SSAS)KNOWLEDGEExperience in and knowledge of the healthcare industry beneficial500k per annum or around 42 k pm