Position Overview
As a Senior BI Specialist, with a focus on financial processes and reporting requirements combined with a passion for data solutions, the individual will be required to analyse business requirements, advise on and develop optimised BI solutions and visualise results utilising technologies from the MS BI stack.
The individual needs to be able to identify opportunities for improvement of business support processes driven by data and data flows. This role requires the individual to be able to guide business and technical users through the full solution development life cycle.
The Senior BI Specialist needs to technically oversee planned and developed solutions to ensure alignment to the BI strategic objectives as well as confirming that solutions meet quality and compliance requirements. The incumbent will need to take a leading role in end-user interaction sessions as well as driving specific projects & solution deliverables.
The ideal candidate for this role should have a fundamental desire to deliver accurate, optimised and time-efficient BI solutions aimed at improving business success.
Specific Role Responsibilities
- Maintain an awareness and understanding of technological advances; provide continuous research and assessment of new resources and technology available
- Query, analyse and build management reports
- Covering the entire development life cycle of BI projects, including defining the problem statement, business and technical analysis, solution design, development, testing (internal and with business), solution implementation, end to end documentation and solution & user support
- Assist in the development of technical standards to be followed within the BI department
- Independently generate outputs which represent operational data in brief and intelligible format, suitable for the target audience, which includes executive leadership department managers and executive board of directors
- Carry out quality assessment of data, data reports and the accompanying decisions
- Conduct analysis of findings and offer action-driven recommendations and insights to executive leaders and managers on the basis of results
- Trail industry yard stick, trends and benchmarks, and convey such information to executive leaders
- Guide intermediate and junior developers as well as business users with the objective to achieve an optimal technical solution to given requirements
- Utilising the approved product stack to produce the most effective as well as situation- and business-appropriate solution - including SSRS, SSAS, MS PowerBI, Microsoft SQL query, MS Excel, pivot tables and other tools
- Provide technical assistance to other BI team members (Information sharing)
- Train end users and technical support staff as required
- Collaborate with IT operations and testing resources to ensure timely releases of projects and make sure database environments are sustainable
- Collaborate with IT operations to perform root-cause analysis
- Be able to take directions and complete tasks on-time with minimal supervision
- Participate in special projects as needed and performs other BI related duties as assigned
- Work in a team environment
- Work on multiple assignments concurrently under aggressive deadlines
- Establish, support, and apportion data tools to the unit managers. He/she will actively determine prospective data and analytical requests to give support to management requirements
Qualifications and Experience
- Grade 12 / Matric (NQF equivalent)
- MS BI certification
- Data analytics certification
- Diploma / Higher qualification with corporate or management finance an advantage
- Must have had exposure to NoSQL databases, and specifically, be comfortable with MongoDb syntax
- Exposure to DAX script writing, C#, python and R development would be an advantage
- 3+ Years work experience in developing Power BI solutions. (Must be able to demonstrate visualisation of data)
- 5+ Years work experience in data analysis / mining
- Impressive experience in designing managerial level presentations and reports
- 2+ Years work experience in designing and developing MS SSAS tabular models
- 1+ Years work experience in BI cloud solution development, incl databases, data lakes data processing and visualisations
- 2+ Years work experience in data warehouse design
- Experience and understanding of financial reporting
- Experience in analysing and carrying out interpretations by utilizing intricate data sets.
- Experience in SSIS or another BI ETL Tool
- Knowledge of machine-learning methods would be an advantage
- Advanced understanding of data warehousing concepts
- Experience with core web development technologies - HTML, CSS, JavaScript, etc would be an advantage
- Experience as MS SQL DBA would be an advantage
Skills and Personal Attributes
- Outstanding skills in finding resolution to complicated problems while performing independently in a multifaceted and dynamic environment
- Critical-thinking and problem-solving
- Outstanding Communication skills
- Advanced SQL Query writing skills
- Advanced Excel skills
- Demonstrate skills in generating efficient, reliable working relationships with exco, staff, and customers
- Criminal and credit clear
- Reliable or own transport
- Punctual
- Attention to detail
- Team player
- Client focused
- Strong analytical ability
- Honesty and integrity
- Live up to own and company values
Gmail
Yahoomail