Data Analyst
Maintain production PostgreSQL databases and reliable analytics pipelines for an enterprise CRM platform, combining operational database management, data quality, documentation and analytical engineering work.
- Manage production PostgreSQL operations, investigate data quality issues and support BigQuery campaign reporting and analytics.
- Developed multi-method consumer identity profiling across millions of contact records using SQL, Python, fuzzy matching, consumer attributes and location signals to investigate likely duplicate patterns.
- Handled large-volume PostgreSQL database migration with pg_dump, pg_restore, scripted workflows, compatibility checks and integrity validation.
- Developed batch-cleanup and partition-maintenance procedures and investigated database performance, indexing and query optimization.
- Reconciled PostgreSQL contact and survey records with BigQuery fact, dimension and datamart tables; investigated discrepancies and backfilled missing survey data.
- Documented ECRM database tables, relationships, data dependencies and workflows; guided three interns and one teammate transitioning into the work.





