Data Architect 34270

Position Title: Data Architect

Position Type: Regular FullTime

Position Location: Florenceville GTC

Requisition ID:34270

At McCain our Digital Technology team is dedicated to leveraging technology and data to drive profitable growth enhance customer experience and further our purpose of Celebrating real connections through delicious planetfriendly food. We have embarked on an ambitious digital transformation journey that spans our entire business from Agriculture to Manufacturing all with a focus on deepening our customer obsession.

As part of this transformation we are making substantial investments in digital platforms technology advancements and fostering a datadriven culture. Our goal is to develop digital products that serve our customers suppliers/growers and McCain team members enabling digital processes and datadriven automation. Through these investments we aim to transform McCain into a company that empowers its teams with intuitive systems designed to enhance collaboration productivity and informed decisionmaking.

Are you ready to be part of this exciting journey Join us and help shape the future of McCain through innovative technology solutions.

Leadership Principles.

Our principles each with related practices guide our actions across the organization. Together they address how McCain interacts with our customers and employees and how we work as individuals and collectively to find success. While each role adheres to the Leadership Principles individual roles may focus more on a specific principle or principles.

• We are customer obsessed. Customers are our starting point. By understanding their needs and leveraging data and consumer insights we drive mutual success.
• We think big and plan ahead. Through ambition curiosity and smart risks we can accomplish goals refine processes and innovate to scale success.
• We bring out the best in our people. We create safe spaces for our people so that trust and empowerment come naturally. Inclusion is about listening first showing humility and working together.
• We act like owners. Together we clear obstacles and do the work that makes us all successful and proud to be part of McCain.

We have a new and ambitious global Digital & Data group which serves as a resource to the business teams in our regions and global functions. We are currently recruiting an experienced Data Architect to build enterprise data model McCain.

JOB PURPOSE:

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 McCains industryleading operational data sets with 3rd party data sets to drive worldclass 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 teams activities. .

JOB RESPONSIBILITIES:

• Develop an understanding of McCains 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 usecase driven approach enhance and expand enterprise data model based on legacy onpremises 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 McCains cloud migration strategy enabling advanced analytics and worldleading 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 wellstructured and wellgoverned data; you know and can explain to others the real business risk of too many mapping tables
• You live for a welldesigned and wellstructured conformed dimension table
• Focus on usecase 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 realtime 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 enterprisewide 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
  • Excellent interpersonal skills
  • Attention to the details.
  • Good interpersonal and communication skills
  • Comfortable leading others through change

Key Competencies:

• Drives Results Collaboration Customer focus

The above information indicates the general nature and level of work performed by employees within this classification. It is not a comprehensive inventory of all duties responsibilities and qualifications required of employees assigned to this job.

#LIHYBRID

Compensation Package:$85500.00$114000.00CAD annually bonuseligibility

The above reflects the target compensation range for the position at the time of posting. Hiring compensation will be determined based on experience skill set education/training and other organizational needs.

Benefits: At McCainwere on a mission to create a winning culture that puts employee safety and wellbeing at the heart of what we do every day. We understand and appreciate that each persons needs are unique and ensure our benefits & wellbeing programs reflect that. Employeesare eligible for the following benefits:health coverage (medical dental vision prescription drug) retirement savings benefits and leave support including medical family and bereavement. Wellbeing programs include vacationandholidays companysupported volunteering time and mental health resources. Coverages are aligned to country provincial and state governing plans and can vary by work level location and nature of the role.Additional benefit details available during the application process.

Your wellbeing matters to us and were here to provide you with the necessary resources to support you in being your best self at work and at home.

McCain Foods is an equal opportunity employer. We see value in ensuring we have a diverse antiracist inclusive meritbased and equitable workplace. As a global familyowned company we are proud to reflect the diverse communities around the world in which we live and work. We recognize that diversity drives our creativity resilience and success and makes our business stronger.

McCain is an accessible employer. If you require an accommodation throughout the recruitment process (including alternate formats of materials or accessible meeting rooms) please let us know and we will work with you to meet your needs.

Your privacy is important to us. By submitting personal data or information to us you agree this will be handled in accordance with the Global Privacy Policy

Job Family:Information Technology
Division:Global Digital Technology
Department:Data Architect
Location(s): CA Canada : New Brunswick : FlorencevilleBristol
CA Canada : Ontario : Toronto

Company:McCain Foods (Canada)