Apply Buddy
support@applybuddy.ai | (123) 456-7899 | Silicon Valley, CA
Professional Summary
Motivated aspiring Analytics Engineer with strong SQL skills and hands-on experience in dbt and modern data warehousing. Proven ability to transform messy datasets into clean, analytical tables through academic projects and internship experience.
Professional Experience
- Assisted in migrating 15 legacy SQL stored procedures into modular dbt models.
- Built a daily 'shipment velocity' dashboard in Tableau used by the operations team.
- Wrote data quality tests in SQL to identify null values in critical columns, improving reporting accuracy by 20%.
- Cleaned and aggregated a dataset of 500k records using Python (Pandas) for a research paper on urban traffic patterns.
- Automated data ingestion pipelines using simple Python scripts and Cron jobs.
- Documented data dictionaries to help other students understand dataset schemas.
Skills
Advanced SQL, Python (Pandas), dbt (Core), Data Visualization, Git/GitHub, Data Cleaning, Snowflake (Basics)
Education
- Capstone: Built an end-to-end ELT pipeline using Airbyte, Snowflake, and dbt.
- Relevant Coursework: Database Design, Data Warehousing, Statistics.
Certifications
- dbt Fundamentals
- Google Data Analytics Certificate
Projects
- **E-Commerce Data Warehouse:** Modeled a Star Schema for a mock retail store using dbt and BigQuery.
- **Spotify Analysis:** Used Python API to extract listening history and visualize trends in Streamlit.