Team Lead Data Engineer at RedCoast
Developed a data pipeline to extract data from Google Analytics and DV360 platforms, storing it in the Google Cloud BigQuery table using the Python script.
Led the development team of a data analytics web application for real-time market ads data analysis dashboards, automated ETL workflows, and email alerts triggered by data thresholds. Developed Python script for dynamic SQL query creation for extracting data dashboard visuals for insightful data analysis, featuring multi-user role-based access and row-level security for personalized data views.
Designed and implemented an architecture that migrated virtual machine code to Google Cloud Functions serverless, reducing company cloud costs by 95%.
ETL workflows to extract and process data from APIs (Google Analytics, DV360, Salesforce) and integrated data into BigQuery using Python scripts.
Developed Python scripts to extract invoices data and load it into the GCP BigQuery table.