Bio
Experience
-
-
Senior Data Engineer
-
Oct 2023 - Present
- Built first data pipelines transforming data in Postgres data warehouse to parquet, streamlining creation of training data for product recommendation models.- Developed initial unit and integration tests using unittest and pytest, enabling continuous integration / continuous development (CI/CD) of data pipelines.- Delivered data to Elasticsearch and Metabase (business intelligence platform) using their respective APIs, enhancing data accessibility and real-time reporting capabilities.
-
-
-
-
Data Engineer
-
Jun 2023 - Oct 2023
- Build Python-based utilities for automated monitoring and ingest of source data into Amazon S3 data lake, enabling production of a person-level demographic database used Bureau-wide.- Maintain source metadata model critical for future automation and traceability in downstream analyses.- Build, test, and document Python data pipelines transforming and loading data into Postgres database in Amazon RDS.- Contribute to database optimization projects, including analyzing performance improvements of database schema changes.
-
-
-
U.S. Census Bureau
-
Washington DC-Baltimore Area
-
Data Engineering Fellow
-
Jun 2022 - Aug 2022
-
Washington DC-Baltimore Area
- Identified data integrity issue impacting 95% of client-facing data product; developed repeatable quality tests to ensurecompleteness of future outputs.- Analyzed contributions of 10+ state & federal data sources, culminating into presentation to senior program leaders. Analysis emphasized need for continued data use agreements.
-
-
-
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Operations Specialist
-
May 2021 - Jun 2022
- Led redesigns of mission-critical data processes, reducing staff time spent on data entry and improving data quality including Salesforce data model updates, grants processing, events data capture, and Sharepoint software implementation.- Led strategy and implementation of changes to Salesforce instance as organization's primary database administrator.- Developed formal data governance and technical trainings, and trained all staff, including nonprofit's new President.- Conducted data analyses for executive leadership to inform key organizational decisions: identified data integrity issue impacting $5.7M in grants, leading to launch of new financial planning platform.- Co-created organization's first formal systems and data manager role.
-
-
Senior Operations Coordinator
-
May 2020 - May 2021
-
-
Senior Program Coordinator
-
May 2019 - May 2020
- Managed logistics for health technology program portfolio representing $8M+ in funding.- Created engagement metrics for funder reports by integrating webinar and event data from 4+ sources.- Fostered relationships with participants, funders, and evaluators throughout program life cycle.
-
-
Program Coordinator
-
May 2017 - May 2019
-
Triage Consulting Group
-
San Francisco Bay Area
-
Experienced Associate Consultant
-
Oct 2015 - May 2017
-
San Francisco Bay Area
- Conducted Extract, Transform, and Load (ETL) of quarterly data downloads from client systems.- Translated contract language into SQL and MS Access queries to calculate expected insurance payments.- Analyses of underpaid insurance claims contributed to monthly revenue record of $2.5M for a single client.- Prepared and presented findings to client C-Suite and finance leaders during quarterly meetings.
-
-
Education
-
2021 - 2023UC Berkeley School of Information
Masters -
Williams College
Bachelor of Arts (BA) -
School for International Training
-
National Taiwan University
Suggested Services
This profile is unclaimed. These are suggested service rates with 0% commision upon successful connection
Industry Focus. “Information Technology and Services”
Need a custom project? We'll create a solution designed specifically for your project.
References
Community