An External Vacancy exists for a Business Intelligence (BI) Specialist in the BTS Infrastructure Division – Centurion Head Office
The suitable candidate’s main responsibilities and duties include, but are not limited to, the following:
The Business Intelligence (BI) Specialist is responsible for the design, development, implementation, management and support of mission-critical enterprise reports and dashboards.
BI reporting by Extract, Transform, Load (ETL) processes from environments.
Working with cross-functional teams, you will be required to gather, document and approve business requirements for data analysis and reporting projects, as well as use BI and database tools to develop reporting solutions to meet business needs.
Using your skills and experience as a BI Specialist, you will design, develop and implement ETL processes to transform structured, unstructured and disparate source data into the target data store(s)/ data warehouse(s) / data mart(s).
Business analysis to gather required BI system requirements
Translate business requirements into specifications that will be used to drive data store/ data warehouse/ data mart design and configuration.
Use ETL tools to load data store(s)/ data warehouse(s)/ data mart(s).
Transition developed BI systems to the Operations & Support team
Provide support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users
Ensure proper configuration management and change controls are implemented for your sphere of influence
Provide technical assistance and cross training to other team members
Design and implement technology best practices, guidelines and repeatable processes
Must be able to perform duties with moderate to low supervision Required
experience implementing enterprise-scale reporting systems, including Working with users in a requir : 3 to 4 years
Extensive use of SQL and RDBMS systems : 3 to 4 years
Proficiency with Cognos BI : 3 to 4 years
3+ years experience implementing enterprise-scale reporting systems, including Working with users in a requirements analysis role
Extensive use of SQL and RDBMS systems (SQL Server, MySQL, etc.)
Extensive experience with data warehouse implementations
Strong knowledge of logical and physical data modelling concepts
Proficiency with Cognos BI (preferably v10.x) (Framework Manager, Transformer, Metrics Server, Analysis Studio, Report Studio, Query Studio, etc.)
Cognos Administration and security management is a plus
Demonstrated ability with ETL tools. Familiarity with Informatica is a plus.
Performance tuning experience required
Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams
Requires strong analytical, conceptual and problem-solving abilities
Programming / scripting experience and knowledge of software development life cycle is preferred.
Ability to manage multiple priorities, and assess and adjust quickly to changing priorities
Requires leadership qualities to mentor junior members of the team.
BA/BS in Computer Science or related field is preferable.
Equivalent combination of experience, education and training will be considered
BI certifications desirable, preferably related to Cognos
Employment consideration will be in accordance with the Employment Equity Act requirements
Should you not hear from us within 14 days after closing date, your application should be considered unsuccessful
In order to apply for this job, please register your profile or log in with an existing account.