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.
- Experience designing scalable data ingestion frameworks supporting structured, semi-structured, and enterprise application data sources.
- 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 of 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.
