Data Architect Fabric Platform Lead

ADP, Inc.; Mississauga; Vor Ort; CAD 132.000 - 140.000; Vollzeit

Benefits dieser Stelle

Health benefits

Discount program on coffee/tea

Safety Shoes Program

Tuition Assistance

Zusammenfassung

Mother Parkers Tea & Coffee is seeking a Data Architect & Fabric Platform Lead to define enterprise data architecture and govern the Microsoft Fabric ecosystem. You will lead modernization, mentor teams, and partner with business and technology groups to deliver scalable data solutions.

The role focuses on strategic design for OneLake, Lakehouse, Data Warehouse, and AI-ready data foundations, with emphasis on governance, performance, and cost optimization.

Qualifikationen

• Bachelor's degree in a technical field or equivalent experience.

Aufgaben

• Own the enterprise data architecture roadmap and Microsoft Fabric platform strategy.
• Translate business requirements into scalable target-state architectures, solution designs, and implementation roadmaps.
• Design and govern OneLake, Lakehouse, Data Warehouse, Medallion Architecture, Data Pipelines, Semantic Models, and enterprise data products.
• Architect and support enterprise data platforms enabling reporting, analytics, automation, and AI initiatives.
• Define and implement CI/CD, deployment automation, source control, and environment management using Azure DevOps and Fabric deployment capabilities.
• Establish data engineering standards, governance, and best practices across BI.
• Define data quality, security, metadata, lineage, and lifecycle management standards.
• Manage Fabric and Azure utilization, capacity planning, performance monitoring, and cloud cost optimization.

Kenntnisse

Fabric

Azure

Data Arch

Power BI

Python

Spark

T-SQL

ETL/ELT

CI/CD

Notebooks

Ausbildung

Bachelor's degree

Tools

Azure DevOps

OneLake

Lakehouse

Power BI

Jobbeschreibung

We are one of the largest tea and coffee manufacturers in North America, with a mission to create a better beverage experience for our customers. As a leading customer solutions provider to some of North America's largest retailers and foodservice chains, we use state-of-the-art technology and new product innovation to help our customers grow their business and deliver superior products to their clientele. Our team of coffee and tea experts are deeply passionate about what we do, proud of our 100+ years of business success, and excited about building a future with endless possibilities. Come join our team and work among the best, collaborate with high performers, and contribute to challenging work every day!

The Role:

Reporting to the Senior Manager - BI Analytics & Applied AI, the Data Architect & Fabric Platform Lead is responsible for defining and governing the enterprise data architecture and Microsoft Fabric platform. This role provides technical leadership for data engineering, platform modernization, governance, and solution design, ensuring scalable, secure, and reliable data foundations that support reporting, analytics, AI, and business decision-making.

The position will lead the evolution of Mother Parkers' Microsoft Fabric ecosystem, establish enterprise architecture standards, drive modernization initiatives, and mentor technical resources while partnering with business and technology teams to deliver high-quality data solutions. The role is accountable for the Data Engineering & Platform capability within the BI organization.

What you get to do:

• Own the enterprise data architecture roadmap and Microsoft Fabric platform strategy.
• Translate business requirements into scalable target-state architectures, solution designs, and implementation roadmaps.
• Design and govern OneLake, Lakehouse, Data Warehouse, Medallion Architecture (Bronze, Silver, Gold), Data Pipelines, Semantic Models, and enterprise data products.
• Architect and support enterprise data platforms that enable reporting, analytics, automation, and AI initiatives.
• Design and govern parameterized ingestion frameworks supporting batch, incremental, and near real-time integrations from databases, APIs, files, ERP systems, and other enterprise applications.
• Optimize data pipeline, semantic model, and query performance through modern engineering practices, partitioning strategies, incremental loading, Direct Lake architecture, and scalable design patterns.
• Define and implement CI/CD, deployment automation, source control, and environment management practices using Azure DevOps and Microsoft Fabric deployment capabilities.
• Establish data engineering standards, reusable frameworks, technical governance processes, and best practices across the BI organization.
• Define and enforce standards for data quality, security, metadata management, lineage, documentation, data dictionary, and lifecycle management.
• Manage Microsoft Fabric and Azure platform utilization, capacity planning, performance monitoring, and cloud cost optimization.
• Support data governance, cybersecurity, compliance, and enterprise architecture initiatives across the analytics landscape.
• Define and govern AI-ready data architectures that support Machine Learning, Generative AI, Copilot, and enterprise AI initiatives.
• Provide architecture guidance for AI, advanced analytics, and data science workloads to ensure scalability, governance, and security.
• Establish technical standards for reusable AI-ready datasets and enterprise data products.
• Lead architecture reviews, code reviews, technical mentoring, and knowledge-sharing initiatives across data engineering and analytics teams.
• Partner with business stakeholders, BTS teams, and solution leads to ensure technical solutions align with business objectives and enterprise standards.
• Evaluate emerging technologies and recommend innovative approaches that improve scalability, governance, automation, and business value.
• Drive modernization efforts, including migration and optimization of legacy BI, database, and integration solutions into Microsoft Fabric.

What you bring to the role:

• Bachelor’s degree in computer science, Information Technology, Software Engineering, Data Engineering, Information Systems, or a related discipline or equivalent.
• 7+ years of experience in Data Architecture, Data Engineering, Data Warehousing, Business Intelligence, or related disciplines.
• Minimum 2-3 years of experience serving as a Data Architect, Technical Lead, or Senior Data Engineering Lead.
• Proven experience designing and implementing enterprise-scale cloud data platforms.
• Experience leading architecture initiatives, platform modernization programs, and technical teams.
• Experience working within Agile, Scrum, Kanban, or hybrid delivery methodologies.
• Experience within Consumer-Packaged Goods (CPG), Manufacturing, Supply Chain, Procurement, or ERP-driven environments is strongly preferred.
• Expert knowledge of Microsoft Fabric, OneLake, Lakehouse, Warehouse, Data Pipelines, Notebooks, Semantic Models, and modern cloud data platforms.
• Deep understanding of Medallion Architecture, Data Warehousing, Lakehouse concepts, and cloud-native data architecture patterns.
• Proficiency in T-SQL, SSIS/DTS packages, relational databases, and enterprise data modeling.
• Strong hands-on experience with Python, Spark/PySpark, REST APIs, and modern data engineering practices.
• Strong knowledge of database, ETL, ELT, and reporting performance tuning methodologies.
• Experience preparing, transforming, and modeling data for Business Intelligence and Analytics solutions.
• Advanced Power BI development skills including Power Query, M Query, DAX, Semantic Models, Direct Lake, Import Models, aggregations, and star schema design.
• Strong understanding of Data Governance, Data Quality, Master Data Management, Metadata Management, Security, and Data Lineage principles.
• Experience managing Azure and Fabric capacity utilization, performance, and cost optimization strategies.
• Experience implementing CI/CD pipelines, source control, release management, and deployment automation using Azure DevOps.
• Understanding of AI, Machine Learning, Large Language Models (LLMs), Retrieval-Augmented Generation (RAG), Copilot architecture, and enterprise AI data foundations.
• Experience designing and supporting data architectures that enable AI, predictive analytics, and advanced analytics initiatives.
• Experience leading architecture reviews, technical design reviews, code reviews, and mentoring technical resources.
• Strong analytical, problem-solving, communication, and documentation skills.
• Ability to manage multiple priorities and thrive in a fast-paced, dynamic environment.
• Understanding of ERP concepts and practical experience with Dynamics 365 and/or CRM is considered a strong asset

What we offer you:

• Competitive Total Rewards package - health benefits coverage on day 1, employer matched retirement savings plans, optional Health or Wellness Spending Accounts.
• Employee discount program on our coffee and tea products.
• Annual Safety Shoes Program - your safety is our #1 priority.
• Tuition Assistance Program - we value continuous learning and self-development.
• The hiring range for this role is $132,000 - $140,000.

This posting is for an existing/new vacancy.

We use AI enabled tools to support parts of our selection process; however, every hiring decision is reviewed and finalized by our people.

While Mother Parkers welcomes all applications, we do not accept unsolicited resumes from employment agencies or search firms. Only those candidates who meet the minimum requirements will be contacted. Mother Parkers is committed to providing accommodation for persons with disabilities. Accommodation is available on request for candidates taking part in all aspects of the selection process.