I am Ammar Vahora, a Marketing Analytics Strategist with a passion for turning data into measurable growth. I specialize in web analytics, paid media, and data-driven decision making, helping teams optimize campaigns and improve conversions and engagement. I enjoy building clear, actionable storylines from complex datasets and delivering dashboards that empower executives and cross-functional partners to act quickly. In my roles at AGF Investments, SPC Student Price Card, and ERIS, I built scalable data solutions, automated reporting, and collaborated across marketing, product, and engineering to elevate user experience and ROI. I love translating insights into practical improvements and teaching others how to leverage data tools effectively.

Ammar Vahora

I am Ammar Vahora, a Marketing Analytics Strategist with a passion for turning data into measurable growth. I specialize in web analytics, paid media, and data-driven decision making, helping teams optimize campaigns and improve conversions and engagement. I enjoy building clear, actionable storylines from complex datasets and delivering dashboards that empower executives and cross-functional partners to act quickly. In my roles at AGF Investments, SPC Student Price Card, and ERIS, I built scalable data solutions, automated reporting, and collaborated across marketing, product, and engineering to elevate user experience and ROI. I love translating insights into practical improvements and teaching others how to leverage data tools effectively.

Available to hire

I am Ammar Vahora, a Marketing Analytics Strategist with a passion for turning data into measurable growth. I specialize in web analytics, paid media, and data-driven decision making, helping teams optimize campaigns and improve conversions and engagement. I enjoy building clear, actionable storylines from complex datasets and delivering dashboards that empower executives and cross-functional partners to act quickly.

In my roles at AGF Investments, SPC Student Price Card, and ERIS, I built scalable data solutions, automated reporting, and collaborated across marketing, product, and engineering to elevate user experience and ROI. I love translating insights into practical improvements and teaching others how to leverage data tools effectively.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Language

Afar
Advanced

Work Experience

Data Analyst | Data Strategist at AGF Investments Inc.
November 1, 2024 - Present
Connected Salesforce data to Tableau and used Tableau Pulse to generate AI-powered insights, reducing weekly manual reporting by 20%. Imported and transformed data from SQL Server into Power BI to create real-time financial and sales dashboards for executive decision-making. Built SQL queries and ETL pipelines in SQL Server for real-time analytics. Developed stored procedures and views to streamline recurring data extraction. Collaborated with stakeholders to translate business requirements into technical specs for the data engineering team. Advised cross-functional teams on reporting methods and interpretation of analytics, identified issues, performed root cause analysis, and improved data reliability. Unified reporting across Salesforce, Pardot, and Google Analytics to track full-funnel performance. Built and optimized Google Ads campaigns, with weekly rebalancing leading to a 15% monthly increase in conversions.
Data Integration Analyst | Digital Analyst at SPC (Student Price Card)
November 30, 2024 - September 23, 2025
Automated Excel reports using VBA/macros, reducing manual work by 30%. Created MoM, YoY, and QoQ spend graphs in Excel using v-lookups and categorized data. Developed real-time Power BI dashboards using multi-source financial data. Applied Agile methods to accelerate project delivery and improve collaboration. Launched digital marketing campaigns with a 25% ROI lift through strategy and tool optimization. Improved UX and drove 20% more engagement by executing a digital customer experience strategy. Led targeted email campaigns from strategy through execution and stakeholder coordination. Used SEO and tracking tools to analyze customer journeys and optimize conversion.
Data Analyst at ERIS (Environmental Risk Information Services)
February 28, 2023 - September 23, 2025
Managed a database of over two million entries, performing data conversion, cleaning, and string manipulation using Regular Expressions. Developed and executed SQL stored procedures to perform Extract, Transform, Load (ETL) operations. Extensively used joins, CTEs, table variables, global and local temp tables to merge and transform tables into production. Implemented data pipelines and ETL workflows to efficiently aggregate and process large volumes of digital data. Created graphs and reports using ggplot2 in RStudio for analytical modeling. Provided insights from multiple sources to drive business planning and strategy. Facilitated training for new hires, promoting rapid acclimation and efficiency in task execution.
Data Analyst / Data Strategist at AGF Investments Inc.
November 1, 2024 - Present
Connected Salesforce data to Tableau and utilized Tableau Pulse to generate AI-powered insights, reducing manual reporting by 20% weekly. Imported and transformed data from SQL Server into Power BI to create real-time financial and sales dashboards, supporting executive-level decision-making. Built SQL queries and ETL pipelines in SQL Server for real-time analytics. Developed stored procedures and views to streamline recurring data extraction tasks. Partnered with stakeholders to identify data needs and translate business requirements into technical specifications for the data engineering team. Advised cross-functional teams on reporting methods and helped interpret analytics insights. Identified reporting issues, conducted root cause analysis, and improved data reliability. Unified reporting across Salesforce, Pardot, and Google Analytics to track full-funnel performance. Built and optimized Google Ads campaigns; weekly rebalancing led to a 15% monthly increase in conversions.
Data Integration Analyst / Digital Analyst at SPC (Student Price Card)
November 1, 2024 - September 23, 2025
Automated Excel reports using VBA/macros, reducing manual work by 30%. Created MoM, YoY, and QoQ spend graphs in Excel using v-lookup and categorized data. Developed real-time Power BI dashboards using multi-source financial data. Applied Agile methods to accelerate project delivery and improve collaboration. Launched digital marketing campaigns with a 25% ROI lift through strategy and tool optimization. Improved UX and drove 20% more engagement by executing a digital customer experience strategy. Led targeted email campaigns from strategy through execution and stakeholder coordination. Used SEO and tracking tools to analyze customer journeys and optimize conversion.
Data Analyst at ERIS (Environmental Risk Information Services)
February 1, 2023 - September 23, 2025
Managed a database of over two million entries, performing data conversion, cleaning, and string manipulation using Regular Expressions. Developed and executed SQL stored procedures to perform ETL operations. Extensively used joins, CTEs, table variables, global and local temp tables to merge and transform tables into production. Implemented data pipelines and ETL workflows to efficiently aggregate and process large volumes of digital data. Created graphs and reports using ggplot2 in RStudio for analytical modeling. Provided insights from multiple sources to drive business planning and strategy. Facilitated training for new hires, promoting rapid acclimation and efficiency in task execution.
Marketing Analytics Strategist at AGF Investments Inc.
November 1, 2024 - October 30, 2025
Led web analytics and campaign optimization, driving a 15% increase in monthly subscriptions and a 15% uplift in conversions and CTR through GA4, GTM, and Google Ads. Validated event tracking with developers to ensure clean data pipelines. Executed on-page SEO improvements and collaborated with content teams to boost organic traffic by 20%. Built and maintained dashboards in Tableau, Power BI, and Looker Studio to monitor revenue, engagement, and product performance. Mapped SQL Server data into Power BI for real-time dashboards and connected Salesforce to Tableau using Tableau Pulse for AI-powered insights, reducing manual analysis time by 20% weekly. Enhanced Salesforce campaign tracking and cross-platform reporting across Salesforce, Pardot, and GA. Identified data anomalies and improved data hygiene to enhance forecasting reliability.
Digital Data Analyst at SPC (Student Price Card)
November 1, 2024 - November 1, 2024
Created and analyzed digital marketing campaigns, achieving a 25% ROI improvement. Built a Power BI dashboard for real-time financial performance. Planned and executed a targeted email campaign for a product launch, including audience segmentation and stakeholder coordination. Organized historical spend data in Excel to visualize MoM, YoY, and QoQ trends using VLOOKUPs. Applied Agile methodology to data projects, improving collaboration and delivery. Coordinated WordPress updates and new layouts to enhance user experience and reduce bounce rate by 10%. Leveraged SEO techniques to measure journey and conversions.
Marketing Analyst | Data Analyst at ERIS (Environmental Risk Information Services)
February 1, 2023 - February 1, 2023
Negotiated partnerships with digital vendors, achieving a 10% cost reduction while expanding online tools. Led an online customer experience initiative that increased user engagement by 20%. Managed a database of over two million entries; performed data cleaning and string manipulation using Regular Expressions. Developed and executed SQL stored procedures for ETL, and created analytical graphs with ggplot2 in RStudio. Delivered cross-source insights to inform planning and strategy. Trained new hires and implemented robust data pipelines and ETL workflows to improve data processing efficiency.

Education

Bachelor of Science (Honours) at University of Toronto
September 1, 2014 - June 1, 2019
Bachelor of Science (Honours) at University of Toronto
September 1, 2014 - June 1, 2019
Bachelor of Science (Honours) in Mathematics & Statistics (Data Science) at University of Toronto
September 1, 2014 - June 1, 2019

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Professional Services, Media & Entertainment, Software & Internet, Education