Skip to main content
KH
Looking for a job

Kevin Hsiao

@kevinhsiao1

Analytics Engineer at CDAI building production dbt models and reliable reporting workflows across Sales, Healthcare, and Human Resources.

Canada
Message

At CDAI (Compass Data & AI – Compass Group North America), I’m the sole Analytics Engineer for Canada, delivering projects across Sales, Healthcare, and Human Resources. I build and maintain production dbt models in Snowflake and orchestrate workflows in Airflow, with tests and freshness monitoring to improve reporting reliability.

At theScore (Penn Entertainment), I helped reduce production push timelines by 50% by building a workflow with marketing as the sole data analyst onboarding onto dbt Core. I also supported the Redshift-to-BigQuery migration and helped establish a self-service BI foundation with Looker and LookML.

Experience

Work history, roles, and key accomplishments

CA
Current

Analytics Engineer III/Business Intelligence Engineer III

CDAI (Compass Data & AI – Compass Group North America)

Jan 2025 - Present (1 year 10 months)

Served as the sole Analytics Engineer for Canada, delivering projects across Sales, Healthcare, and Human Resources. Built and maintained production dbt models in Snowflake, standardized transformations with reusable Jinja macros, and orchestrated dbt workflows in Airflow.

TE

Marketing Data Analyst III

theScore (Penn Entertainment)

Mar 2024 - Jan 2025 (10 months)

Built a workflow with marketing to ensure all required customer attributes were accounted for as the sole data analyst onboarded onto dbt Core, resulting in a 50% reduction in production push timelines. Supported the migration from Redshift to BigQuery on dbt Cloud by translating and validating 15% of dbt models.

TE

Marketing Data Analyst II

theScore (Penn Entertainment)

Jan 2023 - Mar 2024 (1 year 2 months)

Played a foundational role in implementing Looker, building core Analytics Engineering models with LookML that established a scalable, self-service BI foundation. Transformed complex Python code into optimized SQL queries to update a vital CRM model, enabling targeted outreach to over 4 million users.

FU

Product/Marketing Analyst

Fundthrough

Dec 2021 - Nov 2022 (11 months)

Provided analytical support to monthly product and marketing ICP targeting campaigns, resulting in an all-time high of $7 million in funding amounts for partners.

Education

Degrees, certifications, and relevant coursework

University of Waterloo logoUW

University of Waterloo

Bachelor of Science

Completed a Bachelor of Science degree at the University of Waterloo in August 2019.

Interested in hiring Kevin?

You can contact Kevin and 600K+ other talented remote workers on Himalayas.

Message Kevin

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan