Reporting to the Data Architect Lead, Global Data Architect will take a lead role in creating the enterprise data model for McCain Foods, bringing together data assets across agriculture, manufacturing, supply chain and commercial. This data model will be the foundation for our analytics program that seeks to bring together McCain s industry-leading operational data sets, with 3 rd party data sets, to drive world-class analytics. Working with a diverse team of data governance experts, data integration architects, data engineers and our analytics team including data scientist, you will play a key role in creating a conceptual, logical and physical data model that underpins the Global Digital & Data team s activities. .
JOB RESPONSIBILITIES:
Develop an understanding of McCain s key data assets and work with data governance team to document key data sets in our enterprise data catalog
Work with business stakeholders to build a conceptual business model by understanding the business end to end process, challenges, and future business plans.
Collaborate with application architects to bring in the analytics point of view when designing end user applications.
Develop Logical data model based on business model and align with business teams
Work with technical teams to build physical data model, data lineage and keep all relevant documentations
Develop a process to manage to all models and appropriate controls
With a use-case driven approach, enhance and expand enterprise data model based on legacy on-premises analytics products, and new cloud data products including advanced analytics models
Design key enterprise conformed dimensions and ensure understanding across data engineering teams (including third parties); keep data catalog and wiki tools current
Primary point of contact for new Digital and IT programs, to ensure alignment to enterprise data model
Be a clear player in shaping McCain s cloud migration strategy, enabling advanced analytics and world-leading Business Intelligence analytics
Work in close collaboration with data engineers ensuring data modeling best practices are followed
MEASURES OF SUCCESS:
Demonstrated history of driving change in a large, global organization
A true passion for well-structured and well-governed data; you know and can explain to others the real business risk of too many mapping tables
You live for a well-designed and well-structured conformed dimension table
Focus on use-case driven prioritization; you are comfortable pushing business teams for requirements that connect to business value and also able to challenge requirements that will not achieve the business goals
Developing data models that are not just elegant, but truly optimized for analytics, both advanced analytics use cases and dashboarding / BI tools
A coaching mindset wherever you go, including with the business, data engineers and other architects
A infectious enthusiasm for learning: about our business, deepening your technical knowledge and meeting our teams
Have a get things done attitude. Roll up the sleeves when necessary; work with and through others as needed
KEY QUALIFICATION & EXPERIENCES:
Data Design and Governance
At least 5 years of experience with data modeling to support business process
Ability to design complex data models to connect and internal and external data
Nice to have: Ability profile the data for data quality requirements
At least 8 years of experience with requirement analysis; experience working with business stakeholders on data design
Experience on working with real-time data.
Nice to have: experience with Data Catalog tools
Ability to draft accurate documentation that supports the project management effort and coding
Technical skills
At least 5 years of experience designing and working in Data Warehouse solutions building data models; preference for having S4 hana knowledge.
At least 2 years of experience in visualization tools preferably Power BI or similar tools. e
At least 2 years designing and working in Cloud Data Warehouse solutions; preference for Azure Databricks, Azure Synapse or earlier Microsoft solutions
Experience Visio, Power Designer, or similar data modeling tools
Nice to have: Experience in data profiling tools informatica, Collibra or similar data quality tools
Nice to have: Working experience on MDx
Experience in working in Azure cloud environment or similar cloud environment
Must have : Ability to develop queries in SQL for assessing , manipulating, and accessing data stored in relational databases , hands on experience in PySpark, Python
Nice to have: Ability to understand and work with unstructured data
Nice to have at least 1 successful enterprise-wide cloud migration being the data architect or data modeler. - mainly focused on building data models.
Nice to have: Experience on working with Manufacturing /Digital Manufacturing.
Nice to have: experience designing enterprise data models for analytics, specifically in a PowerBI environment
Nice to have: experience with machine learning model design (Python preferred)
Behaviors and Attitudes
Comfortable working with ambiguity and defining a way forward.
Experience challenging current ways of working
A documented history of successfully driving projects to completion