# Kevin Hsiao

Kevin Hsiao is a remote worker on Himalayas, Analytics Engineer III/Business Intelligence Engineer III at CDAI (Compass Data & AI – Compass Group North America), based in Canada.

Source: https://himalayas.app/@kevinhsiao1

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

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Canada |
| Authorized to work in | Canada, United States |
| Salary expectations | 150k+ CAD |
| Job categories | Analytics Engineer, Business intelligence Engineer, Data Analyst, Marketing Data Analyst, Product Analyst |
| Skills | Analytics Engineering, Business Intelligence, Data Modeling, ETL, Data Warehouse, SQL, DBT, Dbt Cloud, Airflow, Snowflake, Looker, LookML, BigQuery, Amazon Redshift, Python |
| LinkedIn | https://linkedin.com/in/kevinleehsiao |

## About

```text
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

### Analytics Engineer III/Business Intelligence Engineer III (current)

CDAI (Compass Data & AI – Compass Group North America). Jan 2025 - Present

```text
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.
```

Skills: DBT, Snowflake, SQL, Jinja, Airflow, Slack, Cursor, YAML, Data-Engineering

### Marketing Data Analyst III

theScore (Penn Entertainment). Mar 2024 - Jan 2025

```text
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.
```

Skills: DBT, Dbt-Cloud, Redshift, BigQuery, SQL, Data-Migration, Documentation

### Marketing Data Analyst II

theScore (Penn Entertainment). Jan 2023 - Mar 2024

```text
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.
```

Skills: Looker, LookML, SQL, Python, Mode, CRM, Data-Modeling

### Product/Marketing Analyst

Fundthrough. Dec 2021 - Nov 2022

```text
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.
```

Skills: Analytics, Marketing, Product, ICP-Targeting

## Education

### University of Waterloo

Bachelor of Science

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

## Tech stack

- Amazon Redshift
- Snowflake
- Looker
- Periscope
- GitHub
- NumPy
- Pandas
- DataGrip
- dbt
- Slack
- Python
- Jinja
- Git
- Airflow
- Google BigQuery
- SQL
- Cursor
- dbt Cloud
- Power BI

To contact Kevin, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Ashwin Nair](https://himalayas.app/@ashwinnair1): Business Data Analyst, Optoro
- [Ashritha User](https://himalayas.app/@ashrithauser): BI & Data Analyst, BMO
- [Adunoluwa Olutola](https://himalayas.app/@adunoluwaolutola): Data & Reporting Analyst, Agio Inc.
- [Jan Chayopathum](https://himalayas.app/@janchayopathum): Analyst II, Data Architecture, StackAdapt
- [Adunoluwa Olutola](https://himalayas.app/@adunoluwaolutola1): Data & Reporting Analyst, Agio Inc.
- [Remy Shea](https://himalayas.app/@remyshea): Data Engineer, Electronic Arts
- [Jitheesh Vijayan](https://himalayas.app/@jitheeshvijayan): Senior Data Analyst, Life360
- [Hannan Ahmed](https://himalayas.app/@hannanahmed1): BI Engineer, Amazon
- [Kadambari Chheda](https://himalayas.app/@kadambarichheda): Analytics Engineer, Business Insider
- [mohammed User](https://himalayas.app/@mohammeduser28): Data Analyst, AT&T
