Hello World

I am Arjun.
I build data warehouses
and the AI systems
that read from them.

Arjun Loya

About

The through-line in my work is measurement. Pipeline, dashboard, forecast, or retrieval system — the question is always the same. How do you know it is right?

That has meant three things. The platform: Azure Data Factory pipelines into Snowflake, star-schema models, and SQL validation and reconciliation rules that stop bad data before it reaches a report. The reporting layer on top: Power BI with DAX and row-level security, and an 80+ KPI registry with one agreed definition per metric. And the AI layer: at Groflex AI, a RAG pipeline returning answers in 1–3 seconds with per-tenant isolation.

I am finishing an MS in Information Systems at Northeastern, after nearly two years on the data side at Accenture and a co-op at Groflex AI.

Download CV

Core Expertise

  • Data Engineering
  • Dimensional Modeling
  • Business Intelligence
  • Forecasting & Experimentation
  • Machine Learning
  • RAG & Retrieval

Experience

Groflex AI

Data and AI Engineer Co-op

January 2026 - May 2026

  • Delivered 1–3 s end-to-end RAG responses over 3+ client document sets, using Azure OpenAI embeddings and MongoDB Atlas Vector Search.
  • Enforced per-tenant index isolation, so a query cannot reach another customer's documents.
  • Integrated Azure OpenAI into production APIs, handling prompt templating, context management, and structured output parsing.
  • Documented a registry of 80+ KPIs with business teams, giving every client metric one agreed definition.
  • Enforced 7-role RBAC and PII masking in a 30+ endpoint FastAPI backend, with schema contracts on write paths.
  • Shipped changes through GitHub Actions CI/CD with pytest suites and peer pull-request reviews.

Accenture

Data Analyst (Application Development Associate)

October 2022 - July 2024

Compliance and KPI reporting for a Fortune 100 US banking client.

  • Cut Azure Data Factory pipeline refresh time ~40% (from 15–45 min) by tuning ETL workflows behind daily Snowflake loads.
  • Built 50+ SQL validation, reconciliation, and trigger rules across 15+ source feeds, keeping bad values out of monthly leadership reports.
  • Reduced weekly manual data-prep hours ~20% by automating SQL data quality checks on millions of rows per load.
  • Shortened report turnaround ~25% with Power BI dashboards on star-schema models, using DAX, Power Query, and anomaly alerts.
  • Wrote complex SQL in Snowflake and Databricks for compliance and KPI reporting datasets and ad-hoc analysis.

ShelfMerch

Data Intern

June 2021 - November 2021

  • Caught duplicate and out-of-range sales records before load with SQL cleaning and validation routines.
  • Built Power BI scorecards on weekly sales KPIs that informed inventory and merchandising decisions.

Education

Northeastern University

Master's in Information Systems

Expected Dec 2026

Includes a full-time co-op semester at Groflex AI.

  • Designing Data Architecture for Business Intelligence
  • Big-Data Systems and Intelligence Analytics
  • Database Design and Management
  • Data Science Engineering Methods and Tools
  • Prompt Engineering and AI
  • Reinforcement Learning for Agentic AI Systems
  • Business Analysis
  • Information Engineering

St Joseph's College

BBA in Information Technology

2019 - 2022

First Class with Distinction. President of the Data Science Club.

  • Database Management System
  • Data Warehousing & Data Mining
  • Data Analytics using R
  • Business Statistics
  • Python Programming

Certifications

Microsoft Certified: Azure Fundamentals (AZ-900)
Google Data Analytics Professional Certificate
AWS Certified Data Engineer – Associate (in progress)

Technical Skills

Data Engineering

  • ETL/ELT pipeline design and orchestration
  • Azure Data Factory, Databricks, PySpark
  • Dimensional modeling, star schemas, SCDs
  • Schema contracts, data quality, anomaly detection
  • Medallion architecture, Delta Live Tables

Analytics & Business Intelligence

  • Power BI, DAX, Power Query, Tableau
  • Semantic models and row-level security
  • Metric definition and KPI governance
  • Cohort, funnel, and segmentation analysis
  • Requirements gathering and root cause analysis

Statistics & Experimentation

  • Hypothesis testing and confidence intervals
  • A/B testing and experimental design
  • Time-series forecasting (ARIMA)
  • Rolling-origin backtesting against baselines
  • Error analysis and result interpretation

Machine Learning

  • Regression and classification
  • Feature engineering and cross-validation
  • Precision, recall, ROC-AUC, PR-AUC
  • Class imbalance and threshold selection
  • scikit-learn, PyTorch

AI & Retrieval

  • RAG end to end: chunking, embeddings, vector search
  • Retrieval evaluation on labeled sets
  • Per-tenant isolation in multi-tenant systems
  • Azure OpenAI and Gemini SDKs
  • Prompt templating, structured output, schema validation

Languages, Data Stores & Tooling

  • SQL, Python, PL/SQL, R
  • Pandas, NumPy, Snowflake, PostgreSQL, MongoDB, Oracle 12c
  • Azure, AWS (RDS, QuickSight)
  • FastAPI, Docker, Git, CI/CD
  • Partitioning, indexing, query tuning

Community

Community member at the Roslindale Food Collective in Boston — logistics and distribution for a nonprofit working on food security for students and local families. Also involved with Northeastern's Off-Campus Engagement and Support program.

Get In Touch

I finish at Northeastern in December 2026 and I am available from January 2027.

Looking for data engineering, analytics engineering, data science, and applied machine learning roles. Anywhere in the US.

Reach me at

Elsewhere