BI Specialist

Recruiter:

Augment and Recruit

Job Ref:

JHB000080/DG

Date posted:

Friday, July 1, 2022

Location:

Johannesburg, South Africa

JOB SUMMARY:
One of our client's in the Gaming industry who has a national presence is looking to grow their team and is currently on the market for an experienced BI Specialist.

JOB DESCRIPTION:

Purpose of the Role:
To drive the development of detailed business requirements and participate in the design, development, analysis and testing of business processes and technology changes

Duties and Responsibilities:

Define and document business requirements

Obtain documentation and engage with business users to understand the departments, their processes and technology applications
Document the scope, expectations and timelines in consultation with the project manager assigned to the work
Use techniques such as brainstorming, document analysis, focus groups, facilitated requirements workshops and prototyping to elicit complete and accurate business requirements for process or technology items
Depending on the project, develop the data requirements and business information model requirements in consultation with the Business Intelligence and Data Management teams
Document risks and issues identified by business participants during the requirements gathering process
Validate and drive the sign-off of documented requirements. Ensure that all stakeholders have a common understanding of the requirements including the business owners of the items, process engineers and technology teams
Evaluate and develop solution options for the business to select from including developing basic business cases and decision support tools. Research external practices to take into consideration ensuring that only publicly available information is used and that regulations related to competitor information are adhered to
Conduct an impact assessment for changes in scope, business requirements or delivery timelines and ensure that business owners formally approve the changes before they are added
Review current state processes and identify problem areas, potential control failure points and streamlining opportunities
Track the usage of the requirements documents through the life cycle of implementing the changes and support ongoing efforts to ensure that solutions that are designed are in fact in line with business expectations
Participate in the identification of the change impacts of new business requirements at the outset and throughout the change life cycle
Participate in change management activities such as the development of user guides or training materials once the business solutions are moved into implementation stage

System solution design and implementation support

Participate in the development of functional and technical systems specifications for the Sage ERP or lottery or other systems
Utilise techniques such as business rule analysis, modelling, data definitions, process modelling and scenarios to determine the detailed specifications
Work closely with the technology teams to ensure a comprehensive understanding of the business requirements when they design and develop solutions Occasional interaction with external technology providers is expected
Provide support and input into system test plans including the development of test cases, test scripts and scenarios
Participate in the user acceptance testing of new functionality developed using the business requirements Provide detailed feedback on whether the functionality meets the business expectations

Governance

Apply strict version control to requirements documentation
Ensure that documents are properly approved and then stored according to the document storage and retention policy

QlikView Development

Plan, organize, control, and evaluate the data available in the databases
Design, develop and publish QlikView models
Build of Dashboards, Reports and Data Visualisation
Meet with managers to discuss system requirements, specifications, and timelines
Test all models according to testing procedures (e.g., UAT)
Maintain and update published models

SSRS Reporting

Design reports in SSRS
Set up schedules in SSIS
Ensure all tasks are up to date and monitor delivery to recipients
Ensure Data Balances in the MS SQL database with the Data in the Oracle Database
Troubleshoot any datasets daily to ensure all data has been collected (balance between MS SQL and Oracle, as well as SSRS and QlikView)

Maintenance

Troubleshoot models for any irregularities once changes were made (Regression testing)
Maintain and update published models
Communication with stakeholders regarding the published models and ensure customer satisfaction
Monitoring of model usage
Ensure allocation of correct license CALs to users
Updating and maintain the Security access list
Communicate with Server Specialist to update Groups for QV Users once a new user is brought on board
Maintain Publisher and ensure schedules are not in conflict with each other

Training

Train user groups on the published model
Provide individual training and support on request
Maintain log and/or list of required maintenance
Provide access and train users
Creates document for the technical design and specifications

Knowledge and Experience:

6 years+ experience as a BI Specialist/Analyst
Experience working in a team-oriented, collaborative environment
6 years + experience in Microstrategy or QlikView
6 years + experience with SSRS Reporting
Excellent practical understanding of process analysis and design
Ability to facilitate requirements gathering and validation
Good project management skills and/or substantial exposure to project-based work structures.
Excellent written and oral communication skills
Excellent listening, presentation, and interpersonal skills
Ability to communicate ideas in both technical and user-friendly language
Able to prioritize and execute tasks in a high-pressure environment
Computer hardware and software systems and programs
QlikView data extraction and data balancing
QlikView Publisher
SSIS
SSRS
Strong Data visualisation skills
Data interrogation and balancing
Ability to migrate requirements to QV solutions
Computer skills including the ability to operate spreadsheets, word-processing, graphics

Qualifications

Degree in Information Technology or related qualification
Diploma in Data Analysis
QlikView Designer
QlikView Developer

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

BI Specialist - Oracle Fusion
Location: Sandton
Salary: Highly Competitive Remuneration Offered Annually
Our client, one of the leading mining companies in South Africa, seeks a highly competent ERP specialist, to manage and improve the ERP system (Oracle Fusion) and provide procurement systems (Coupa) support across multiple operations.
18 days ago

BI / Reporting Specialist
Location: Johannesburg
Salary: Negotiable on experience
strong SQL expertise to design, develop, and maintain business intelligence solutions. Minimum 6 years’ experience with a strong proficiency in SQL / T-SQL development and debugging (core requirement). Hands-on experience with: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Analysis Services (SSAS).
42 days ago

Data Scientist / Data Analyst
Location: Johannesburg
Salary:
The Future Runs on Data - and You’re Holding the Keys.You know data - you see patterns where others see chaos. Whether you’re in banking or telecoms, you’ve built your craft turning raw info into insights that move the needle. I’m not here to offer “a role”; I’m here to connect with the sharpest analytical minds in SA and line up real opportunities that ac...
1 day ago

BI Data Analyst
Location: Johannesburg
Salary:
Ready to turn data chaos into clarity? A multinational logistics conglomerate is on the hunt for a bi Data Analyst who doesn’t just read the numbers, but speaks them fluently. If you thrive on digging into data, building slick dashboards and turning insights into business impact, this could be your next big career move.
2 days ago

Senior Java Developer
Location: Johannesburg
Salary: 800000 Annually
Are you a seasoned Java developer ready to take on complex challenges and drive innovation? This is your opportunity to work on cutting-edge solutions that make a real impact.
4 days ago

Front-end Developer
Location: Johannesburg
Salary: TBC Annually
A leading tech team is looking for a skilled Front-end Developer to join their development division. If you’re passionate about building responsive, user-centric web applications and have strong experience with modern JavaScript frameworks -especially Vue - this is your opportunity to work on innovative projects in the tourism and travel sector.
4 days ago

Solutions Architect
Location: Johannesburg
Salary: 1 300 000 Annually
A leading organisation is seeking an experienced IA Solution Architect to lead the design and implementation of intelligent automation solutions. This role is ideal for someone who thrives in a strategic, cross-functional environment and is passionate about driving innovation through automation, architecture, and business transformation.
4 days ago

Full Stack Developer
Location: Centurion
Salary: 450 000 Annually
A dynamic tech team is seeking a Full Stack Developer with 2–3 years of experience to help design, develop, and maintain cutting-edge software applications. This is a great opportunity to work across the entire stack, from front-end interfaces to back-end systems, while contributing to innovative solutions that drive client success.
4 days ago

Software Tester
Location: Centurion
Salary: 350 000 Annually
Are you passionate about ensuring software works flawlessly? A leading tech company is looking for a skilled Software Tester to help maintain the quality and reliability of its enabling software solutions. You’ll be part of a collaborative team working on exciting projects, using both manual and automated testing to drive excellence across the development lifecycle.
4 days ago

Senior C# Developer
Location: Midrand
Salary: 700 000
Are you passionate about crafting robust, high-performance back-end systems in C#? Step into a dynamic and forward-thinking environment where your expertise drives real-world impact. We’re looking for a seasoned Developer to architect scalable solutions, mentor teams, and push the boundaries of innovation.
4 days ago

BI Specialist

Similar jobs you might be interested in:

Create a free job alert for BI Specialist in Johannesburg