JM
Joel Macaroncio Jr.
Status: Open for Projects

Joel Macaroncio Jr.

Data Engineer, AI Developer & Tech Strategist

Empowering businesses with strategic planning, scalable data pipelines, and intelligent AI solutions. I turn complex data into actionable insights and build robust web applications.

Taguig, Metro Manila, Philippines
EmailLinkedInOnlineJobs
About Me

Bridging Data, AI, and Business Strategy

Hello, I'm Joel Macaroncio Jr.

With a strong background in data engineering and intelligent systems, my primary goal is assisting business owners with strategic planning using my core skills. Let's transform your raw data into automated, AI-driven solutions that scale.

Whether it's building performant, multi-tenant dashboards, implementing automated workflows, or advising on technical roadmaps, I combine structural rigor with modern web aesthetics.

Strategic Business Planning
Scalable Data Pipelines
AI-Native Application Development
Process Automation
Joel Macaroncio Jr.
Value Proposition

What I Can Do For You

I help businesses develop data-driven ideas into production-ready Web and Mobile applications in the fastest and most efficient way possible.

ETL & Data Pipelines
As a Data Engineer, I architect robust, automated data ingestion and transformation pipelines. By leveraging scalable cloud infrastructure, I turn fragmented raw data into structured, real-time analytics that drive high-level strategic decisions.
Business Automation
I design and deploy intelligent, automated systems that eliminate manual bottlenecks. By seamlessly integrating third-party APIs with your core platforms, I ensure your operational workflows operate at peak, error-free efficiency.
Agentic AI Integration
I empower businesses with context-aware, autonomous AI agents. By orchestrating advanced LLMs, I embed intelligent productivity overlays directly into your existing ecosystem to multiply your team's output.
Full-Stack Web & Mobile
I rapidly prototype and build production-ready, highly performant web and mobile applications. Delivering continuous value through exceptional UX/UI and scalable backend architectures.
My Arsenal

Tools & Technologies

The specialized tools I utilize to orchestrate data pipelines, construct robust applications, and manage agile enterprise workflows.

Data & Backend

Google BigQuerySQLSupabaseREST APIs

Frontend & Mobile

Next.jsReact NativeTailwind CSS

AI & Automation

LLMsAgentic WorkflowsOpenAIPower Automate

Project Management & Comm

SlackMonday.comTeamsAzure DevOpsJira Align
Expertise

Core Skills

My technical toolkit is focused on data engineering, automation, AI integration, and full-stack web development.

Full-Stack Web Development
Building responsive, highly-performant web applications using Next.js, React, and Tailwind CSS (e.g., Virenesis, EXPENX).
Mobile App Development
Creating cross-platform mobile experiences with React Native and Expo (e.g., Expense Tracker Mobile).
Backend & Database
Architecting scalable data solutions with Supabase, Google BigQuery, and robust REST integrations.
Business Automation
Streamlining enterprise processes via Power Automate and custom API workflows, elevating business intelligence.
Career Journey

Professional Experience

Data Engineering Lead / Analyst

Accenture

Present

Leading data engineering projects using Google BigQuery. Architecting robust data pipelines, enabling automation via Power Automate, and delivering actionable analytics that drive business strategy.

Digital Marketing & Analytics

Digital Marketing Agency

Prior Role

Architected tracking solutions, managed marketing automation, and generated actionable business intelligence reporting to optimize campaign performance and ROI.

Operations & Management

Resorts World Manila

Early Career

Built a strong foundation in operations management, structured corporate processes, and oversaw early technical integrations for improved efficiency.

My Work

Featured Projects

A selection of my recent developments combining scalable data architecture with modern web design.

Virenesis
Virenesis
My primary professional platform representing my suite of tools and technical portfolio. Built with Next.js and Tailwind CSS.
Next.jsTailwind CSSPortfolio
SourceVisit Live
EXPENX
EXPENX
A data-driven expense tracker and financial dashboard built for robust tracking, intuitive analytics, and streamlined budgeting.
React NativeSupabaseFinance
SourceVisit Live
Khamba Travel and Tours
Khamba Travel and Tours
A comprehensive travel agency platform highlighting our BMBE Certification and trusted travel agent status, offering top-tier bookings.
Next.jsBMBE CertifiedTravel Tech
SourceVisit Live
Case Study

Enterprise Data Warehouse Architecture & Optimization

The Challenge

An organization faced challenges with disorganized datasets spread across multiple platforms, leading to fragmented data sources. This resulted in inefficient query performance, high latency, and significantly rising Google Cloud Platform (GCP) costs.

Technical Stack

Google BigQuerySQLETLData Modeling

The Solution: Scalable BigQuery Modeling

I architected a centralized data warehouse using a multi-tiered approach to ensure data quality and performance, moving from disorganized raw data to highly optimized reporting structures.

Tiered Architecture

Implemented a Bronze-Silver-Gold (Landing-Staging-Production) flow to maintain clean lineage and robust data transformations.

Schema & Modeling

Designed a robust Star Schema. Utilized nested and repeated fields (STRUCT/ARRAY) for denormalization to minimize heavy JOIN operations.

Cost Control & Performance

Applied strict table partitioning by Date and clustering by key dimensions, drastically optimizing data scanning and reducing overhead.

Automated Pipeline

Integrated automated logic for daily ETL refreshes, ensuring the reporting layers are continually updated with zero manual intervention.

The Impact

  • Efficiency & Cost: Achieved a 30% reduction in query costs and a significant decrease in processed data volume.
  • Speed: Reduced report loading times from minutes to sub-second latency for executive-level dashboards.
  • Scale: Built a robust framework capable of handling millions of rows daily without any performance degradation.