Skip to content
Available nowSydney & Canberra

Balaji Ranganathan · Principal Data & AI Engineer

Data platforms and AI agents that pass security review and ship.

Fabric and Databricks lakehouses for Commonwealth agencies, governed AI agents, and four live products I build and run myself. 10+ years across Federal Government, Go8 research and commercial enterprise.

Also: CV (PDF) · Architecture diagrams

Focus the site on:
ISM / PSPF-aligned deliveryM.Eng, The Australian National UniversityAzure Data Engineer Associate · Vertex Core Group

What a Commonwealth Director said

“I have never seen anyone as proficient and expert as Balaji!”

On integrating SAP data into the agency's Enterprise Data Platform and getting it through Technical Advisory Group endorsement.

SMSeema MulyeDirector / Assistant Secretary Level Leader, Australian Federal Government
Read all endorsements

10+ years

Data & AI delivery

Federal Government · Go8 research · commercial enterprise

SAP, Aurion, CRM

Into one governed lakehouse

Commonwealth agency Enterprise Data Platform on Azure and Fabric

4 live products

Built and run by me

LexiCanvas · McpCognito · SentrySurface · SurfaceProxy

Security-reviewed

ISM / PSPF-aligned delivery

Technical Advisory Group endorsement · formal SDD and ADR handover

LinkedIn Recommendations · Executive Track Record

Verified Client & Leadership Endorsements

Unedited recommendations from Australian Government Branch Heads and delivery executives on enterprise modernizations.

Recommendations

  • SM
    Seema Mulye· 1st

    Australian Government Leader

    November 21, 2023, Seema managed Balaji directly

    Executive Key Takeaways

    • ✓Realignment of Modern Enterprise Data Platform (EDP)
    • ✓SAP Data Integration & Technical Advisory Governance endorsement across accelerated sprints
    • ✓End-to-end data modeling & executive dashboards delivered without external Finance SME
    • ✓Complex Aurion data pipelines & Power BI storytelling for COO & Senior Executives
    • ✓Evidence-based strategic decisions delivered on time and within budget

    I would highly recommend Balaji for his enthusiasm, expertise and going over and above achieving what seems impossible in the field of data! Balaji was firstly instrumental in realignment of our Enterprise Data Platform. He helped us position us well to build Enterprise dashboards and digital products! He seems to be an all rounder in the data world! I wonder if there is anything he can’t do?

    Enterprise Data Platform (EDP)SAP Data IntegrationTechnical Advisory GovernancePower BI StorytellingAurion Data PipelinesExecutive Decision Support
    View on LinkedIn↗
  • VM
    Vaibhav (Vab) Mittal· 1st

    Country Head @Adactin

    November 21, 2023, Vaibhav (Vab) was senior to Balaji but didn’t manage Balaji directly

    Executive Key Takeaways

    • ✓Exceptional technical prowess across Azure Data Platform & Governance
    • ✓Translating complex raw data estates into actionable business value
    • ✓Engineering team mentorship and elevating delivery performance

    I highly recommend Balaji as a Senior Data Engineer. He demonstrated exceptional technical prowess, particularly in data engineering and governance using Microsoft Azure platform. What sets him apart is his ability to translate complex data into actionable business insights, driving significant value for our projects. His workmanship has also been instrumental in elevating our team's overall performance. Balaji is a true asset to any data-driven organisation.

    Microsoft Azure PlatformData EngineeringData GovernanceBusiness InsightsTeam Leadership
    View on LinkedIn↗
Show all recommendations →
Core Architecture Specializations

Enterprise Data & AI Delivery Track Record.

Primary focus on Enterprise Data Lakehouses (Fabric / Databricks / dbt) and Governed Agentic AI (MCP / LangGraph), backed by event-driven Azure integration and streaming security pipelines.

Select Architecture Track:Tap to switch ↓
Pillar 01 · Fabric vs. Databricks Split Study

Medallion Lakehouses, Legacy Migration & Governed Lineage

Architecting enterprise data estates across Microsoft Fabric and Databricks. Migrating siloed operational feeds, SAP ERP ledgers, and distributed data sources into unified bronze/silver/gold lakehouses with strict medallion boundaries, automated dbt transformations, and Kimball dimensional marts.

Medallion Lakehouse

Architecture

Zero-Copy DirectLake

Serving Mode

dbt + Purview

Lineage & Contracts

How it's delivered

  1. 1

    Context / Ingest

    Metadata-driven ingestion with Delta Parquet landing & automated schema drift detection

  2. 2

    Architecture / Conform

    dbt SQL transformations applying business contracts, deduplication & surrogate key hashing

  3. 3

    Outcome / Serve

    Gold dimensional models with zero-copy DirectLake serving to Power BI & downstream APIs

Explore Fabric vs. Databricks Studio ↗
Hire for this Pillar→

Delivery Framework

Architecture as an executable document.

Every engagement delivers decision records (ADRs), executable topology maps, and runbooks — not just ephemeral code.

01

Discover

Constraints, governance baselines, sovereignty and TCO mapped before a line of code.

02

Architect

Topologies and ADRs that make trade-offs explicit — vendor-neutral by default.

03

Build

Infrastructure-as-code, data pipelines, agents and automation shipped in thin slices.

04

Govern

Lineage, observability, RLS and runbooks so the system outlives the engagement.

Proof of work

Four products I've built and run.

Each one solves a real problem end to end, and shows how I would approach yours.

Data & Infrastructure as Code

LexiCanvas

Creator & Systems Architect

lexicanvas.com
The problem
Architecture diagrams drift away from what actually gets deployed.
What I built
A studio that turns visual architecture diagrams into Terraform code and security audits.
How it's built
  • Systems Architecture
  • IaC (Terraform)
  • Mermaid.js
  • STRIDE Threat Modeling
Read the brief →

Agentic AI & MCP

McpCognito.app

Lead Systems Architect

mcpcognito.app
The problem
AI agents call business tools with little visibility, control or cost discipline.
What I built
A control plane that adds access control, tracing and token-cost control for AI agents.
How it's built
  • Agentic AI
  • Model Context Protocol
  • TypeScript
  • Distributed Tracing
  • Go
Read the brief →

Cyber Threat Intelligence

SentrySurface.io

Lead Data & Security Architect

sentrysurface.io
The problem
Phishing and brand-impersonation sites appear faster than analysts can review them.
What I built
A pipeline that crawls, enriches and scores suspicious domains, then packages the evidence for takedown.
How it's built
  • DuckDB
  • Streaming Data
  • FastAPI
  • Cloud Run
  • MITRE ATT&CK
Read the brief →

Enterprise Workflow Automation

SurfaceProxy & SDD Workflow Engine

Principal Solutions Architect

proxy.sentrysurface.io
The problem
Legacy desktop bots are costly to run and break easily.
What I built
A proxy and governed workflow engine that replaces them with auditable, event-driven automation.
How it's built
  • Go Proxy
  • LLM Cost Optimization
  • Event-Driven Azure
  • Context Engineering
  • SDD Governance
Read the brief →

Role Fit & Engagement Options · Sydney & Canberra

Two ways to work together.

Join as a Principal / Lead Platform Engineer, or engage me for a fixed-scope review or build through Vertex Core Group. Contract arrangements are also available via the enquiry form.

Permanent / Fixed-Term Platform LeadImmediate Impact

Principal / Lead Data & AI Platform Engineering

Target: CIOs, CTOs, Chief Architects, Technology Delivery Directors & Executive Technical Search

Architect-led engagement owning the end-to-end build of your enterprise data platform. I lead the technical vision, drive the engineering execution, and embed best-practice delivery (dbt, Medallion, governance) directly into your team.

Core Deliverables

  • Multi-year Enterprise Data Platform (EDP) & Sovereign AI roadmap
  • Squad leadership, Analytics Engineering uplift & CI/CD standards
  • Executive stakeholder alignment, vendor TCO governance & FinOps
  • End-to-end security & data governance (Entra ID, Purview, Unity Catalog)

Fit: You are hiring a permanent or fixed-term Principal Architect / Platform Lead to anchor your data and AI practice.

Fixed-Scope Advisory · Vertex Core Group

Architecture Review & Milestone Delivery SOW

Target: Programme Directors, CDOs & Transformation Leads

Need a rapid independent audit or fixed-milestone delivery without headcount delay? Engaged via my incorporated consulting vehicle (Vertex Core Group) with clean ABN/SOW procurement.

Core Deliverables

  • 10-Day Fabric vs. Databricks Lakehouse TCO & Feasibility Audit
  • Target Reference Architecture, ADR Pack & Risk Register
  • Working production vertical slice (DirectLake mart or MCP agent gateway)
  • Reproducible Terraform / Bicep IaC & operational handover

Fit: You need an authoritative architectural blueprint or fixed-milestone build delivered under a clean corporate SOW.

Need a bespoke statement of work (SOW), government tender/RFP response, or custom rate card?

For technical reviewers

Interactive trade-off analysis, architecture diagrams and the delivery method behind the work above.

Systems Topology

Executable Architecture Diagrams

Interactive production blueprints — tap a component to trace its dependencies and inspect its 3-bullet ADR, drag to pan, or use the controls to zoom. Same documentation philosophy behind LexiCanvas.

Enterprise Data Architecture·Blueprint ID: edp-lakehouse

Enterprise Data Platform (Commonwealth Trade Agency Architecture)

Medallion Lakehouse topology integrating SAP, Aurion, and enterprise transactional stores with zero-copy DirectLake reporting.

Architecture Studio

Architecture Trade-Off Studio

Pick what matters to you. The recommendation re-weights live, so you see which option wins for your constraints, not just in general.

Data Platform assessment

Microsoft Fabric vs. Databricks Lakehouse

Architectural comparison for modern enterprise lakehouse migrations (Teradata / SSIS / Oracle offload).

SaaS Lakehouse

Microsoft Fabric

Managed Multi-Cloud

Databricks Lakehouse

45% fit (Microsoft)55% fit (Databricks)

Leaning: Databricks Lakehouse

Select Fabric for Microsoft-centric enterprise reporting consolidation and SaaS simplicity; select Databricks for multi-cloud heavy ETL, streaming analytics, and deep custom AI/ML pipelines.

What matters most to you? (tap to weight ×3)

  • Power BI fit
  • Heavy ETL / streaming
  • Multi-cloud
  • Time to value
  • Platform control

Field Notes & Decision Records (ADRs)

Architecture Briefs.

Executive white papers and Decision Records (ADRs) on platform collisions, real production TCO, and modern sovereign AI governance.

Enterprise Data Lakehouse6 min read

Microsoft Fabric vs. Databricks Lakehouse in Production

Choose Microsoft Fabric to consolidate enterprise M365 and Power BI reporting estates under turnkey SaaS economics; retain Databricks for multi-cloud, high-throughput Spark streaming, deep ML modeling, and complex Photon-vectorized ETL.

Read Brief→
Enterprise AI & Automation5 min read

The 2026 Enterprise Automation Triad

Legacy RPA (UiPath) must be strictly isolated to non-API desktop windows. Databricks AI Gateway governs the data estate and model serving layer. Microsoft Copilot Studio and Foundry own the employee workspace. The glue connecting them is event-driven Model Context Protocol (MCP) agents.

Read Brief→
Agentic Systems & MCP4 min read

The Death of the VM Bot Farm

Legacy VM bot farms run up massive recurring licensing and maintenance bills while remaining brittle to UI changes. Migrating document reconciliation and data extraction to headless MCP agent swarms substantially cuts annual run-rate costs while handling fuzzy, unstructured edge cases with ease.

Read Brief→

Need an independent architectural verdict for your board or cloud steering committee?

Vendor-neutral audits on Fabric, Databricks TCO, and Sovereign MCP Agent security.

Direct Availability · Contract, Leadership & Advisory

Hiring a Principal Data & AI Engineer? Let's talk.

Direct access—zero agency bloat. Available immediately for Principal / Lead Contract roles (Day-Rate, PAYG, Pty Ltd ABN, or BuyICT), executive permanent leadership, or fixed-scope architecture sprints via Vertex Core Group.

Footprint: Sydney | Canberra (On-Site / Hybrid / Remote)
Vehicles: Contract / Labour Hire, BuyICT, Milestone SOW
Governance: ISM / PSPF / Formal SDD & ADR Baselines
1. Select Engagement Vehicle

Direct to Principal Architect · NDA-ready · Response within 24 business hours