Business Intelligence Consultant - Johannesburg
Salary Negotiable
Johannesburg,
Gauteng
more than 14 days ago
PBT has a vacancy for a BI Consultant with strong SQL Analysis experience (SSAS) as well as Oracle Front End Development experience (OBIEE).
Required Skills:
Required Qualifications / Training:
Duties:
Required Skills:
- Solid MS BI experience
- 2+ years relevant experience in SSAS
- 2+ years’ experience with Front End Development tool OBIEE
- Intimate knowledge of source systems as well as a basic understanding of dimensional models.
- Conventional database- and data warehouse modelling skills, in order to understand the data warehouse data models.
- A sound knowledge of the programming language used to write the data staging programs or ETL tool.
- A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool, and to access the data warehouse from the access- or end-user reporting tools.
- A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.
- A sound knowledge of the capabilities of the data access- and reporting tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the end user programs or reports.
- Pride of work, thoroughness and attention to detail.
- Data warehouse modeling skills is advantageous, in order to understand the data warehouse data models.
- Keep abreast of new releases of these tools and work-arounds to overcome problem areas using these tools.
- Exposure to various BI front end applications, with working knowledge in at least one of them.
- Strong ability to analyse user requirements and build front-end BI applications according to specifications.
- Knowledge of scripting languages.
- Experience with one or more of the industry standard databases desired.
- Attention to detail and strong logical reasoning ability.
- Good communication skills.
- Pride of work, thoroughness and attention to detail.
Required Qualifications / Training:
- Course on the ETL / FE related toolset.
- Relevant data warehouse and BI solution training is essential.
- B.Sc. or related degree is advantageous.
- 2+ years programming experience.
Duties:
- Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.
- Conduct planning, analysis and design activities in conjunction with other development specialists.
- Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.
- Participate in estimation of tasks and assist in the development of project plans.
- Code or makes modifications to programs of high complexity, according to specifications.
- Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.
- Conduct walkthroughs and quality review of deliverables.
- Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.
- Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.
- Participate in the formulation of standards to support the data acquisition development process.
- Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.
- Ensure compliance with established policies, standards and methodologies.
- 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.
Recruiter: CompuJobs