• Login Name       Password       Remember me       LOGIN LOGIN    FORGOT PASSWORD
  • REGISTER

 LOGIN WITH
 
 
 
 
 EMPLOYERS
 
 
 
 
 
 NEWSLETTER
 
 
 
 
 FOLLOW US

BI Specialist

Job Ref
272237
Job Type
Permanent
Employer Type
Recruitment Agency
Date Added 22 Feb 2017
Expiry Date 8 Apr 2017
* There have been no applications to this job.
* This job has been viewed 785 times.
Employer:
SET Consulting

Location:
Gauteng (Jhb)

Salary:
ZAR250000 - ZAR300000

Benefits:


Role details:
A Data Warehouse Developer
- - - - - - - - - - - - - -
A Data Warehouse Developer is a technical resource within the organization, and fulfills development of Business Intelligence Data Warehouse Solutions. This resource needs to have extensive knowledge in the Microsoft toolset.
1.Skills/Attributes Required
1.1.Qualifications

IT Degree or relevant degree


SQL - queries, views, stored procedures


SQL Server 2005/2008/2008 R2 or latest
SSIS 2005/2008/2008 R2 or latest
SSRS 2005/2008/2008 R2 or latest
SSAS 2005/2008/2008 R2 or latest
MDX
MDS


Database modelling (advantageous)


Kimball methodology
COBIT (advantageous)
ITIL (advantageous)
System thinking (advantageous)

1.2.Experience:

At least 4 to 6 years relevant working experience.
At least 3 years Business Intelligence working experience, gained on a variety of projects and technologies making use of Microsoft toolset.
Proven track record in similar position.
Good understanding and proven ability to apply relevant data warehouse methodologies.
Understanding of Business Intelligence standards and best practices.

1.3.Skills:
1.3.1.Working with clients

Ability to work with a senior level of management.
Good understanding and exposure to business needs, preferably in varied industries.
Strategic thinking ability, combined with skills to realise solutions in detail.
Exceptional facilitation and elicitation skills.
Ability to document requirements with clarity.
Use of your initiative in bringing new ideas to the table.

1.3.2.Working with Team

Be part of the team launching BI as an offering.
Perform training and knowledge transfer regarding BI with our staff.
Assist in the generation of service offering to our customers.

1.3.3.Personal characteristics

Good planning and organising skills.
To be self-motivated and able to work under pressure to tight deadlines.
To be able to work as part of a team.
Excellent communication and interpersonal skills.
Facilitation and presentation skills.
Critical thinking and creative problem solving skills.
High tolerance for ambiguity.
Ability to work with limited guidance.
Ability to manage, lead and influence globally dispersed resources effectively and efficiently.
Ability to simultaneously support mulitiple programmes and projects of varying duration and complexity across various functional areas and jurisdictions.
Decisive with ability to recognize risk and be able to recommend "Go/No go" decisions based on presented outcomes or lack thereof.
End to end experience and appreciation of the data warehouse lifecycle.

2.Job Duties and Responsibilities
2.1.Key responsibilities of the role include:

Ensure regular contributions to business intelligence knowledge base.
Ensure adherence to STANLIB Data Warehouse Centre of Excellence governance structures.
Contribute to and support the organization's Business Intelligence strategy.
Enable the use of Business Intelligence Solutions and concepts across the organization.
Work with user community to understand business process challenges and identify solution opportunities within Business Intelligence area.
Work with business analysts and business to understand business requirements and develop suitable solutions.
Translate project/enhancement requirements into technical specification.
Create detailed work breakdown structures for solutions.
Work with internal resources during development phases to ensure appropriate knowledge transfer.
Contribute to design of data warehouse solutions as per KITE standards.
Design and implement the data loading (ETL) and publishing processes within the data warehouse environment.
Development of data warehouse solution as per KITE standards.
Develop static reports to satisfy business needs.
Develop ad hoc reports to satisfy business needs.
Develop cubes to satisfy business needs.
Develop data extracts to satisfy business needs.
Develop master data service interface to satisfy business needs.
Develop dashboards to satisfy business needs.
Contribute towards self-service BI thinking into STANLIB.
Perform unit tests on solutions developed.
Provide business and technical knowledge and expertise on STANLIB's core source systems with emphasis on sourcing of data.
Provides input into performance appraisals.
Attend and contribute to communication and progress meetings for accountable areas.
Perform peer code reviews and health checks.
Ensure to demonstrate the company's values on a daily basis.
Participate in data governance for STANLIB's source systems.
Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.
Ensure a focus on information/data quality by developing and publishing enterprise data standards such as a common business vocabulary, naming conventions, data standards, transformation rules and related enterprise consistency specifications.
Ensure the development and documentation of business and technical Meta data.
Assist in defining development standards.




 
HOME|
INFO|