Teng Liu

I am an Analytics Engineering with a proven track record of building robust, scalable data products and delivering actionable insights in the retail, consumer, and ad-tech industries. My expertise lies in bridging the gap between technical capabilities, business needs, and data-driven decision-making.

I’m proficient in SQL, dbt, Looker. I’m experienced with Databricks, AWS, Iceberg and Trino. On the analytics side, I am well versed in R, Python, Excel, Power BI, and VBA.

With experience spanning data engineering, data modeling, and self-service analytics, I thrive at translating complex datasets into user-friendly solutions that empower organizations to act with confidence.

Senior Analytics Engineer
Liftoff Mobile
Jul 2022–Present

At Liftoff Mobile, I serve as the vital bridge between data engineering and business teams, crafting analytics solutions that fuel organizational decision-making and efficiency.

Key Contributions:

  • Analytics Infrastructure: Designed and implemented DBT pipelines, producing high-quality, well-tested datasets for business users.
  • Data Modeling: Built and enhanced Looker models, driving seamless self-service reporting and improving data accessibility.
  • Documentation: Standardized datasets and documented workflows, streamlining operations for analysts and ensuring consistent data quality.
  • Collaboration & Leadership: Partnered with business stakeholders to translate requirements into actionable roadmaps, while delivering technical specifications for engineering teams.
  • Performance Optimization: Led efforts to enhance query and pipeline performance, boosting cost efficiency and user experience.
Data Scientist
BC Safety Authority
Jan 2021–Jan 2022

Developed machine learning models to predict high-hazard sites, directing inspection resources with precision.

Optimized SQL pipelines, reducing runtimes by 90% across the board, significantly enhancing both stability and productivity.

Data Analyst
Best Buy Canada
Mar 2019–Jan 2021

Embedded in the Finance Business Partner team, I drove strategic initiatives and built efficient data solutions to empower teams across the organization.

Key Achievements:

  • Shipping Model Implementation: Optimized logistics by implementing a shipping model that balanced user experience and cost savings, yielding significant efficiencies.
  • Price Erosion Analysis: Created a Power BI dashboard to monitor and mitigate sources of margin loss, enabling proactive strategic decisions.
  • Building Data Products: Built Oracle SQL-based pipelines, views, and triggers to streamline reporting and decision-making.
  • Knowledge Sharing: Designed a user-friendly data documentation portal and led educational sessions to improve data literacy across teams.
Vancouver Coastal Health
Jun–Nov 2017

Developed a statistical framework to detect incomplete Emergency Room data, boosting leadership confidence in decision-making.

Vancouver International Airport
Apr–Oct 2016

Modeled international-to-domestic flight connections, proposing strategies to reduce connection times by up to 55%. This drove the conversation to introduce border kiosks that we all see in Canada today.

The University of British Columbia
Master of Management in Operations Research
Renmin University of China
Bachelor of Economics in Financial Engineering

Hiring from the U.S.? You can sign me up as a contractor with Sasquatch Studio Inc., a British Columbia corporation.

I can help you figure out the logistics—please reach out.