Jose Calucag

• Constructed SQL queries in DataGrip, Athena and BigQuery to interact with multiple stages of the data pipeline.
• Executed and monitored data ingestion workflows through Rundeck and Grafana.
• Supported analytics teams in development of Tableau and Looker dashboards.
• Supported marketing teams in the development of case studies by delivering Google Sheets reports and Google Slides presentations highlighting key trends and KPIs.

• Monitored high-value client campaigns across various ad management platforms (CM360, SA360, GA, Facebook, TikTok, Apple) and employed API connectors to automate data extraction for reporting.
• Maintained quality of data through QA and implemented new processes to improve efficiency in data integrity.
• Created visualizations and dashboards in Datorama, Excel and Sheets to report upon monthly, quarterly and ad hoc reports.

• Identified trends and performance indicators of complex datasets to provide actionable insights.
• Reported results for clients and internal teams through easy-to-read dashboards and charts.
• Scrubbed, transformed, validated and modeled data to improve quality and accuracy.

• Analyzed and scrubbed raw data to create tables for further analysis.
• Identified opportunities for process improvements to operations and systems.
• Leveraged ETL process to load data frames into DOMO dashboards and Excel Reports.

• Reviewed content and ensured accurate registration of online advertisements.
• Ensured advertising policies adhered to IAB standards.
• Maintained high productivity by meeting established daily targets.