Professional Background

Mohit Mendi

Senior Data Engineering Specialist — Data Analytics, BI & Cloud Architecture

Toronto, ON  ·  +1 (249) 359-7570  ·  mohit@mendicorp.ca

This page provides professional context for consulting engagements, partnerships, and professional opportunities. For MendiCorp services and business inquiries, please visit the main site.
7+
Years Experience
5+
Industry Environments
Cloud
Data Platforms & BI
Gov
Enterprise & Public Sector

Summary

Senior Data Engineering Specialist and Analytics Consultant with 7+ years of experience delivering enterprise-grade data platforms, semantic models, governance frameworks, and cloud analytics solutions across municipal government, healthcare, regulated retail, medical education, entertainment, and enterprise environments. Currently leading Microsoft Fabric implementation, platform governance, Synapse migration assessment, cross-divisional data engineering, reporting modernization, and analytics delivery in a Canadian municipal environment. Deep hands-on expertise spans Microsoft Fabric, Azure Synapse, Databricks, Unity Catalog, Power BI, Snowflake, Python, PySpark, Azure DevOps, and modern medallion/lakehouse architecture.

Current Focus

Microsoft Fabric Implementation

Tenant readiness, workspace architecture, medallion design, pipelines, notebooks, capacity governance, and Dev→Prod delivery.

Platform Modernization

Synapse migration assessment, lakehouse modernization, architecture simplification, and right-sizing platform cost.

Reporting Modernization

Report-sprawl reduction, slow-report optimization, semantic model consolidation, KPI standardization, and automation.

Databricks Governance

Unity Catalog structure, ownership, access patterns, lineage, and scalable governance across shared data environments.

Security & Governance

Service principals, RLS, workspace identities, sensitivity controls, deployment governance, and audit-friendly design.

Cross-Divisional Analytics

Integrating heterogeneous operational systems into governed data products for executive and operational decision-making.

Core Skills & Expertise

Reporting & Visualization

Executive dashboards, KPI frameworks, self-service BI, paginated reports, embedded analytics, stakeholder storytelling

Data Engineering

Medallion architecture, ETL/ELT pipelines, PySpark, SQL, schema drift handling, data quality frameworks, Delta Lake

Semantic Modeling

Star schema design, DAX measure libraries, Power Query (M), RLS design, certified datasets, conformed dimensions

Cloud Platforms

Microsoft Fabric, Azure Synapse, Databricks, Unity Catalog, Azure Data Factory, OneLake, Snowflake, AWS

Governance & Strategy

Workspace governance, Unity Catalog, service principals, RLS, sensitivity controls, deployment pipelines, Purview, lineage and access strategy

Delivery & Leadership

Stakeholder engagement, requirements gathering, architecture advisory, agile delivery, cross-functional team collaboration

Professional Experience

Region of Durham — CSIT, Data Analytics
Senior Data Engineering Specialist
Municipal Government
Whitby, ON
Jun 2026 – Present
  • Leading end-to-end Microsoft Fabric environment implementation including medallion architecture, workspace design, capacity governance, deployment pipelines, and production delivery patterns.
  • Architecting cross-divisional analytics that integrates 10+ operational source systems into governed Bronze and Silver layers for executive and operational reporting.
  • Established Azure DevOps boards, Git integration, work-item tracking, and delivery standards used by the analytics team for day-to-day platform work.
  • Leading Synapse migration assessment and reporting modernization, including report-sprawl reduction, performance improvement, and automation of manual reporting processes.
  • Working on Databricks Unity Catalog setup and governance patterns for controlled data access, ownership, lineage, and scalable administration.
  • Designing service-principal, workspace identity, data access, and governance strategies aligned with municipal security and compliance requirements.
Keyrus Canada
Senior Data Consultant
Consulting
Toronto, ON
May 2025 – Feb 2026
  • Niagara Health System: architected Microsoft Fabric Lakehouse solutions using Bronze/Silver/Gold patterns, Dataflows Gen2, PySpark, Delta Lake, semantic models, RLS, and governed Dev→Test→Prod delivery.
  • Optimized Fabric Lakehouse and Power BI performance using compaction, pruning, incremental refresh, and aggregation strategies, improving query performance by up to 30%.
  • AAMC: consolidated fragmented Tableau data sources into governed Power BI semantic models, reducing dataset sprawl by 40% and accelerating cross-dashboard development by 25%.
  • Implemented RLS, workspace governance, incremental refresh, aggregation tables, and reusable parameterization for scalable reporting cycles.
Ontario Cannabis Store (OCS)
Senior Data Analyst — Reporting & Modern Data Platforms
Crown Corporation
Toronto, ON
Feb 2022 – Apr 2024
  • Modernized enterprise reporting for an Ontario Crown corporation, supporting compliance, supply chain, retail, and operational decision-making.
  • Designed and maintained Power BI dashboards, datasets, paginated reports, and KPI frameworks for leadership and business teams.
  • Led transition from legacy SQL toward a modern Azure data platform using Databricks and SQL pipelines, reducing data-processing load times by 30%.
  • Implemented workflow automation to streamline approvals and refresh processes, improving audit readiness and reducing manual effort.
  • Collaborated with stakeholders and vendors to improve data integrity, decreasing discrepancies by 25% across regulated reporting streams.
Mirvish Productions
Data Analyst — Reporting & Audience Insights
Arts & Entertainment
Toronto, ON
Apr 2021 – Jan 2022
  • Built audience analytics dashboards tracking ticket sales, demographic patterns, show performance, and marketing ROI for Canada's premier theatre producer.
  • Supported strategic pricing, promotional, and seasonal scheduling decisions through forecasting models and performance trend analysis.
NTT Data Services
Software Dev Sr Associate — BI & Reporting
Enterprise Tech
Bangalore, India
Sep 2018 – Dec 2019
  • Built and optimized SQL reporting datasets and automated reporting solutions for senior stakeholders across enterprise client accounts.
  • Delivered operational dashboards and improved report performance through query tuning and standardization initiatives.
Zippr
SQL BI Analyst — Reporting & Performance Metrics
Analytics
Hyderabad, India
Jan 2017 – Sep 2018
  • Developed KPIs, dashboards, and automated workflows integrating multi-source data to improve reporting reliability and leadership visibility.

Education

B.Tech — Computer Science

GITAM University

PG — Big Data Analytics & AI

Georgian College

PG — Artificial Intelligence

Durham College

Certifications

🏅
Microsoft DP-600
Fabric Analytics Engineer Associate
🏅
Microsoft PL-300
Power BI Data Analyst Associate
🤖
UiPath RPA
Certified RPA Developer
🤖
Blue Prism
Certified Developer
🤖
Automation Anywhere
Certified RPA Developer
☁️
Azure & Fabric
Microsoft Cloud Data Ecosystem

Let's Connect

If you're evaluating my background for a role, engagement, or partnership — I'd love to talk.

📞 Call / Text ✉️ Email 💼 LinkedIn ← Main Site

© MendiCorp Services Inc. · North York, Toronto, Ontario · mendicorp.ca