Data Engineer Searce Inc
Built Looker Enterprise dashboards for more than 25 KPIs, using LookML dimensions and measures to centralize calculations, data manipulation, and reporting for six senior stakeholders, including vice presidents and the Chief Business Officer. Reduced manual reporting time by 70%.
Owned the Microsoft SQL Server-to-BigQuery validation module for an internal tool. Developed object-oriented Python classes to audit schema integrity and field-level accuracy for downstream data consumers.
Developed and maintained more than 20 modular Python programs, including Airflow DAGs and ingestion/transformation processes, to automate uploads across Google Cloud Storage and third-party sources. Implemented logging and failure-case testing to achieve consistent data delivery.
Led data warehouse migration and integration initiatives using SQL, BigQuery, and Medallion architecture. Migrated 40–50 TB of data, reduced query latency by 24%, delivered more than 70 tables for a major logistics client, and built an Apache Beam Dataflow streaming pipeline processing 10,000 records per second from Pub/Sub to BigQuery.