Microsoft Bi Data Engineer (Ssis, Ssas, Power Bi)

Microsoft Bi Data Engineer (Ssis, Ssas, Power Bi)

PBT Group | Johannesburg, GT, ZA

Posted 16 days ago

Apply Now


PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS.REQUIRED SKILLS:- Microsoft BI: Strong SQL, SSIS, SSAS, SSRS- Strong modular system design skills.- Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them.- System analysis and design skills are necessary to design and document the data extractions and transformations.- Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs.- Good organisation, planning and basic management skills.- Good interpersonal and communication skills.- Decision making and problem solving skills.REQUIRED QUALIFICATIONS / TRAINING:- Relevant data warehouse and BI solution training is essential.- B.Sc. or related degree is advantageous.- 5+ years programming experience.DUTIES:Duties: Back-end- Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.- Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.- Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.- Perform root cause analysis, performance monitoring and application related issues.- Review IT work products from the team members for completeness and quality.- Accurately translate business requirement to technical documentation and test case or results.- Analyse and map data from source systems to target operational data stores and data marts.- Maintain and provide application support in production.- Code or folder migration from one environment to another as part of release management.- Participation in all aspects of quality assurance.- Active participation in systems integration and user acceptance testing.Duties: Front-End- Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools.- Develop the semantic layer, metadata, reports and report definitions.- Develop graphs and portal interfaces.- Load and maintain the metadata for the data access tool.- Troubleshoot BI tools, systems and software; performance-tune these applications as necessary.- Produce complex, efficient, error-free reporting solutions and related documentation.- BI front end development on data structures, cubes, reporting, dashboards, etc.