Nirav Makwana
Senior Data Engineer Technical Lead @Metrolinx
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Engineer Technical Lead @Metrolinx
Toronto, ON, CA
Led a data engineering team and partnered with Microsoft, Databricks, Accenture, CGI, and Moneris to deliver scalable cloud data solutions and modernize enterprise cloud data platforms.Designed, developed, and optimized large-scale data pipelines using Azure Data Factory with batch processing for fare collection and transit operations across Ontario.Collaborated with Microsoft architects and engineers to redesign PRESTO’s enterprise BI architecture, defining a future-state solution leveraging the latest Azure services, including Synapse Analytics, Microsoft Fabric, Power BI, and Databricks for a modern, scalable, and integrated data ecosystem.Integrated Apple Wallet and Google Wallet data into the PRESTO BI data warehouse, enabling comprehensive transaction reporting and analytics across all major Ontario transit agencies.Led data integration efforts for PRESTO smart cards and debit/credit card tap payments, supporting multi-model fare reconciliation and operational insights.Built and managed a secure AI/ML workspace in Azure, provisioning compute clusters and managing user access to support data scientists with scalable and compliant infrastructure for model development.Migrated legacy reporting systems from Azure Analysis Services (AAS) to Microsoft Fabric (Power BI) in partnership with Microsoft Cloud Migration Factory (CMF), improving performance, manageability, and cost efficiency.Azure DevOps CI/CD pipelines to automate data pipeline deployment, improving reliability and reducing manual work.Led a Delta Lake-based data Lakehouse POC, unifying streaming and batch workloads to enhance query performance.Monitored and optimized cloud data workloads, leveraging workload scheduling and query tuning to achieve a 20% reduction in compute costs.Data privacy and compliance by implementing (RBAC) role based access controls and data masking, ensuring secure handling of PII in line with the data governance standards.
EDUCATION
St. Lawrence
Secondary School Certificate, science, maths, history, geography,etc...
Ivey Business School at Western University
Certification of Entrepreneurial Process - The Founder's Journey, Entrepreneurship/Entrepreneurial Studies
University of Mumbai
Bachelor’s Degree, Computer Science Engineering
Naval Institute of Technology
Diploma in Computer Science Engineering, Computer Science Engineering
SKILLS
ABOUT NIRAV MAKWANA
Experienced professional with a strong background in development, design, data analysis, migration, implementation, and testing. Specialized in ETL/ ADF pipelines for data migration and data warehousing ecosystems, I design and optimize scripts for loading incremental DataMarts using CDC techniques.I bring hands-on expertise across all data lifecycle phases, including Extraction, Transformation, Loading, Ingestion, Analytics, and Visualization. Proficient in Dimensional Data modeling with Star and Snow Flake schema, I excel in performance tuning and index creation for enhanced database access.A practitioner of Agile development, I have successfully delivered complex Data Warehouse (DWH) and database solutions. My skills include migrating data from Oracle, MySQL, and MS SQL Server databases to Azure Cloud Database. Additionally, I possess knowledge of report development using business intelligence tools like Cognos and Power BI.Passionate about contributing to data-driven success, I am eager to explore collaborative opportunities in the dynamic realm of data management and analytics.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.