BI Consultant

Recruiter:

Rosstone Consulting

Job Ref:

ROS00551

Date posted:

Sunday, August 29, 2021

Location:

, South Africa

Salary:

Negotiable

SUMMARY:
The Role:

We are looking for a BI Consultant: Office based (Centurion)

Development of high-quality database solutionsÂ
Develop, implement, and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
Research required data
Build appropriate a...

POSITION INFO:
The Role:
We are looking for a BI Consultant: Office based (Centurion)
- Development of high-quality database solutionsÂ
- Develop, implement, and optimize stored procedures and functions using T-SQL
- Review and interpret ongoing business report requirements
- Research required data
- Build appropriate and useful reporting deliverables
- Analyse existing SQL queries for performance improvements
- Suggest new queries
- Develop procedures and scripts for data migration
- Provide timely scheduled management reporting
- Investigate exceptions with regard to asset movements
- Unit testing and compliance to Change Control process
- Data Warehouse load process monitoring (Standby after hours)
Skills and Experience:
- Proven experience as a BI Consultant (3- 5years)
- In-depth knowledge of MS Reporting services
- Thorough understanding of Business Intelligence concepts, like the ETL process, Dim and Fact tables and Warehouse
- Working knowledge of SSIS-packages
- In-depth knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices
- Assisting in database design and technical specifications
- Monitoring SQL performance issues and efficiency (Dead lock tracing etc.)
- Creating and optimizing complex SQL queries for data extraction
- Developing and maintaining interfaces between Symplexity and other systems.
- Ability to understand complex technical and logical concepts.
- Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required.
- Familiarity with RDBMS principles, database design and normalization
- Experience with complex query design, stored procedures, views and functions
- Understanding of index design and T-SQL performance tuning techniques
Â

Following skills are a plus:
- MS Reporting services Subscriptions
- Crystal 8.5, 10Â or 11 knowledge
NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Power BI Consultant
Location: Limpopo
Salary: Market related
Power bi to automate reporting processes and transition the bi team from manual Excel-based routines
50 days ago

Finance Business Partner
Location: Johannesburg
Salary: 1000000
Opportunity for a Finance Business Partner
Today

Actuarial Spealist
Location: Cape Town
Salary: Annually
Are you an ambitious Actuary or Senior Actuarial Analyst looking to make your mark in a dynamic, growing environment? A leading professional services firm is looking for an Actuarial Specialist to join their expanding actuarial team. This is a rare opportunity to be part of an entrepreneurial setup — where you’ll help shape the actuarial offering and support audit teams across a divers...
Today

Senior Java Back-End Engineer (Remote)
Location: Johannesburg
Salary: 70000.00 Monthly
Our client, a boutique software engineering firm supporting fintech projects globally, is seeking a Senior Backend Software Engineer to architect, develop, and optimize high-performance backend systems. This is a fully remote, work-from-home position.
Today

Business Development Manager
Location: Midrand
Salary:
Our client is seeking an experienced and dynamic Business Development Manager to join their Gauteng team. This is a pivotal role for a strategic thinker with a proven track record in driving revenue growth through innovative sales strategies.
Today

Senior Data & BI Developer
Location: Cape Town
Salary: 100000.00 Monthly
Our client is looking for a highly skilled Senior Data & bi Developer to join their team. They specialise in data-driven digital solutions across multiple industries. This opportunity allows you to work on cutting-edge Microsoft data platforms while collaborating directly with customers to deliver impactful business intelligence solutions.
Today

Head of IT
Location: Cape Town
Salary: Monthly
Driving innovation and business growth through strategic leadership and cutting-edge IT excellence.
1 day ago

AI Engineer
Location: Centurion
Salary: Monthly
We are seeking an experienced Head of IT to lead and manage an organisation’s IT infrastructure environments. This role is responsible for ensuring the stability, scalability, and security of all IT systems and supporting power infrastructure, while overseeing vendors, internal governance, and incident response.
1 day ago

Financial Business Analyst
Location: Johannesburg
Salary: 700000 Annually
ð Financial Business Analyst – Turning Data Into Strategic Direction! Are you a numbers-driven problem solver who loves connecting the dots between data, finance, and strategy?
2 days ago

Actuarial Analyst
Location: Cape Town
Salary:
Are you an ambitious nearly or newly qualified Actuary looking to build something from the ground up? Join a growing professional services firm where you won’t just do actuarial work — you’ll shape it. This is your opportunity to be part of a founding actuarial team, influence strategy, and work with blue-chip clients across insurance, retirement funding, and healthcare.
2 days ago

BI Consultant

Similar jobs you might be interested in:

Create a free job alert for BI Consultant in