Justinn B.
Data Analyst
Compare at US rates $12,000/mo?
Notable Highlight
Built end-to-end automation pipelines at Google that saved 10+ hours per week in manual reporting and established SQL-based data governance frameworks that eliminated revenue misattribution across 500+ partner accounts.
Experience Summary
Justin is a Data Analyst with 5+ years of experience across Google partner operations, retail, healthcare, and engineering environments. He is proficient in SQL, Snowflake, Power BI, Looker Studio, Python, and Google Apps Script. Currently supporting Google's partner data operations, Justin works on partner mapping, audit workflows, and dashboarding tied to corporate relationship data. He has built business-facing dashboards and automation workflows that improved reporting efficiency and visibility, including gap/void and fill rate dashboards for Safeway, a machine performance dashboard in healthcare, and partner audit dashboards at Google. Justin automated manual processes, including reducing a recurring extraction task from 4-5 days to 3-5 hours using Python, OpenPyXL, and Selenium, and streamlining reporting workflows through Google Apps Script. He used data to address commercial and operational questions, including price sensitivity analysis, inventory and fill rate monitoring, and root-cause analysis of revenue discrepancies between systems. His background as a licensed Electronics Engineer brings technical and process-oriented perspective to his analytics work. Justin is well-suited for roles focused on reporting, data operations, and business intelligence support.
Key Achievements
At Google (VHA), managed accurate revenue attribution across 500+ partner and Cloud accounts and achieved zero reconciliation escalations over 12 months. Saved 10+ hours per week through automation pipelines. At SP, recovered 15% of leaking revenue via a Power BI/Snowflake Fill Rate dashboard. At FMC, reduced dialysis machine downtime by 25% and improved SLA compliance by 20% across 10+ locations using a predictive maintenance model built from historical service data.
Skills
Work Experience
Data Analyst
GU · Remote · Jan 2024 - Present
- Save 10+ hours per week in manual reporting by building end-to-end automation pipelines in Google Apps Script, BigQuery, and the Gemini API, eliminating recurring manual exports across 5 partner workflows.
- Cut manual QA tickets by 25% by designing a SQL-based data governance and validation framework in BigQuery (PLX) that catches duplicates, orphaned records, and entity mismatches at ingestion before they reach revenue reporting.
- Achieve zero reconciliation escalations across 12 months by leading end-to-end partner data audits and entity mapping that ensure accurate revenue attribution across 500+ Google partners and Cloud accounts.
- Build real-time partner performance visibility by integrating Looker Studio dashboards directly with BigQuery cloud data warehouse pipelines, replacing static manual slide decks.
Lead Data Analyst
a previous company · Mandaluyong City, Philippines · Sep 2023 - Jan 2024
- Eliminate manual data handoffs across 4 project teams by building ETL workflows integrating Smartsheet, Excel, and Power BI into a centralized cloud data pipeline, reducing reporting delays by 20% against dashboard refresh SLA.
- Reduce provisioning and reporting manual effort by 30% by automating data extraction and transformation via Power Query and Power Pivot, strengthening financial data governance across the entire PMO.
- Standardize stakeholder management reporting for all regional project leads by designing scalable Power BI dashboards with near real-time refresh, replacing inconsistent spreadsheet decks with a single source of truth.
Senior Data Analyst
SP · Taguig City, Philippines · Mar 2023 - Sep 2023
- Recover 15% of leaking revenue by building a Gap & Void / Fill Rate dashboard in Power BI on Snowflake SQL that surfaces new vs. churned stores and items vs. prior year by giving commercial stakeholders a weekly view of where money was walking out the door.
- Accelerate time-to-insight by 30% by engineering scalable ETL pipelines in SQL, Power Query, and Excel to replace manual pulls from the Snowflake cloud data warehouse, freeing the team from weekly export rituals.
- Improve decision-making efficiency by 20%, as measured by report turnaround time and stakeholder satisfaction, by developing Power BI dashboards tracking revenue, profit, and units sold across retail channels.
- Strengthen data governance by implementing root cause analysis workflows that identify and resolve recurring data quality issues, reducing ad-hoc correction requests quarter over quarter.
Technical Analyst & Service Engineer
FMC · Taguig City, Philippines · Feb 2019 - Nov 2022
- Reduce equipment downtime by 25% by developing a predictive maintenance model using historical service data and Power BI dashboards to forecast dialysis machine failures before they occur, shifting the team from reactive to proactive maintenance.
- Improve SLA compliance by 20% by building operational dashboards that monitor machine performance, failure trends, and engineer response times across 10+ service locations, turning field data into accountable KPIs.
- Cut recurring failures by 15% by conducting structured root cause analysis and logging failure patterns into a shared data governance repository, creating institutional memory the technical team can act on.
Design Engineer
WFI · Makati City, Philippines · May 2017 - Feb 2019
- Design fiber optic network layouts (FTTH/FTTU) for high-rise buildings using AutoCAD, building the structured problem-solving and technical documentation habits that directly inform how data modeling and pipeline design are approached today.