Anjali

Data engineer, built on Microsoft Fabric

I am a Data Engineer with 5 years in data analytics: Power BI, SQL, Python, and Advanced Excel, building dashboards and automating reporting that was slow or repetitive. That background shapes how I work now: I understand the reporting problem first, then work backward into the data and engineering needed to solve it.

Most of that work has been enterprise HR and talent analytics: dashboards, semantic models and DAX measures that people run their week on. The first three years were ADF orchestration, Power Query transformations, and Azure SQL pipelines built to feed them.

From June 2024 I worked in Microsoft Fabric and Databricks, leading Fabric adoption with medallion batch platforms, Delta Lake Liquid Clustering, metadata-driven ForEach frameworks, and SCD Type 2 dimension management. The case studies on this site document how those decisions get made: from reporting and analytics to engineering the data systems behind them.

In September 2026 I earned the Microsoft Certified: Fabric Data Engineer Associate (DP-700).

View resumeGet in touch

Portrait of Anjali

Work history

  1. 07/2022 – 09/2026

    Sr. Associate, Analytics

    Think Talent Services

    • Built a medallion (Bronze-Silver-Gold) pipeline on Microsoft Fabric using Data Factory to ingest and consolidate internal and external partner assessment data, processing millions of records and cutting manual file processing by 80%, delivering analysis-ready Gold-tier datasets that powered 9-box potential mapping and new-hire benchmarking.
    • Built a metadata-driven pipeline framework using ForEach activities with dynamic content expressions, reading source table configurations from a control Delta table, simplifying onboarding of new talent data sources (LMS, performance management system, assessment platforms) without pipeline code changes.
    • Designed SCD Type 2 dimension management for dim_employee and dim_position using Delta MERGE, preserving 2 years of historical career and role change history (promotions, transfers, band changes) with is_current flags and start/end date assignment for point-in-time reporting.
    • Built ADF batch pipelines to ingest daily performance, engagement, and hiring data from 3 business units into Azure SQL staging tables, feeding Power BI Premium semantic models refreshed each morning for 15 HRBPs and talent leads.
    • Designed Power BI semantic models with DAX measures for promotion rate, internal mobility rate, and high-potential (HiPo) coverage, powering 8 reports serving 15 users.
    • Developed Power Query (M) transformations within ADF Mapping Data Flows to apply business rules, deduplicate records, and enforce schema across 4 source tables (appraisal, 9-box, IDP, succession) prior to loading into Azure SQL.
    • Built parameterised ADF ForEach pipelines with retry logic and on-failure email alerts, significantly reducing pipeline failure response time across hiring, succession review, and appraisal cycle reporting.
    • Implemented timestamp watermark CDC in ADF to pull only changed rows from Azure SQL on each nightly run, across hiring, onboarding assessments, internal talent grooming and succession reviews, and quarterly feedback cycles, reducing source query load by around 55% during peak activity periods.

  2. 03/2022 – 06/2022

    Data Intern

    Think Talent Services

    • Streamlined reporting pipelines and enhanced analytics by implementing Excel M-Query and DAX.
    • Reduced team reporting workload by 4 hours weekly through the creation of macro-enabled templates.
    • Boosted client engagement by 11% with the development of an interactive Power BI dashboard.

  3. 06/2021 – 03/2022

    Statistics Tutor

    Tutor Eye

    • Executed Exploratory Data Analysis (EDA) using Python to extract valuable data insights, directly contributing to improved student performance and educational success.

Academic background

  • 05/2021

    Master of Science (MSc), Statistics and Data Analytics

    Lovely Professional University, Jalandhar · CGPA 8.72

  • 09/2015

    Bachelor of Science (BSc), Mathematics (Hons)

    Mahant Das Darshan Mahila College · 71.88%

Certifications

  • Microsoft Certified: Fabric Data Engineer Associate

    Microsoft

    Issued 28 September 2026

    Certificate: Microsoft Certified: Fabric Data Engineer Associate, issued by Microsoft

  • Professional Certificate Course in Generative AI and Machine Learning

    E & ICT Academy, IIT Kanpur (a joint initiative of MeitY & IIT Kanpur)

    Issued 29 May 2025

    Certificate: Professional Certificate Course in Generative AI and Machine Learning, issued by E & ICT Academy, IIT Kanpur (a joint initiative of MeitY & IIT Kanpur)

Skills

Microsoft Fabric

  • Data Factory
  • Lakehouse
  • Warehouse
  • OneLake
  • Dataflow Gen2
  • Tumbling window triggers
  • ForEach
  • Direct Lake
  • Monitoring Hub

Azure Data Factory

  • Metadata-driven pipelines
  • ForEach
  • Copy activity
  • Event-based triggers
  • Linked services
  • ADLS Gen2
  • Azure SQL

Delta Lake

  • Liquid Clustering
  • Z-Ordering
  • Partitioning
  • OPTIMIZE
  • VACUUM
  • MERGE
  • Time travel
  • V-Order
  • SCD Type 2

Power BI, DAX and Excel

  • Semantic models
  • DAX measures
  • Power Query (M)
  • Power BI Dataflows Gen1
  • Incremental refresh
  • Row-level security
  • Advanced Excel

Python, PySpark and SQL

  • Python
  • Databricks
  • Window functions
  • AQE
  • Broadcast joins
  • Predicate pushdown
  • T-SQL MERGE
  • CTEs
  • Dynamic content expressions

Data Modelling

  • Star schema
  • SCD Type 2
  • Accumulating snapshot facts
  • 3NF to Gold denormalisation