Badges
Certifications
Work Experience
Software Engineer
Wayfair•  October 2018 - January 2023
Data Engineer II • Designed complex ETL pipelines on big data with multiple parallel running jobs. • Actively developed on and maintained a 6000+ column, 100+ TB denormalized curated data layer within Google BigQuery, scaling the architecture to include new data and extend to more users. • Monitored and resolved data update service-level agreements (SLAs). • Collaborated with business stakeholders and engineers to identify requested metrics and dimensions and define their sources of truth. • Identified and implemented optimization opportunities within existing pipelines, reducing processing time and cost. • Wrote documentation for data layers, including business use, column definitions, sample queries and data lineage. • Performed technical reviews on SQL scripts within GitHub. • Transformed data models from the traditional star schema to denormalized architecture when transitioning from Vertica to GCP. • Built reporting dashboards for data analysis in Tableau, Looker Studio and Google Sheets. • Worked on a team of 5+ using agile development processes.
Education
jenna_m_castro has not updated education details yet.
Links
Skills
jenna_m_castro has not updated skills details yet.