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: Rosebank
Salary: Market related
Power bi to automate reporting processes and transition the bi team from manual Excel-based routines
Today

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

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

BI Consultant
Location: Pretoria
Salary:
Are you passionate about turning data into insight? This bi Analyst role offers the opportunity to build dynamic reporting, identify key trends, and influence decision-making in a fast-paced financial environment.
9 days ago

Senior Qlik BI Consultant
Location: Work From Home
Salary: Monthly
Companies of all sizes successfully rely on our client's management and IT consulting to solve relevant bi, planning and digitization challenges efficiently, modernly and reliably. They combine the strategic vision and commitment of a founder-managed company with the dynamism of a technology start-up.Your strong bi and specifically QLIK experience, as well involvement in the architectural aspects ...
20 days ago

Senior BI / Data Consultant
Location: Johannesburg
Salary: Negotiable
As a bi/Data consultant, you will analyze complex data, design impactful visualizations, and develop data integration strategies that drive smart business decisions. Youâ€™ll collaborate with internal teams and customers to create customized data solutions while ensuring data accuracy and availability across systems. You'll serve as the g...
16 days ago

Business Reporting Analyst
Location: Cape Town
Salary:
An exciting opportunity has become available for a skilled Business Reporting Analyst to join a leading organization in Cape Town. This role is well-suited to a detail-oriented professional with a passion for transforming complex data into clear, meaningful insights that directly support executive decision-making.Our client, a well-established company in a highly regulated and dynamic industry, is...
Today

Product Risk Team
Location: Johannesburg
Salary: Market Related
Are you a detail-driven leader with a flair for numbers, systems, and strategic thinking? Join a global commodities powerhouse and lead a high-performing team in the dynamic world of product risk. This is your opportunity to shape reporting excellence and drive innovation in a fast-paced, international trading environment.My client is currently seeking a Product Risk Team Lead to join their ...
Today

Business report analyst
Location: Cape Town
Salary:
Business Report AnalystAre you passionate about turning data into meaningful insights that drive executive decision-making? This is your opportunity to join a dynamic, fast-paced gaming and entertainment environment as a Business Reporting Analyst, where your analysis will directly impact business strategy and operations.Join a leading player in the gaming and entertainment industry, committed to ...
Today

Data Management Consultant - Senior Consultant and Manager
Location: Johannesburg
Salary: Market related
Develop and implement enterprise-wide data management strategies aligned with business objectives.
2 days ago

BI Consultant

Similar jobs you might be interested in:

Create a free job alert for BI Consultant in