Andrea L.
Data Engineer @TELUS
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @TELUS
CA
Designed and built scalable data pipelines for data processing, staging, and ETL using BigQuery, Python, and cloud ETL tools, ensuring high-quality data for training machine learning models- Transformed data across extensive networks, data warehouses, and data lakes into dimensional tables for various business use cases; created automated processes using YAML scripting, managed data orchestration, and monitored pipeline performance- Partnered with prime members on GCP data migration projects, producing data schemas and logic to streamline and optimize the migration process, and performed UAT to ensure data integrity- Led as a Data Steward across business units, managing data risk and lifecycle, conducting data governance, and initiating the implementation of roadmaps for new data capabilities- Developed and managed the entire development process as the table product owner, overseeing design, implementation, and deployment of data solutions- Utilized GitHub/Git for CI/CD, ensuring streamlined development workflows and robust version control- Spearheaded data orchestration initiatives, coordinating complex workflows and ensuring seamless data integration across systems.
EDUCATION
New York University
Management Information Systems
ABOUT ANDREA L.
Data Engineer | Community Manager @ Google Developer Group (GDG) Vancouver | AWS Community Builder | Google Women Techmakers Ambassador | Mentor @ WomenTech Network | Mentor @ Women in Big Data | Technical Writer @ Towards Dev Highlights- Data engineer in Telecommunications with a focus on Cloud technologies (AWS/GCP)- Aspiring women founder in developing AI-driven Data Solutions Grantee and mentor from AWS All Builders Welcome Program - Mentor @Google Women Techmakers (https://developers.google.com/womentechmakers),@ WomenTech Network and @ Women in Big Data Technical writer with publications on cloud technologies @ Medium Towards Dev (https://medium.com/@andrea.liyu.liao) and dev.to/aws-builders Technical Skills- Data Engineering: ETL in SQL & NoSQL (Apache Cassandra), building data pipelines, data modeling (create normalized & denormalized schemas), data warehousing, Google Cloud BigQuery, SAS (Certified Advanced Programmer), AWS data analytical tools (Kinesis, Redshift, AWS Glue, etc.), Databricks Lakehouse, Snowflake- Languages: Python, BigQuery, PySpark, SQL (Postgre SQL, Oracle PL/SQL, MySQL), YAML, P5.js, JavaScript More About Me- Linktree: https://linktr.ee/andrea.liao- I am passionate about using technologies to MAKE ART HAPPEN. Some of my work includes: • Music & AI: 2023 NYU ITP Camp session leader • Creative coding using P5.js: • Interactive TouchDesigner projects: Music Visuals, Ice and Fire (leap motion), Cubeman - I am a founding member of Next-Gen Women in Tech for Good community. I am an advocate of AI for social goods- I am a culture ambassador/volunteer in many programs include: • the volunteer at New York Taste of France festival in 2014 • the ambassador in 2016 K-pop experience program offered by the city of Seoul and SM Entertainment • the participant of 2019 Bali Cultural Conservation program
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.