RFX - 4901056-2 -Senior Business Intelligence Solution Design Specialist
Tipp Focus
- Pretoria, Gauteng
- Contract
- Full-time
The Business Intelligence & Analytics Centre of Excellence (BI & A CoE) requires the services of a Senior BI Technical Architect to assist with detailed technical architecture and BI solution design deliverables for Business Intelligence Projects within the Business and Systems Technology Department.
The Senior BI Technical Architect will be required to perform design and architecture functions as per BI standards in the company.Objective of this Scope of Work
The Senior BI Technical Architect will focus on the detailed technical designs of the ESD Renewal Program BI solutions as well as oversee and guide the development of the solution against these designs. The business and information technology (IT) needs will be translated into a solution design that enables the developers to use to ensure effective system development and delivery; focusing on making the end to end technical design clear from the input source systems, the required processing and envisioned dissemination of information to both internal and external parties in order to achieve business goals; and address the technical design of the ETL, data warehouse tables, OLAP cubes, visualizations and data delivery mechanism to stakeholders both addressing defined user requirements and performance and efficiency issues.Scope of Services Definition
The scope will include but will not be limited to:Provide technical leadership to the project’s resources, which could include Developers, Integration specialists, testers and Business Analysts in delivering a well designed and engineered solution that is integrated with the existing or defined IT architecture and services framework that meets clearly defined technical performance requirements.
Engage with the Business Analyst for the BI solution and ensure complete understanding of the business objectives, drivers, functions, structures, detailed workflows and information needs as per the business specifications document.
Responsible for the development of technical design documentation, and supporting the implementation, testing, operation of the solution as well as validation of product certifications, and highlighting any non-compliances.
Provide continuity of technical understanding across the BI Architecture Blueprint, presales architecture, and the definition of technical design during the various phases of solution definition.
Assist Project Manager in defining the delivery approach, provide input to estimates and resource planning required to deliver the proposed solution.
Liaise with architecture governance team to observe conformity with agreed enterprise standards and to facilitate the implementation of the solution based on the approved and licensed tools while drafting exemptions where required.
Lead the project team in the troubleshooting of technical issues related to the project implementation and promote development of expertise in the delivery team.
Any other duties and / or deliverables closely related or necessary for the purpose of delivering the services.Knowledge, experience and personal competencies
Education and experience:
A minimum of a Bachelor Degree in Information Technology or equivalent
TOGAF Certification
Data Warehouse Certification (Kimball / Inmon)
Proven knowledge of Microsoft Power BI Report Server and Microsoft Power BI Services
Knowledge of on premise to cloud migration to Microsoft Power BI Services
Proven knowledge of designing solution using Oracle ODI
Minimum 5 years of experience with detailed architecture designs on Oracle, SAS, Microsoft BI product stacks
Must be proficient in SQL, Oracle and AIX
Must be experienced in using SQL Developer for Oracle
Project exposure (waterfall and agile methodologies)
Must have solid expertise in designing Star schemas
Must have experience in BI Infrastructure components from Applications, Databases, Operating Systems and Networks
Formulation and standards for the BI Ecosystem
Must have hands on experience designing solutions that integrate complex data sources in both real time and ETL based data extraction mechanisms DIMENSIONS
Experience with facilitating workshops.
Experience in negotiating for desired outcomesPersonal competencies:
Problem Solving Style:
Identifies, clarifies/defines and works through challenges towards a defined outcome.
Leadership: Strategically orientated concerned with ensuring the current and future viability of the Area/Bank.
Respecting each other:
Value: Demonstrates dignity of all people. Respects others and what the Bank stands for.
Leadership: Role models and attitude of respect towards and appreciation of all. Drives the appreciation of diversity within the business.
Delivering to Shareholders:
Value: Manages one’s time and resources to ensure that objectives are achieved affectively and on time.
Leadership: Champions strategic interventions. Tends to achieve delivery of results through directing others.
Communicating with Impact:
Effectively applies verbal, nonverbal, and written communication methods to achieve desired results. Presents ideas effectively to individuals and groups.
Leadership: Communication involves crafting courses of action, motivating and managing commitment.
Working with teams:
Value: We, and all aspects of our work, are interdependent. We appreciate that, as teams, we can achieve much greater things than as individuals. We value teams within and across business units, divisions and countries.
Understands team dynamics and uses a flexible interpersonal style to contribute to the effective functioning of teams and to the completion of team goals. Must demonstrate the ability to be affective in diverse teams ranging from highly structured hierarchical teams to informally structured groups.
Leadership: Sets up, develops and leads teams.
Building Relationships:
Develops and maintains ongoing working relationships, networks and partnerships to help achieve business goals through others (e.g. peers, functional partners, customers, etc.).
Leadership: Relationships span business units and focus on strategic issues. The context is very dynamic with significant levels of ambiguity.
Business Knowledge and Contribution:
Understands the broader business environment in which they work from an industry, organisation, business unit and role perspective.
Mature: Demonstrates solid industry understanding with tactical insight into the broader Banks strategy and objectives.
Risk Management:
Timeously identifies and manages risk within their area of influence. Uses and / or develops and implements risk measurement and risk management systems, processes and policies within the business.
Mature: Mature understanding of risk as reflected in the ability to proactively identify and manage risk across their business, division and interdependent areas.
Project Management:
Develops and monitors courses of action (work plans) for themselves and others to ensure that work is completed in a controlled and efficient manner.
Expert: Has significant experience in and demonstrates advanced project management skills used in facilitating organisation wide integration, determining nature of tasks to be completed as well as priorities to be pursued. Holds strong accountability for successful implementation of business related initiatives.
Knowledge Management:
Uses and / or develops and implements systems and processes to capture, manage and distribute up to date, accurate and readily accessible knowledge and information across the business, to a wide range of stakeholders.
Expert: Generally recognised as a knowledge management expert. Skills can include extensive best practice knowledge and understanding, the exercise of significantly advanced data analysis skill and / or implementation of leading edge measurement / knowledge management processes.
Personal Attributes
Analytical Thinking:
The ability to identify, assimilate and interpret the critical elements of a situation.
Seeks out pertinent data in determining the source of a problem.
The ability to interpret complicated information.
Challenges assumptions and focuses on the relevant detail.
Breaks down and reformulates problems into workable units.
Connections
Identifies and interprets the underlying trends and relationships among different or seemingly unrelated pieces of data.
Looks beyond the concrete facts at the underlying meaning and implications.
Seeking/Depth
Identifies when more data is needed to make a sound decision and then acquires the necessary information from the appropriate sources.
Identifies cause/effect, implications, possibilities and the root cause of problems.
Conceptual Thinking:
The ability to link events and to keep all facts in mind.
Examines the bigger picture to understand how the various parts fit together (integrative thinking).
Externally focused and able to translate this into appropriate and tangible internal action.
The ability to generate comprehensive solutions.
Interested in theories and enjoys discussing abstract concepts.
Information Gathering:
Seeks all relevant information for decision-making.
Consults widely with others when analysing issues.
Seeks information from diverse sources.
Asks probing questions to establish all the necessary facts.
Written Communication:
The ability to express ideas clearly in writing, in good grammatical form so that it is easily understood.
Displays the ability to be accurate, brief and clear whilst using the written word.
Written communications are readily understood by the intended recipients.
Has a command of language: sentence construction, grammar, spelling etc.