Architect data modeling process using dbt to centralize & codify company metrics
Establish Github repo for dbt projects to ensure software engineering best practices - CI/CD and version control
Partner with Director of Data Ops to prepare demo, proposal, implementation and rollout of new visualization tool Sigma
Coordinate with Data Engineers & DevOps for implementation plan - database organization, permissions, Terraform, Airflow
Support stakeholder requests by providing self service analytics that lead to data driven decisions
Implemented end-to-end metrics automation, resulting in substantial time savings for tasks for various teams: Data Management (97.4% per month), Project Management (91.67% per month), and Product (66.67% per month)
Consult team leads in dbt and Sigma best practices for 3 distinct products
Business Analyst - Research & Development
Carpe Data
08.2020 - 04.2022
Promoted to newly created R&D team in order to propose and prototype novel products using SQL and Python
Respond to urgent customer requests ranging from creating a rudimentary data pipeline to cross-database POCs
Design wireframe of UI for product to hand off to Web Development team
Serve as cross-team liaison advocating for the needs of the product prototypes
Clean and transform data for Data Science members
Data Analyst - Product Specific Team
Carpe Data
08.2019 - 08.2020
Proposed and managed implementation of solution ensuring parity between related products, guiding intern from conception to execution
Develop Python script to automate data cleaning, achieving 5% time savings on average per sprint per team
Implement agile methodologies to enhance project efficiency in collaboration with team lead
Analyze data sources and advise stakeholders on best course of action
Formulate regular expressions to identify and flag relevant business phrases
Education
Bachelor of Arts - Physics
UC Berkeley
Berkeley, CA
2019
Skills
dbt
Sigma
Git
Intermediate SQL
Basic Python
Experience with Snowflake and AWS Athena
Basic knowledge in AWS services: S3, Batch, Glue, Lambda