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:

SAP BI/BW Consultant
Location: Cape Town
Salary:
SAP bi/BW consultant (Contract)ð Onsite | Cape Townð Experience: 5-7 YearsWe are looking for an experienced SAP bi/BW consultant for a contract role in a large enterprise SAP environment. The role is fully onsite in Cape Town.
11 days ago

Microsoft Dynamics 365 Consultant
Location: Johannesburg
Salary:
1 day ago

Applications Manager
Location: Cape Town
Salary: Monthly
If you enjoy turning complex systems into smooth-running engines, this role is for you. As Applications Manager, you’ll take charge of core business applications keeping them stable, scalable, and perfectly aligned with business goals while delivering smart, customer-centric solutions that actually make work easier.You’ll own the full application journey, from design and development to...
2 days ago

Senior Actuarial Analyst
Location: Johannesburg
Salary: Annually
Own the analytics engine behind South Africa’s debt review (DR) performance. This role is ideal for an analytics leader who thrives on turning complex lifecycle data into predictive insight, sharper workflows, and measurable collections uplift. You’ll build a single source of truth across Active DR, Pre-Termination, and Terminated DR (TDR), translating data into real operational and fi...
2 days ago

Senior Investment Consultant
Location: Johannesburg
Salary:
Novare Actuaries & consultants (NAC) is seeking a Senior Investment consultant to lead client engagements, provide strategic investment advice, and deliver high-quality consulting outputs. This role combines technical investment expertise with strong client relationship management skills and offers the opportunity to mentor junior consultants while driving NAC’s transition to a tech-enab...
2 days ago

Talent Acquisition Consultant
Location: Midrand
Salary: Negotiable
We are seeking a highly skilled Talent Acquisition consultant to drive the attraction and hiring of top talent across industrial IT/OT, engineering, energy, and critical infrastructure sectors. This role is pivotal in designing and executing strategic sourcing, recruitment, and onboarding processes that build a diverse, future-ready workforce al...
2 days ago

IT Project Manager
Location: Cape Town
Salary: Monthly
We’re looking for a driven Project Manager to lead the end-to-end delivery of high-impact technology initiatives. This role turns strategy into execution—delivering projects on time, within scope, and on budget while maintaining high quality standards. You’ll own project planning, scheduling, roadmaps, and budget management, coordinating cross-functional teams, managing risks and...
3 days ago

Senior Full Stack Developer (Contract)
Location: Johannesburg
Salary: R592 Hourly
Are you a seasoned Full Stack Developer ready to take ownership of cutting-edge projects in the Private Banking space? This is your chance to work on high-impact solutions that shape the future of lending technology.
3 days ago

CLIENT ACCOUNTANT
Location: Southern Suburbs
Salary:
Client Accountant - Claremont - Southern Suburbs - Western CapeAfter successfully completing probation, the employee can work from home three days per weekResponsible for providing accounting and financial support to assigned clientsBenefits: provident fund with momentum
4 days ago

Debtors Controller
Location: Stellenbosch
Salary: 300000 Annually
Stellenbosch finance talent, this one’s for you! Ready to take your debtors expertise into a fast-paced logistics environment with real impact?
4 days ago

BI Consultant

Similar jobs you might be interested in:

Create a free job alert for BI Consultant in