Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rui Jiao

Summary

A dedicated analyst with 4 years of related experience of data analytics and reporting. Possesses strong business acumen and ability to translate complex data sets, technical concepts. Leverage technical capabilities (SQL, Python/R) to build analytic processes for large data sets. Exceptional problem-solving skills and ability to navigate ambiguity in a fast-paced and dynamic working environment. Ability to develop strong relationships as a good team player and work in cross-departmental teams.

Overview

4
4
years of professional experience

Work History

Data Management Analyst

TELUS Health
11.2023 - Current
  • Optimized database performance with regular maintenance, indexing, and query optimization strategies.
  • Collaborated with cross-functional teams to ensure seamless integration of data management systems across departments.
  • Delivered accurate and timely reporting by automating report generation processes and establishing clear deadlines for data submission.

Data Analyst

Sojo Canada Inc.
11.2022 - 09.2023
  • Work with cross-functional teams and key stakeholders to understand industry and customer trends, drive long-range business strategy and objectives.
  • Perform data profiling using SQL (aggregation functions, window functions) and Excel (pivot table, functions) to validate data quality and identify/resolve data issues to get analysis-ready data for strategy improvement.
  • Analyze internal data and competitors’ product selection and pricing with complex SQL solutions to derive meaningful insights, identify opportunities, make strategic change suggestions and product scouting as needed.


Data Analyst Intern

Academic Resource Connection Inc.
01.2022 - 04.2022
  • Worked closely with the data science team for business requirement collection and develop data-driven solutions that help understanding customers and adjusting market promotion strategies.
  • Collected and transmitted data gathered from different schools, majors, and grades of student groups into an internal database primarily using Excel VBA and macros.
  • Analyzed customer and sales data using SQL (aggregation function such as SUM, COUNT, AVG), including customer segmentation, customer attrition rate, sales ranking and other KPI metrics.

Data Support Assistant

Changchun Jinshan Hongqi Automobile Sales Service Co., LTD
06.2021 - 08.2021


  • Analyzed customer acquisition rate, churn rate and transaction conversion rate under the implementation of SQL and MS Excel.
  • Presented data visualization results (Power BI) to senior leadership with convincing visual explanations for potential sales opportunities and business strategies.
  • Documented team guide book for process standards and team knowledge sharing.

Education

Bachelor of Arts (Hons.) - Applied Economics

Queen’s University
06.2023

Skills

  • CRM, Marketing Analysis (STP, marketing mix model)
  • Dashboard, Data Visualization, Data Reporting
  • Business Requirement Collection
  • Data Gap Analysis, Data Integration/ETL
  • User Acceptance Testing (UAT)
  • SQL (View, Stored Procedure, T-SQL, window function)
  • Python (Pandas, Numpy), SAS (PROC SQL, Macros)
  • Excel (V-lookup, Pivot Table, Macros), Excel/Access VBA
  • MicroStrategy, PowerBI, Tableau, Google Analytics
  • PostgreSQL, SQL Server, Hadoop, IBM Netezza, MongoDB

Timeline

Data Management Analyst

TELUS Health
11.2023 - Current

Data Analyst

Sojo Canada Inc.
11.2022 - 09.2023

Data Analyst Intern

Academic Resource Connection Inc.
01.2022 - 04.2022

Data Support Assistant

Changchun Jinshan Hongqi Automobile Sales Service Co., LTD
06.2021 - 08.2021

Bachelor of Arts (Hons.) - Applied Economics

Queen’s University

Similar Profiles

CREATE PROFILE
Rui Jiao