Data Architect

McCain Foods

  • Florenceville-Bristol, NB
  • $85,500-114,000 per year
  • Permanent
  • Full-time
  • 20 hours ago
Position Title: Data ArchitectPosition Type: Regular - Full-Time ​Position Location: Florenceville GTCGrade: Grade 05Requisition ID: 38058In every role, McCainers are ambitious, curious, and passionate about creating exceptional work experiences - together. With a customer-first mindset, we make doing business with McCain easy.About the role.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 3rd 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.What you’ll be doing.Develop an understanding of McCain’s key data assets and work with data governance team to document key data sets in our enterprise data catalogWork 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 teamsWork with technical teams to build physical data model, data lineage and keep all relevant documentationsDevelop a process to manage to all models and appropriate controlsWith 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 modelsDesign key enterprise conformed dimensions and ensure understanding across data engineering teams (including third parties); keep data catalog and wiki tools currentPrimary point of contact for new Digital and IT programs, to ensure alignment to enterprise data modelBe a clear player in shaping McCain’s cloud migration strategy, enabling advanced analytics and world-leading Business Intelligence analyticsWork in close collaboration with data engineers ensuring data modeling best practices are followedWhat you’ll need to be successful.Demonstrated history of driving change in a large, global organizationA true passion for well-structured and well-governed data; you know and can explain to others the real business risk of too many mapping tablesYou live for a well-designed and well-structured conformed dimension tableFocus 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’ goalsDeveloping data models that are not just elegant, but truly optimized for analytics, both advanced analytics use cases and dashboarding / BI toolsA coaching mindset wherever you go, including with the business, data engineers and other architectsA infectious enthusiasm for learning: about our business, deepening your technical knowledge and meeting our teamsHave a “get things done” attitude. Roll up the sleeves when necessary; work with and through others as neededKey Qualifications and experienceData Design and GovernanceAt least 5 years of experience with data modeling to support business processAbility to design complex data models to connect and internal and external dataNice to have: Ability profile the data for data quality requirementsAt least 8 years of experience with requirement analysis; experience working with business stakeholders on data designExperience on working with real-time data.Nice to have: experience with Data Catalog toolsAbility to draft accurate documentation that supports the project management effort and codingTechnical skillsAt 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.eAt least 2 years designing and working in Cloud Data Warehouse solutions; preference for Azure Databricks, Azure Synapse or earlier Microsoft solutionsExperience Visio, Power Designer, or similar data modeling toolsNice to have: Experience in data profiling tools informatica, Collibra or similar data quality toolsNice to have: Working experience on MDxExperience in working in Azure cloud environment or similar cloud environmentMust have : Ability to develop queries in SQL for assessing , manipulating, and accessing data stored in relational databases , hands on experience in PySpark, PythonNice to have: Ability to understand and work with unstructured dataNice 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 environmentNice to have: experience with machine learning model design (Python preferred)Behaviors and AttitudesComfortable working with ambiguity and defining a way forward.Experience challenging current ways of workingA documented history of successfully driving projects to completionExcellent interpersonal skillsAttention to the details.Good interpersonal and communication skillsComfortable leading others through changeKey Competencies:Drives Results, Collaboration, Customer focusAbout McCain.to learn more about McCain and how we provide you with opportunities to make an impact that matters.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.At McCain, our leadership principles guide how we engage with customers, collaborate as a team, and achieve success. We focus on understanding customer needs, driving innovation, empowering people, and taking ownership to clear obstacles and deliver results.The McCain experience.We are McCain. This statement is a testament to our collective strength and our individual value. Your contributions play a vital role in our success. Our winning culture is rooted in authenticity and trust, empowering us to bring out the best in one another. Here, you’ll find opportunities to learn, grow, and thrive. Join us and experience why we’re better together.Our purpose is grounded in building meaningful relationships. We’re big believers in the power of working together in person—it helps us stay connected, collaborate more effectively, and grow as a team. At the same time, we recognize the importance of flexibility. Most office-based roles follow a hybrid model, with the option to work remotely two days a week. There may be exceptions depending on the role and location, so we encourage you to speak with your recruiter for more details.#LI-HYBRIDCompensation Package: $85,500.00 - $114,000.00 . CAD annually + Bonus EligibilityThe 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 and training, and other organizational needs.Benefits: At McCain, we’re on a mission to create a winning culture that puts employee safety and well-being at the heart of what we do, every day. We understand and appreciate that each person’s needs are unique and ensure our benefits & well-being programs reflect that. Employees are eligible for the following benefits: health coverage (medical, dental, vision, prescription drug), retirement savings benefits, and leave support including medical, family and bereavement. Well-being programs include vacation and holidays, company-supported volunteering time, and mental health resources. Coverages are aligned with country, provincial and state governing plans and can vary by work level, location and nature of the role. Additional benefit detail available during the application process.Your well-being matters to us, and we’re 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. As a global family-owned company, we strive to be the employer of choice in the diverse communities around the world in which we live and work. We recognize that inclusion drives our creativity, resilience, and success and makes our business stronger. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, age, veteran status, disability, or any other protected characteristic under applicable law.McCain is an accessible employer. If you require an accommodation throughout the recruitment process (including alternate formats of materials or accessible meeting rooms), please , and we will work with you to find appropriate solutions.Your privacy is important to us. By submitting personal data or information to us, you agree that this will be handled in accordance with and , as applicable. You can understand how your personal information is being handled .Job Family: Information Technology
Location(s): CA - Canada : New Brunswick : Florenceville-BristolCompany: McCain Foods (Canada)

McCain Foods