Kapil Pahuja

Strategic Platform Leadership

• Built the cloud strategy and technical roadmap for BCBMSA’s next-generation analytics platform, aligning architecture with enterprise business needs.
• Designed the cloud-native architecture for the Analytics Data Hub (ADH), establishing the foundation for a fully Snowflake-based enterprise data platform.
• Presented ADH strategy, roadmap, and investment case to VPs and Senior Directors, securing approval for the multi-year $17M enterprise funding required to build and scale the platform.

ADH Migration & Platform Modernization

• Lead enterprise-wide migration from the legacy Netezza EDW to the Snowflake-based ADH, modernizing 230+ data products and 50+ BI applications.
• Drive FinOps accountability via warehouse-level cost attribution, workload optimization, and executive consumption reporting.
• Enable secure API-driven consumption through Apigee–Snowflake integration for external-facing and partner data products.
• Establish enterprise data quality frameworks, governance models, SLOs, and domain ownership standards.
• Building a semantic-layer-powered Snowflake Agent with Architecture to support Snowflake AI/Cortex and future enterprise AI/GenAI use cases, including Gemini integration via MCP server or Agent-to-Agent patterns.
• Lead the User Success program, ensuring platform adoption, onboarding, and readiness for 800+ analytics and business users.

Value Stream & Business Leadership

• Serve as Value Stream Lead and primary partner for the Performance Measurement & Innovation (PMI) business unit.
• Lead modernization and migration of the HEDIS Data Mart from DB2 to Snowflake with enhanced structural quality and audit readiness.
• Deliver MyBlue digital enhancements in partnership with ET Digital, CX, and Product teams, including LGBTQI+ Care Center, REL capture, and UX/content improvements.

• Managed teams of engineers, architects, analysts, and PMs delivering enterprise analytical and data capabilities.
• Partnered with business, product, and analytics leaders to shape analytics platform evolution and modernization.
• Delivered scalable lakehouse ingestion patterns using AWS DMS, Lambda, Informatica/IICS, Airflow, SQS, and Snowflake for near–real-time and batch workloads.
• Built a full-text analytics solution leveraging Amazon Comprehend + OpenSearch to analyze call-center transcripts and operational insights.
• Led cloud data warehouse POCs (Snowflake vs Redshift vs BigQuery) and delivered architectural recommendations used in strategic planning.
• Engineered cost-efficient EMR/PySpark pipelines to support high-volume batch processing.
• Developed ingestion roadmaps for Hadoop/EMR using Python, S3, Hive, Oozie, Athena, and Spark.
• Built strong cross-functional partnerships with business leaders, product managers, and data scientists.
• Led initiatives yielding $15M+ in future cost avoidance through optimized cloud strategy and platform consolidation.
• Supported early hybrid analytics-to-cloud migration strategies that evolved into today’s ADH architecture.

• Led architecture across 10+ enterprise-critical applications including Membership, QEDM, and HIA 2.0.
• Delivered solution designs, architectural reviews, and technology leadership.
• Led Hadoop ETL tool evaluations; collaborated with infrastructure, vendors, and governance teams.
• Mentored ETL engineers and received CIO-level recognition for delivery excellence and innovation.

• Redesigned Enrollment, Provider, and EMS dimensions on Netezza from DB2.
• Developed ODI packages, interfaces, validation plans, and test processes.
• Integrated host membership data into the enterprise data warehouse.
• Built wellness eligibility extracts supporting employer and member engagement.