Business Intelligence Data Architect at Woolworths

Job description

Define end to end data design for BI solutions

• Provide the overall cohesiveness to ensure that all the components of the proposed BI solution will fit together
• Work in close collaboration with Data Integration and Information Delivery developers to ensure that the different parts of a solution are integrated and that appropriate technology choices are made.

Develop and define data standards

• Develops and defines the data standards for the organisation
• Communicates the business benefit of the data standards, champions and governs the standards across the organisation

Develop and define metadata management

• Understands the different metadata management processes and tools
• Designs and maintains the metadata repositories to enable the organisation to understand their data assets

Create optimal data design

• Works with business and technology stakeholders to translate business problems into data designs
• Creates optimal designs through iterative processes, aligning user needs with organisational objectives and system requirements

Develop and define data governance

• Takes responsibility for the assurance of data solutions and making recommendations to ensure compliance
• Accept overall responsibility for the Data Governance component of the BI environment, including data quality, integrity and reliability

Build and maintain relationships across business, suppliers and IT

• Establish effective and collaborative partnerships with Business, Enterprise Architecture and other relevant IT teams to formulate BI data strategies
• Act as a virtual member of the Enterprise Architecture team to provide specialist knowledge of Data Architectures concerns and principles to the Enterprise Architecture competency and that the Information/Data Architecture is considered in Enterprise Architecture implementations

Lead and drive research and development

• Lead and drive the Research & Development effort of the BI team in order to provide input into:
• Technology decisions to ensure that new technologies provide sufficient data for decision support
• The technical and data roadmap (BI Conceptual Architecture) to support the BI strategy
• Ensure that the Data Architecture methodology is subject to continuous improvement by applying lessons learnt from projects and initiatives to the base methodology in addition to monitoring industry trends and best practices to improve maturity in this area

Ensure team works effectively to produce quality work

• Build a sustainable team capability
•  Set aligned goals for subordinates to deliver

Minimum requirements

• Relevant 3 year tertiary or NQF aligned qualification
• Up to 8 years’ experience in IT, with a minimum of 5 years in a BI technical role and a minimum of 3 years in a BI architecture role
• Proven track record of delivering BI technical solutions
• Proven application of Data Warehousing and BI best practices
•  Proven track record of implementing innovative BI solutions leading to clear business benefits

Additional Criteria

• In depth knowledge of Data Warehousing and BI best practices
• In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies)
• Experience in dimensional modelling, analysing source systems, data flows and delivering data architecture designs
• Change oriented - supports and drives change and confronts challenges in creative ways
• Disciplined in applying BI standards but open to suggestion and change
• Abstract thinker who is capable of finding an appropriate solution to complex problems
• Meticulous and attention-to-detail focus
• Self-motivated with a can-do attitude
• Supports the development of business acumen of team through knowledge sharing and upskilling.
• Maintains advanced knowledge of business operations and organisational metrics and trends.
• Factors in retail models and levers in building an effective IT landscape.
• Benchmarks the competition and other relevant comparison groups.
• Makes sound technical decisions based on understanding of what is commercially achievable within technological constraints.
• Evaluates the applicability of solutions with the ability to challenge and qualify its suitability for the business.
• Leverages research on technology-related concepts, trends and best practices to provide guidance on IT roadmap.
• Set technical policies and procedures to support IT stability and success aligned to evolving technologies and methodologies.
• Effectively applies substantial in-depth analysis in order to determine and meet requirements
• Quickly identifies key issues, stakeholders and viewpoints in a complex situation or problem
• Finds ways to condense large amounts of information into a useful form
• Anticipates the consequences of situations and proactively works to overcome potential obstacles
• Asks perceptive, probing questions to get to the heart of the matter
• Plans and ensures implementation of activities/projects identified in business strategy
• Maintains a keen awareness of the interrelationships among various components of large-scale activities/projects
• Allocates time and resources as required when faced with multiple demands and competing priorities
• Considers the financial implications before finalising activity/project plans
• Actively monitors resource allocation and utilisation and makes adjustments as necessary
• Accurately interprets the moods, feelings and reactions of others and adjusts own behaviour to build effective relationships within the organisation and with its business partners
• Applies diplomacy and tact, demonstrating respect for differing perspectives
• Understands the perspectives of others to establish mutually beneficial objectives
• Seeks and influences new relationships outside own unit and identifies new collaborative partnerships that better position programmes and services.
• Shares information with colleagues and partners about industry trends and business opportunities.
• Coaches others on how to develop proposals and work plans for effective partnership arrangements.
• Establishes connections that help facilitate the accomplishment of broader organisational objectives.
• Actively listens, interprets and presents messages in different ways to enhance understanding.
• Appropriately adapts the message, style, and tone of communication to accommodate a variety of audiences.
• Reviews presentations to ensure effective use of tools and techniques and provides recommendations.
• Prepares a wide variety of complex reports and documents using diverse sources.
• Confidently addresses groups of people, adapting style as appropriate for different audiences.
• Anticipates change by keeping up to date on current research and trends affecting one’s own field
• Reviews, evaluates and disseminates information regarding key methodologies, best practices and tools to support a future landscape
• Continually searches for ways to adapt and improve through change
• Consciously models appropriate adaptions and encourages it in others
• Devises action plans for adapting to change
• Systematically analyses and shares the learning/ knowledge gained from change
• Redirects own or own team’s efforts in response to changed circumstances to ensure effective problem solving