Hi, I’m Yuka Hiratani, a Senior Marketing & Data Analyst with 8+ years of experience driving customer acquisition, activation, retention, and revenue insights across B2C and B2B. I excel at turning complex behavioral data into actionable growth strategies, building KPI frameworks, churn models, and measurement systems that inform experimentation and optimization. My background spans marketing analytics, customer journey analysis, and analytics engineering, with hands-on proficiency in Snowflake, SQL, and self-service BI tools like Power BI and Tableau. I enjoy partnering with Marketing, Product, and Finance to translate data into value and guide data-driven decisions. I’ve built scalable data models and dashboards, led data quality and governance initiatives, and supported pricing, revenue forecasting, and campaign optimization across multiple industries. From early-stage volunteering to enterprise analytics, I’ve delivered insights that improved performance and helped teams discover friction points, optimize campaigns, and grow revenue.

Yuka Hiratani

PRO

Hi, I’m Yuka Hiratani, a Senior Marketing & Data Analyst with 8+ years of experience driving customer acquisition, activation, retention, and revenue insights across B2C and B2B. I excel at turning complex behavioral data into actionable growth strategies, building KPI frameworks, churn models, and measurement systems that inform experimentation and optimization. My background spans marketing analytics, customer journey analysis, and analytics engineering, with hands-on proficiency in Snowflake, SQL, and self-service BI tools like Power BI and Tableau. I enjoy partnering with Marketing, Product, and Finance to translate data into value and guide data-driven decisions. I’ve built scalable data models and dashboards, led data quality and governance initiatives, and supported pricing, revenue forecasting, and campaign optimization across multiple industries. From early-stage volunteering to enterprise analytics, I’ve delivered insights that improved performance and helped teams discover friction points, optimize campaigns, and grow revenue.

Available to hire

Hi, I’m Yuka Hiratani, a Senior Marketing & Data Analyst with 8+ years of experience driving customer acquisition, activation, retention, and revenue insights across B2C and B2B. I excel at turning complex behavioral data into actionable growth strategies, building KPI frameworks, churn models, and measurement systems that inform experimentation and optimization. My background spans marketing analytics, customer journey analysis, and analytics engineering, with hands-on proficiency in Snowflake, SQL, and self-service BI tools like Power BI and Tableau. I enjoy partnering with Marketing, Product, and Finance to translate data into value and guide data-driven decisions.

I’ve built scalable data models and dashboards, led data quality and governance initiatives, and supported pricing, revenue forecasting, and campaign optimization across multiple industries. From early-stage volunteering to enterprise analytics, I’ve delivered insights that improved performance and helped teams discover friction points, optimize campaigns, and grow revenue.

See more

Language

English
Fluent

Work Experience

Data Analyst at Toronto Community Housing
August 1, 2021 - Present
Built and maintained scalable analytics datasets in Snowflake to support product, finance, and operational reporting. Designed analytics-ready data models (star and snowflake schemas) to improve performance and data reliability. Partnered with business stakeholders to define KPIs, enabling consistent measurement across teams. Developed self-service dashboards in Power BI, reducing ad-hoc reporting requests and improving decision-making speed. Led data quality initiatives and standardized reference data to improve trust in analytics outputs.
Data Analyst at Eddy Solutions
February 1, 2021 - May 31, 2021
Analyzed customer consumption and sales data to identify usage patterns and growth opportunities. Built SQL-based analytics pipelines to automate recurring reports and insights delivery. Delivered pricing and performance insights that supported revenue optimization initiatives. Transformed, cleaned, and modeled raw data using ELT best practices, with hands-on experience in analytics-engineering workflows similar to DBT.
Marketing Data Analyst (Volunteer) at 8 80 Cities
January 1, 2021 - February 28, 2021
Consolidated marketing and campaign data to support category trend analysis and strategy. Produced actionable insights to improve community engagement through Google Ads and Excel-based reporting.
Data Analyst at MediaCom
May 1, 2017 - August 31, 2017
Partnered with digital and media teams to conduct campaign performance analysis. Applied data governance practices to enhance data quality and reduce redundancies.
Business Intelligence Consultant at FAME – Fábrica de Aparelhos e Material Elétrico Ltda.
April 1, 2013 - June 30, 2016
Led sales and customer analytics initiatives, delivering dashboards used by senior leadership for strategic decisions. Conducted pricing, assortment, and market segmentation analysis contributing to 4.26% annual sales growth. Built customer retention and churn-risk models to proactively target at-risk segments.
Business Intelligence Consultant at MarketData
February 1, 2010 - March 31, 2013
Designed and implemented campaign analytics solutions using SQL Server & SSIS. Developed self-service tools that enabled marketing teams to identify customer behavior and purchase trends.
Database Analyst at Citi
June 1, 2007 - February 28, 2010
Led post-campaign performance analysis, improving targeting for campaigns reaching 1M+ customers monthly. Built automated reporting and OLAP cubes to optimize campaign execution and decision-making.
Marketing Data Analyst (Volunteer) at 80 80 Cities
January 1, 2021 - February 1, 2021
Consolidated marketing and campaign performance data across channels; analyzed Google Ads and engagement metrics to identify trends and optimization opportunities; produced insights to improve campaign effectiveness and community engagement.

Education

Certificate in Data Analytics, Big Data & Predictive Analytics at Ryerson University
January 1, 2020 - December 31, 2020
Postgraduate in Marketing at George Brown College
January 1, 2017 - December 31, 2017
Certificate in Data Analytics, Big Data & Predictive Analytics at Ryerson University
January 11, 2030 - January 1, 2020
Postgraduate in Marketing at George Brown College
January 11, 2030 - January 1, 2017
Postgraduate in Marketing at George Brown College
January 1, 2017 - January 1, 2017
Certificate in Data Analytics, Big Data & Predictive Analytics at Ryerson University
January 1, 2020 - January 1, 2020

Qualifications

Add your qualifications or awards here.

Industry Experience

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