Senior Microsoft Business Intelligence Developer - Johannesburg Verfied

Salary Negotiable Johannesburg, Gauteng Johannesburg, Gauteng more than 14 days ago 15-02-2017 4:01:06 PM
15-03-2017 4:01:06 PM
PBT Group has a requirement for 2 Senior MS BI Developers for an initial 6 month contract to do end-to-end BI development (backend and report development). Must have solid experience in SSIS, SSAS and SSRS.
 
With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.
 
We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional calibre, not only within BI, but also within focused areas of Application Development.
 
We have worked in more than 25 countries around the world and are currently implementing large-scale projects throughout Africa, the Middle East and Australia.
 
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.
 
REQUIRED SKILLS:
- Microsoft BI: Strong SQL, SSIS, SSAS, SSRS, T-SQL, Qlikview
- Solid understanding and experience in the BI industry – financial services would be preferable. 
- Experience working with large datasets.
- 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.

Recruiter: CompuJobs