Data Architect & Engineering Lead - Healthcare & Cloud Platforms

MITUL PANCHAL

Data Architect Data Engineering Lead (Homecare Domain Specialist)

Chicago, IL, USA

+1-872-***-**** *****.*********@*****.***

PROFESSIONAL SUMMARY

Solution Architect and Data Engineering Lead with 10+ years of experience designing and delivering secure, HIPAA-compliant cloud-native data platforms across healthcare payer/provider ecosystems and other regulated environments handling PHI. Extensive hands-on expertise across Snowflake, Azure, and AWS, with a strong focus on enterprise data architecture, ELT/ETL pipelines, data modeling, cloud migrations, security, and cost and performance optimization. Proven track record supporting large-scale analytics, BI, and enterprise reporting in Healthcare and E-commerce domains, while leading cross- functional teams, driving DevOps best practices, and delivering scalable, reliable, and high-performance data solutions that power actionable business insights. CORE COMPETENCIES

• Data Architecture & Cloud Data Platforms

• Snowflake (Performance Tuning, Security, Cost Optimization, Data Sharing)

• Azure (ADF, ADLS Gen2, Synapse, Functions, Databricks)

• AWS (MWAA, Glue, Redshift, EMR, Step Functions, OpenSearch, S3, KMS, IAM, DynamoDB)

• ELT / ETL Pipeline Design (Batch & Near Real-Time, Event-Driven Architectures)

• Data Modeling (Star, Snowflake, Dimensional, Canonical Enterprise Models)

• SQL (T-SQL), Python

• BI & Analytics Enablement (Power BI, SSRS, SSAS)

• CI/CD & DevOps (GitHub Actions, Azure DevOps, Terraform, Infrastructure as Code)

• Data Governance, Security & Compliance

• Master & Reference Data Management (Golden record concepts, survivorship rules)

• Technical Leadership & Stakeholder Management

• Data Quality & Validation (Great Expectations, custom rule-based frameworks, reconciliation checks)

• Secrets & Key Management (Azure Key Vault, AWS KMS)

• Data Lineage, Access Controls & Auditing (RBAC, row/column-level security, SOX, PII & HIPAA compliance)

PROFESSIONAL EXPERIENCE

Data Architect Snowflake & Azure Cloud (Homecare and Home Health) Inferenz Tech Pvt Ltd Chicago, IL, USA

Apr 2022 – Present

• Architected and delivered enterprise-scale cloud data platforms using Snowflake on Azure, enabling analytics, BI, and regulatory reporting.

• Hands-on architects across Azure and Snowflake/Databricks, designing enterprise data lake and data platform patterns, integrating EMR systems (including Homecare Homebase), and implementing robust identity, access, and secrets management.

• Led data and platform integration efforts for M&A initiatives across home health and home care organizations nationwide, aligning acquired entities with enterprise data, reporting, and operational standards.

• Led and mentored a team of data engineers to design and maintain end-to-end ELT pipelines across Azure and AWS with high availability and scalability.

• Designed ingestion frameworks using Azure Data Factory, Snowpipe, and Azure Data Lake Gen2, supporting structured and semi-structured data sources.

• Developed optimized fact and dimension data models to support healthcare analytics, reporting, and downstream BI tools.

• Designed and implemented custom data deduplication logic using deterministic and fuzzy-matching techniques to enforce golden records across healthcare and operational data domains.

• Experienced technical leader defining reference architectures, governing API and event-driven solution designs across distributed teams, and aligning with executive leadership to achieve stringent availability, performance, and resilience of NFRs.

• Partnered with finance, compliance, and audit teams to ensure SOX-compliant data controls, audit-ready reporting, and governance throughout post-merger system and data integrations.

• Implemented enterprise security and governance using Azure AD integration, RBAC, masking policies, and row-level security in Snowflake.

• Improved query performance and reduced cloud cost through warehouse right- sizing, clustering strategies, and workload isolation.

• Enabled seamless integration with Power BI, supporting executive dashboards and operational reporting.

• Established CI/CD pipelines using GitHub Actions, Terraform, and Azure DevOps to automate deployments and improve release reliability.

• Owned release management lifecycle, coordinating cross-functional teams, managing risks, and leading successful Go-Live deployments.

• Supported internal and external audits by implementing robust access controls, lineage, and data validation frameworks, ensuring compliance with SOX, HIPAA, and enterprise risk requirements.

• Maintained architectural documentation, deployment standards, and operational runbooks in Confluence.

Senior Data Engineer (E-commerce)

Bharti Soft Tech Pvt Ltd

Aug 2021 – Apr 2022

• Designed and implemented ETL pipelines using SSIS to migrate and centralize data from MySQL and other sources into SQL Server data warehouses.

• Partnered with business stakeholders to translate requirements into scalable data and reporting solutions.

• Optimized SQL queries, views, functions, and stored procedures to improve performance and reporting latency.

• Built Power BI dashboards and KPIs across Sales, Orders, Logistics, Sellers, and Customer analytics.

• Developed SSRS reports for customer behavior, product segmentation, and regional analysis.

• Delivered self-service BI solutions enabling business users to independently explore and analyze data.

Engineer – Data & BI

eInfochips Pvt Ltd

Jan 2018 – Aug 2021

• Developed data integration and reporting solutions using SSIS, SSRS, and SSAS.

• Built and optimized SQL Server solutions using advanced T-SQL, including stored procedures, CTEs, triggers, and performance tuning techniques.

• Worked with multiple database platforms including Oracle, DB2, MySQL, and SQL Server.

• Migrated legacy BI reports to SSRS and implemented automated report subscriptions.

• Supported enterprise BI initiatives across healthcare, finance, and academic environments.

Engineer – IT Systems

Infinity Solution

May 2015 – Apr 2016

• Supported enterprise IT systems, application development, and database reporting.

• Developed internal applications using ASP.NET MVC and SQL Server.

• Managed infrastructure upgrades, deployments, and technical support activities. TECHNOLOGY STACK

Data Warehousing: Snowflake, Azure Synapse

Databases: SQL Server, MySQL, PostgreSQL, Oracle, DB2 Cloud Platforms: Microsoft Azure, AWS

ETL / ELT: Azure Data Factory, SSIS, Snowpipe, AWS Glue BI & Reporting: Power BI, SSRS, SSAS

DevOps & CI/CD: GitHub Actions, Azure DevOps, Terraform Version Control & Tools: GitHub, TFS, Jira, Confluence, VS Code EDUCATION

Master of Computer Science & Engineering

Ahmedabad University – School of Engineering and Applied Science Bachelor of Information Technology

Government Engineering College, Modasa (Gujarat Technological University) CERTIFICATIONS

• Microsoft Data Warehouse Designing

• Microsoft Azure Fundamentals

• AWS Cloud Practitioner

TARGET ROLES

Data Architect Lead Data Engineer Data Engineering Manager

Contact this candidate