Work Preference
Summary
Overview
Work History
Education
Skills
Certification
Languages
Personal Information
Additional Information
Timeline
Generic
Subhodeep Chakraborty
Open To Work

Subhodeep Chakraborty

KOLKATA

Work Preference

Job Search Status

Open to work
Desired start date: Flexible

Desired Job Title

Associate Manager - DeliveryTechnical Lead/Data EngineerProject ManagerBusiness AnalystDelivery Manager

Work Type

Full TimeContract WorkPart Time

Location Preference

RemoteHybridOn-Site
Location: KOLKATA, INPune, MHHyderabad, TGBengaluru, KA
Open to relocation: Yes

Salary Range

₹199000/yr - ₹200000/yr

Important To Me

Work from home optionHealthcare benefitsPaid time off4-day work weekPersonal development programsCareer advancementWork-life balanceCompany CultureFlexible work hoursTeam Building / Company RetreatsPaid sick leave401k matchStock Options / Equity / Profit Sharing

Summary

Senior Data Engineering Leader/manager with 9+ years of experience delivering Azure Databricks Lakehouse and Data Warehouse modernization programs in US Healthcare, Pharma, and Insurance domains. Expert in Databricks Asset Bundles, Unity Catalog, CI/CD automation, Spark optimization, and Azure cost governance. Proven ability to reduce cloud spend by 20%, modernize legacy workloads, and lead distributed teams delivering HIPAA-compliant analytics platforms.

Overview

10
10
years of professional experience
2
2
Certifications

Work History

Associate Manager - Delivery

Optiks Innovations Pvt ltd.(P360)
Mumbai
04.2025 - Current
  • Architected and delivered an enterprise-scale Azure Databricks Lakehouse platform using Unity Catalog, supporting HIPAA-compliant PHI/PII workloads.
  • Led 20+ global resources across Data Engineering, QA, and BI, ensuring predictable delivery across multiple client programs.
  • Designed and implemented CI/CD pipelines using Azure DevOps and Databricks Asset Bundles, enabling automated promotion across DEV/QA/PROD.
  • Achieved ~20% Azure cost reduction through Databricks workload optimization, cluster right-sizing, and elimination of inefficient Azure SQL workloads.
  • Improved end-to-end pipeline performance by ~20% by migrating long-running SQL-based processes to Spark-based Databricks workflows.
  • Established enterprise governance using Unity Catalog, RBAC, secure external locations, and audit-ready access controls.

Technical Lead/Data Engineer

Optiks Innovations Pvt ltd.(P360)
Mumbai
09.2019 - 03.2025
  • Designed and implemented enterprise Data Warehouses and Lakehouses using Azure Databricks, ADF, Synapse, and ADLS Gen2.
  • Led modernization initiatives migrating legacy Azure SQL and on-prem ETL pipelines to Databricks Spark, improving scalability and runtime efficiency.
  • Built parameterized Databricks workflows, job orchestration, and environment-aware deployments for production stability.
  • Optimized Spark jobs using partitioning strategies, efficient file formats, and performance tuning best practices.
  • Supported US Pharma commercial datasets (HCP, HCO, Rx, Claims, Alignments, Targets) and customer mastering initiatives.
  • Acted as primary technical interface for US-based stakeholders and product owners.

Freelance Data Consultant

Currimjee Informatics
01.2022 - 01.2024
  • Delivered end-to-end Data Warehouse solutions on on-premise SQL Server environments for African clients in the insurance domain.
  • Developed and optimized complex reports, including waterfall models tailored for insurance operations in SWAN.
  • Interacted directly with business stakeholders and gathered requirements during on-site client visits.
  • Ensured high-performance data pipelines, robust reporting, and seamless integration with existing systems.

System Engineer

Tata Consultancy Services
Kolkata
07.2016 - 09.2019
  • Supported enterprise BI platforms and production analytics systems.
  • Delivered Cognos BI upgrade and report migration initiatives.
  • Contributed to Big Data migration programs involving Hive, metadata modeling, and data quality remediation.

Education

Bachelor of Technology - Computer Science

Sikhsha O Anusandhan University
Bhubaneswar
05.2016

Higher Secondary - Science

St Pauls School
Rourkela
05.2012

Skills

CORE SKILLS

  • Cloud & Data: Azure Databricks, Delta Lake, Unity Catalog, ADLS Gen2, Azure Synapse
  • Engineering: Spark Optimization, Lakehouse Architecture, Data Modeling, ETL/ELT
  • Automation & DevOps: Databricks Asset Bundles, Azure DevOps, CI/CD, Git, YAML
  • Security & Governance: RBAC, PHI/PII, HIPAA, External Locations, Audit Controls
  • Business Domains: US Healthcare, Pharma Commercial, MDM, Insurance Analytics
  • Leadership: Global Team Leadership (20), Stakeholder Management, Delivery Ownership

Certification

  • Microsoft Certified: Azure Data Fundamentals, Microsoft, 06/01/21
  • Microsoft Certified: Azure Fundamentals, Microsoft, 02/01/21
  • Microsoft Certified: Azure Virtual Desktop Specialty, Microsoft, 09/01/23

Languages

English

Personal Information

Title: Associate Manager - Delivery

Additional Information

Indian Citizen | USA B1/B2 Visa Holder, 30 to 90 days | Open to Remote International Roles

Timeline

Associate Manager - Delivery

Optiks Innovations Pvt ltd.(P360)
04.2025 - Current

Freelance Data Consultant

Currimjee Informatics
01.2022 - 01.2024

Technical Lead/Data Engineer

Optiks Innovations Pvt ltd.(P360)
09.2019 - 03.2025

System Engineer

Tata Consultancy Services
07.2016 - 09.2019

Bachelor of Technology - Computer Science

Sikhsha O Anusandhan University

Higher Secondary - Science

St Pauls School
Subhodeep Chakraborty