AR.

Dubai, UAE

Amit Roy

Data Solutions Manager · Senior Data Engineer

I design and deliver enterprise data platforms, lakehouses and executive-grade analytics on Azure, Databricks and Power BI, turning messy, multi-system data into decisions leaders can trust.

Get in touch LinkedIn ↗
Portrait of Amit Roy
  • 13years in data & analytics
  • 50+production pipelines built
  • 20+clients on a platform I helped build
  • 3regions: UAE · USA · India

About

I'm a Senior Data & Analytics Engineer with 13 years of experience designing and delivering enterprise BI, cloud data platforms and AI-enabled solutions. I work across the Azure Data Platform, Databricks, the SQL Server BI stack, Power BI, Salesforce Analytics and SAP Analytics Cloud, and I lead solutions end to end, from architecture through to production.

I partner with senior stakeholders across the UAE, USA and India to build scalable, governance-ready platforms. My focus is high-performance, cost-optimised, production-grade delivery, along with mentoring the engineers who run these platforms day to day.

Expertise

Lakehouse & Data Engineering

Databricks Lakehouse, Delta Lake, Delta Live Tables, Unity Catalog, medallion architecture, Auto Loader, Azure Data Factory, PySpark, Spark SQL, Microsoft Fabric.

Data Architecture & Modelling

Enterprise data warehouses, dimensional modelling, SSAS (Tabular & Multidimensional), DAX, MDX, Erwin, governance and RBAC design.

BI & Executive Analytics

Power BI (incl. Direct Lake), SSRS, Tableau, Salesforce Analytics Studio, SAP Analytics Cloud, FP&A and performance reporting.

AI & Automation

Databricks Mosaic AI, RAG solutions, Copilot-enabled workflows, Power Automate and Power Apps agents.

Cloud & Platforms

Azure SQL / DW, ADLS Gen2, SQL Server, Oracle, SAP HANA, AWS (S3, Athena, Glue, Lambda, Step Functions), CI/CD.

Delivery & Leadership

Solution architecture, team leadership, stakeholder management, onshore–offshore delivery, large-scale data migration. Python, SQL, C#.

Experience

  1. Manager

    Sep 2026 – Present

    PwC Middle East · Dubai

  2. Audit Data Analytics Lead

    Jun 2026 – Aug 2026

    Juma Al Majid · Dubai

  3. Data & AI Solution Lead

    Sep 2024 – May 2026

    Strategy& Middle East · Dubai

  4. Senior Data Engineer

    Feb 2021 – Sep 2024

    PwC Middle East · Dubai

  5. Senior Data Analyst

    Jun 2020 – Feb 2021

    Cognizant · Kolkata

  6. Senior Data Analyst

    Oct 2015 – May 2020

    PwC India · Kolkata

  7. Application Developer

    Jun 2013 – Sep 2015

    IBM · Kolkata

Selected work

Strategy& Middle East

Enterprise Databricks Lakehouse & Digital AI Solutions

  • Led implementation of an enterprise Databricks Lakehouse with Unity Catalog governance, RBAC, cluster policies and Key Vault-backed secret scopes.
  • Built 50+ production pipelines orchestrated by Azure Data Factory with PySpark notebooks and Delta Live Tables.
  • Owned end-to-end architecture: data modelling, workspace design, integration patterns, reporting and CI/CD deployment.
  • Extended the platform with Power BI Direct Lake, Power Automate and Power Apps agents; coached engineers on Lakehouse best practices.

DatabricksUnity CatalogDelta Live TablesADFPower BICI/CD

Juma Al Majid

Continuous Monitoring Framework for Audit Analytics

  • Architected automated ETL/ELT pipelines integrating Oracle, Yardi, Odoo and Keyloop ERPs via Azure Data Factory and SQL Server.
  • Enabled exception-based and population-level audit testing across four business units: Commercial, Real Estate, C&S and Oman.
  • Ran cost analysis to keep the solution scalable and cost-effective.

ADFDatabricksArbutusPower BIAzure SQL

PwC Middle East

Enterprise Data & FP&A Analytics Transformation

  • Architected and built an enterprise data warehouse from scratch, unifying multiple source systems for executive and FP&A reporting.
  • Led a 10-member ETL team delivering production-grade datasets behind leadership dashboards.
  • Owned the FP&A analytics platform used for executive reporting and recurring performance packs.

Azure SQLADFDatabricksPower BISalesforceSSIS

PwC Middle East · Current

Data & AI Programmes

  • Leading the data team on large-scale data initiatives and migrations.
  • Defining data requirements and delivery roadmaps with business and technical stakeholders.
  • Supporting enterprise data warehousing, reporting, data quality and RAG-based AI solutions.

Databricks Mosaic AIRAGADFPower BI

Cognizant

Cloud Data Warehouse for a Pharmaceutical Client

  • Built a cloud data warehouse on AWS for Bayer, integrating data from multiple source systems.
  • Optimised Athena SQL and orchestrated workflows with Step Functions; automated S3 file generation with Lambda and YAML config.
  • Loaded curated customer datasets into SAP HANA for enterprise reporting.

AWS S3AthenaGlueLambdaSAP HANA

PwC India

Data Engineering, Analytics & Migration

  • Helped build a proprietary ETL and reporting platform on Azure Data Factory and Azure DW, supporting 20+ clients across industries.
  • Designed a generalised SSIS framework for an indirect-tax analytics platform covering GST, corporate tax and transfer pricing.
  • SSIS and PDW consultant for Dubai's Road and Transport Authority, delivering KPI-driven BI reporting; supported pharma data migration (Lonza).

ADFAzure DWSSISPDWPower BI

Earlier: enterprise MSBI reporting (SSIS, SSAS, SSRS) for Philip Morris International at IBM.

Education

B.E. in Computer Science and Technology

Indian Institute of Engineering Science and Technology, Shibpur · 2009 – 2013

Let's talk data.

Open to conversations about data platforms, lakehouse modernisation, analytics and AI. The quickest way to reach me is email or LinkedIn.

amit@amitroy.app Connect on LinkedIn ↗