Global EDW Modelling Lead - FMCG

Job Title: Global EDW Modelling Lead

Job Location: Bangalore

Function: Enterprise and Technology Solutions - Information & Analytics - Core Solutions Team

Reports to: Core Solutions - Global BI Data Model Manager

Scope of role: Global Regional Country Site specific Category

JOB PURPOSE

The Global EDW Modelling Lead (hereafter the Modelling Lead) will govern change and development of the global Enterprise Data Warehouse model.

The successful applicant will:

- have significant experience of dimensional modelling and database design

- ensure that enterprise data warehouse modelling standards are defined and agreed

- work collaboratively with project modellers, subject matter experts, project and delivery managers in the modelling and delivery of change to the EDW

- drive the alignment of project data models with the global enterprise model

- strive to deliver cost effective and highly performant BI database solutions

- work closely with change and release management teams for the deployment of change

- have Teradata experience, but training will be provided for an otherwise strong candidate

- have ERwin experience, or experience of a similar data modelling tool

- initially specialise in the physical and reporting (semantic) design aspects of the role.

- interact with resources across the globe.

- have leadership experience of a small team

The Modelling Lead will be located in Bangalore, will work closely with other EDW Modelling Leads in the UK and USA (and project modellers globally), and will report to the Global BI Data Model Manager. The EDW Team forms part of Global Data Services within the Information & Analytics function.

KEY ACCOUNTABILITIES/ DELIVERABLES

Accountable for defining, approving, documenting and communicating EDW standards

- Ensure that all enterprise data modelling standards are clearly and concisely documented, communicated, and adopted by the modelling community.

- Ensure that all new modellers joining the Programme understand the standards, working practices and criteria against which their designs will be judged.

- Ensure that the data modelling standards consider the impacts on the source systems, the network, the data model, and the Teradata system as a whole.

Accountable for reviewing and approving EDW model change and database design

- Work collaboratively with Project modellers to design appropriate dimensional models.

- Ensure that Project deliverables align with the EDW modelling standards.

- Ensure that design decisions result in highly efficient and scalable solutions, and align with the overall objectives and vision of the Connect Programme.

- Ensure that design solutions are appropriate for end user tools and ad-hoc reporting.

- Determine and agree actions to resolve any identified problems.

- Own and manage gate deliverables according to the Connect Programme delivery process, and report status to the Global BI Data Model Manager

- Ensure that related model validation, impact analysis, and physical environment comparison tools are effectively developed and maintained.

Architectural support

- Support changes to architectural standards and the alignment of data modelling standards.

- Support Company Security Policies - advising impacts on modelled data solutions.

Operational support

- This is not an operational role but where additional expertise is required then this role will be required to support the operational teams in resolving complex and critical issues impacting the Programme

KEY WORKING RELATIONSHIPS

Internal

- Global BI Data Model Manager

- Global EDW Model Leads

- Project Modellers and SMEs

- Project, Delivery and Release Managers

- Architecture Team

- Technical Design Authority

- Service Introduction: Change, Test and Release Management teams

External

- 3rd Party consultants: Project and Delivery Managers (global)

- 3rd Party consultants: Data Modellers and Delivery Teams (global)

- Teradata

- Sandhill Consultants / CA (ERwin data modelling toolset)

SKILLS, EXPERIENCE & KNOWLEDGE REQUIREMENTS

- Strong experience in dimensional modelling, data warehouse, and database design

- Strong experience with data modelling tools (ERwin preferred)

- Strong knowledge of physical database design and performance tuning (Teradata preferred)

- Ability to identify, create and communicate logical and physical design patterns and standards across a global community of data modellers

- Ability to perform change impact analysis e.g. schema comparison.

- Awareness of SAP ERP/ECC desirable

- Awareness of the SSRS, BODS, Tableau and TWS an advantage but not essential

- Knowledge of Excel macros, VBA and DOS scripting desirable (model validation and impact analysis tools)

- Ability to work with a global team

- Ability to coach modelling resources

- Ability to chair design review meetings and approve design decisions

- Ability to prioritise own work and the work of others, multi-task, and meet deadlines

- Excellent verbal and written communication skills

Standards of Leadership Required in This Role

Bias for action

- This is action-driven leadership: - This is what I will do.- It's speed and sense of urgency in making decisions. But it needs to be thoughtful action, intelligent risk-taking. Also it's not wasting time on bureaucracy - it's output that counts. And it's simplifying my agenda, carefully choosing priorities - and not taking on too much.

Accountability and Responsibility

- This is performance-driven leadership. - I will deliver against KPIs, holding myself to the highest standards.- I will also hold other people accountable - first by setting clear expectations and then by telling them if they are on the right path. It's staring reality in the eye - doing it with numbers. It's taking responsibility for overall performance, not just by delivering my results but by helping other people deliver their results. Finally, it's personally driving change and using operational discipline to deliver on the promise.

Building Talent and Teams

- This is people-driven leadership. It's passion for people. It's having the best people in the right positions, whatever the person's gender or background. It's giving people plenty of room to do their part, and recognizing them for their contributions. It's investing in people's development - giving them feedback and challenging work. It's also constantly challenging myself to grow and improve. And it's building aligned, cohesive teams that pull together to win.

IT Technical Skills (Specific to team)

Must have at a minimum the following skills:

- Enterprise Data Warehouse design

- Enterprise Data Warehouse governance

- Dimensional data modelling

- ERwin data modelling toolset

- ERwin model change impact assessment

- Teradata schema change impact assessment

- Teradata platform

General Skills

- Written and verbal communication

- Information management

- System development lifecycle

- IT testing, governance and strategy

Professional Skills

- Process design

- Team leadership

- Project management

- Change management

The Data Modelling Lead should:

Inspire through action - lead by example rather than words.

Challenge people to do their best work and will settle for nothing less.

Invest in people - coach individuals/teams to realize their full potential.

Drive effective teamwork - spot the links and connect the right people to create aligned teams and better solutions.

Always search for the best talent.

Value Indicators

- Technically competent person across a number of technologies, with significant competence in Enterprise Data Warehouse solutions

- Understanding of how multiple technologies overlap and interact

- Ability to work well with peers and demonstrate lateral influence

- Strong communication skills

- Delivery focus