Senior Microsoft BI Stack Developer

PBT Group has a requirement for a Senior Microsoft BI Developer who knows SSIS, SSAS and SSRS. Ab Initio experience would be an advantage.

DUTIES:

• The role is more than just technical development
• Developing data models for our global data warehouses and big data initiatives.
• You will work closely with data engineers, architects, data scientists and business SMEs to create data models that can fulfill the Management Information / analytical requirements from the business.
• Develop Collections MI Dashboards and Reports meeting stakeholder requirements

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.

REQUIRED SKILLS:

• SQL
• SSAS Development and fixing of multidimensional cubes
• SSAS Admin skills like monitoring cubes and processes
• Power BI Developer and Admin skills
• OBIEE and Repository Development skills
• Presto / Big data knowledge
• Help analyse, investigate data issues from Oracle database as well as EVA (Big Data)
• Test data/ solutions
• Must engage / work closely with Business and development teams
• Migration of databases from Oracle database to EVA database
• 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.

Qualifications/ Certification:

• A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent