BI Consultant

Recruiter:

Rosstone Consulting

Job Ref:

ROS00551

Date posted:

Wednesday, October 6, 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:

Junior BI Consultant.
Location: Johannesburg
Salary: Negotiable on experience
1 – 3 years’ experience in a SQL, reporting or data related role (or good academic background with practical SQL exposure). Good working knowledge of SQL and an understanding of relational database concepts.
50 days ago

Data Scientist
Location: Johannesburg
Salary: Annually
We are partnering with a leading, innovation-driven organisation within the insurance and risk solutions space to appoint a Data Scientist into a high-performing analytics function. This role is ideal for a technically strong individual who enjoys working with complex data, building scalable solutions, and delivering meaningful business insights.
1 day ago

Senior Data Analyst
Location: Stellenbosch
Salary:
A senior level data role for an analytical professional who enjoys turning complex information into clear insights while shaping structured data environments that support business decision making.
2 days ago

Senior Implementation Consultant
Location: Johannesburg
Salary:
An exciting opportunity for a senior insurance professional who enjoys translating business requirements into practical system solutions while working closely with corporate clients and internal stakeholders.
2 days ago

Intermediate DevOps Engineer
Location: Johannesburg
Salary:
A strong opportunity for an experienced DevOps professional who enjoys building reliable platforms improving delivery pipelines and supporting scalable digital solutions within a complex enterprise environment.
3 days ago

Customer Success Consultant
Location: Johannesburg
Salary:
Looking to grow long term client value while working closely with established business partners in a fast moving services environment. This opportunity offers exposure to relationship management sales support and account development with room for professional growth.
3 days ago

Data Analyst
Location: Johannesburg
Salary:
Are you a detailâdriven Data Analyst who enjoys turning complex data into clear, actionable business insights? Join a forwardâthinking environment where your analytical skills will directly influence operational, tactical, and strategic decisionâmaking.
6 days ago

Senior Data Analyst
Location: Centurion
Salary:
Are you a data-driven specialist who thrives on turning complex data into powerful business insights? This is an opportunity to make a real impact by driving strategy, managing risk, and shaping data-driven decision-making in a highly regulated environment.
6 days ago

Dynamics 365 Functional Consultant
Location: Johannesburg
Salary:
Gijima Staffing Solutions is recruiting on behalf of a client for a highly skilled MS Dynamics 365 Functional consultant to join their IT Centre of Excellence within the Group Risk division. 12 Month contractThis role is responsible for end-to-end delivery of Dynamics 365 solutions, from requirements analysis and solution design through to configuration, implementation, and post-go-live support.Yo...
6 days ago

Senior Data Analyst
Location: Stellenbosch
Salary:
A leading South African payment aggregator is seeking a seasoned Senior Data Analyst to take charge of their SQL Server data environment, shaping architecture, driving reporting insights, and championing data quality. This self-directed role blends technical mastery with business impact perfect for someone who thrives on solving complex problems, empowering teams with actionable insights, and elev...
6 days ago

BI Consultant

Similar jobs you might be interested in:

Create a free job alert for BI Consultant in