Data Architect

**Position Title**:Data Architect

**Position Type**: Regular - Full-Time

**Position Location**: Gurgaon

**Grade**: Grade 06

**Requisition ID**: 28876

**McCain Foods**

McCain Foods Limited is a Canadian multinational frozen food company established in 1957 in Florenceville, New Brunswick, Canada. It is the world's largest manufacturer of frozen potato products.As a privately owned family company with over 65 years of experience, a presence in over 160 countries and a global team of 20,000+ people, our values and culture are at the heart of everything we do. Our product quality, people and customer dedication help us achieve global sales in excess of CDN $11 billion

**Job Location: Gurgaon**

**JOB DESCRIPTION**

**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.
- 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 up to date.
- 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 Data & Analytics 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; comfortable driving business teams for opportunities that connect to 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.
- An 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 o 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 o 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.
- At least 2 years designing and working in Cloud Data Warehouse solutions; preference for 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
- McCain Foods is an equal opportunity employer. We see value in ensuring we have a diverse, antiracist, inclusive, merit-based, and equitable workplace. As a global family-owned 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 ac