The BI & Data Platform Administrator is responsible for building, maintaining, and evolving the organization’s Microsoft Fabric-based reporting warehouse. This role owns the end-to-end data platform lifecycle: data ingestion from Dynamics 365 F&O and connected systems, dimensional modeling, semantic model governance, and delivery of certified Power BI datasets to Finance, Operations, and Leadership. The role works closely with the Enterprise Application Specialist, Finance team, and business stakeholders to ensure the warehouse remains a reliable, governed, and scalable foundation for enterprise analytics and AI/Copilot readiness.

Education

Post-secondary diploma or degree in Computer Science, Data Analytics, Information Systems, or a related field or an equivalent combination of training and experience.

Experience

•5+ years of hands-on experience in business intelligence, data analytics, or a related role. •Demonstrated experience building Power BI reports and data models.

•Working knowledge of SQL.

•Working knowledge of Microsoft Fabric; used Fabric Lakehouse/Warehouse and pipelines for basic ingestion and reporting support; comfortable learning deeper administration/governance.

•5+ years of BI or data platform experience, ideally in a multi-entity or manufacturing environment. •Experience with Dynamics 365 F&O data structures or comparable ERP financial data.

•Experience delivering governed, production-grade BI outputs to Finance or executive stakeholders.

Certifications / Designations

•Microsoft Certified: Power BI Data Analyst Associate (PL-300) or equivalent demonstrated experience.

•Microsoft Certified: Fabric Analytics Engineer Associate (DP-600). Microsoft Certified: Azure Data

•Fundamentals. Microsoft Certified: Dynamics 365 Fundamentals (ERP).

Job-Specific Knowledge and Skills

•Strong working knowledge of Power BI: report authoring, DAX, semantic model design, and row-level security.

•Understanding of dimensional modeling principles (star schema, facts and dimensions).

•Familiarity with data ingestion and transformation concepts.

•SQL proficiency for querying structured data.

•Understanding of financial data structures: GL, AR, AP, Sales.

•Ability to translate business requirements into data models.

•Strong written and verbal communication skills

•Comfortable working with Finance and non-technical stakeholders.

•Able to work autonomously, manage priorities, and deliver quality outputs with minimal supervision.

Key Responsibility

Platform Operations & Health:

Monitor and maintain the Microsoft Fabric environment including Lakehouse/Warehouse environments, OneLake storage, and data pipelines.

Resolve ingestion failures, manage scheduled refresh cycles, and ensure certified datasets remain current and reliable.

Maintain and document all data connections from Dynamics 365 F&O via Synapse Link and other approved connectors.

Escalate infrastructure or capacity issues to IT leadership or the implementation partner as appropriate.

Dimensional Modeling & Semantic Model Maintenance:

•Maintain and extend dimensional models (fact and dimension tables) in the Gold layer of the Medallion Architecture -- FactGL, FactAR, FactAP, FactSales, and operational facts added in Phase 2.

•Author, publish, and version certified Power BI semantic models serving Finance, Operations, and Leadership.

•Apply and enforce row-level security, naming standards, and metric catalog definitions.

•Ensure models remain clean, intuitive, and documented so Finance and Operations users can self-serve without IT dependency.

Multi-Entity & M&A Integration:

Manage OneLake Shortcuts to integrate the full J&T entity portfolio without data duplication.

Support onboarding of acquired or new entities into the warehouse before ERP migration is complete.

Extend existing pipelines to accommodate new modules, entities, or data sources as the business grows across Canada, the US, Mexico, the UK, and the UAE.

Governance & Documentation

Enforce data governance standards: role-based access, refresh schedule documentation, metric catalog maintenance, naming conventions, and change management.

Maintain technical documentation for all warehouse components including pipeline lineage, model schemas, and data dictionaries.

Ensure the warehouse output meets Finance and Leadership reporting standards and supports audit-readiness across all entities.

AI & Copilot Readiness

Ensure semantic models are structured for AI and Copilot compatibility including clean hierarchies, conformed dimensions, complete business glossary, and certified datasets.

Support Copilot in Power BI deployments as the organization's AI maturity evolves.

Identify opportunities to automate variance narratives, executive summaries, and management reporting from live warehouse data.

Stakeholder Collaboration & Support

•Work closely with Finance, Operations, and Leadership stakeholders across all J&T entities to gather reporting requirements and translate them into warehouse enhancements.

•Provide guidance to end users on self-service reporting tools connected to the warehouse.

•Participate in IT and Finance reviews, contribute to the broader Microsoft platform roadmap, and liaise with the implementation partner or managed services provider during steady-state support.

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.