Available for strategic engagements

Anshul Agrawal

Senior Data Engineer & BI Architect

Transforming complex data ecosystems into clear, actionable intelligence — one pipeline at a time.

Scroll to explore
11+
Years of Experience
30%
Avg Performance Gain
7+
Professionals Mentored
20%
Cost Reduction Delivered

Building Data Systems That Last

I'm a Senior Data Engineer and BI Architect with over a decade of experience designing and delivering enterprise-grade data solutions across aviation, consulting, and technology. I specialise in the full data value chain — from raw ingestion and pipeline architecture to executive-level dashboards that drive real decisions.

At SITA, I lead the architecture of real-time data pipelines and business intelligence systems that power operations for airports and airlines globally. My work touches everything from dbt-modelled Snowflake layers to Tableau dashboards reviewed in the C-suite — always with an eye on performance, reliability, and cost efficiency.

Beyond the technical work, I'm passionate about building data-forward teams. I've mentored 7+ data professionals and contribute to the broader community through AekMak — my platform for data engineering insights, tools, and SaaS products built for practitioners.

Quick Profile
Role Sr. Data Engineer & BI Architect
Company SITA
Location Montreal, QC · Remote-first
Status ● Open to Select Opportunities
Certifications
AWS Certified Azure Data Engineer dbt Core Tableau Specialist

11+ Years of Impact

Jan 2021 — Present
SITA
Senior Data Engineer & BI Architect
  • Architect and maintain enterprise-scale data pipelines processing millions of aviation events daily across 200+ airports worldwide
  • Led migration from legacy reporting stack to dbt + Snowflake, improving query performance by 30% and cutting pipeline maintenance overhead by 40%
  • Design and own the BI layer serving C-suite dashboards in Tableau and Power BI — translating operational telemetry into strategic insight
  • Reduced cloud infrastructure costs by 20% through query optimisation, resource tiering, and warehouse scheduling
  • Mentor 5+ junior data engineers; established team-wide standards for CI/CD, data quality testing, and documentation
Mar 2018 — Dec 2020
SITA
Business Intelligence Analyst
  • Built and maintained Tableau and Power BI dashboards consumed by operations and product teams across 3 global regions
  • Developed SQL-based ETL workflows to consolidate data from 6+ source systems into a unified reporting layer
  • Led requirements-gathering sessions with business stakeholders to define KPI frameworks and self-service reporting standards
  • Mentored 2 junior analysts on SQL best practices and Tableau development patterns
Jun 2016 — Feb 2018
Deloitte
Data & Analytics Consultant
  • Delivered data analytics engagements for clients in financial services and public sector — from requirements through production delivery
  • Designed dimensional data models and built SSRS / SSAS-based reporting suites for enterprise clients with 10K+ users
  • Partnered with client leads to define data governance standards, data lineage documentation, and report catalogues
Aug 2014 — May 2016
HCL Technologies
Software Engineer — Data
  • Built ETL pipelines using Informatica PowerCenter for a global retail analytics platform processing nightly batch loads
  • Maintained Oracle-based data warehouse schemas supporting sales, inventory, and supply-chain reporting
  • Collaborated with onshore teams in Agile sprints to deliver bi-weekly data product releases
Jul 2012 — Jul 2014
Tata Consultancy Services (TCS)
Systems Engineer
  • Worked on data migration and integration projects for banking and insurance clients across India and APAC
  • Wrote PL/SQL procedures and shell scripts for batch data processing and reconciliation workflows
  • Gained foundational experience in enterprise data architecture, SDLC methodologies, and client stakeholder communication

Technical Skills

📊

Business Intelligence

Tableau Power BI Looker SSRS SSAS KPI Design Data Storytelling Self-Service Analytics
⚙️

Data Engineering

dbt Snowflake Apache Spark Airflow Kafka Informatica ETL / ELT Data Modelling
☁️

Cloud & DevOps

AWS Azure GCP Terraform Docker GitHub Actions CI/CD
🛠️

Development

Python SQL PL/SQL Bash REST APIs FastAPI Git

What I'm Building

● Live

AekMak Platform

A SaaS platform for data professionals — tools, templates, and frameworks to accelerate BI & data engineering workflows. Built and maintained as a personal product alongside a full-time engineering role.

SaaS Python Cloudflare Pages Vanilla JS
● Live

AekMak Data Journal

A curated publication covering data engineering patterns, BI best practices, and hard-won lessons from the field — written for practitioners who build rather than theorise.

Content LinkedIn Newsletter
◐ In Development

WS_ShreeJi Dashboard

A bespoke business intelligence dashboard built for a private client — covering operational KPIs, inventory flow, and financial performance in a single unified view.

Tableau SQL Client Work

Let's Work Together

Whether you're modernising a data stack, building a BI foundation from scratch, or just want to talk shop — I'm always open to a good conversation.

AekMak Workspace