Santosh Tripathy

About Santosh Tripathy

Staff Engineer | Software-First Data EngineeringI don’t just build data pipelines; I build AI-ready data foundations with the rigor of high-performance software engineering. With 17+ years across FinTech, Healthcare, and Insurance, I bridge the gap between complex backend architecture (.NET/AWS) and the Modern Data Stack (Snowflake/dbt).Currently, as AVP Tech Lead at LPL Financial, I am focused on the \"Software-ization\" of Data—applying CI/CD, unit testing, and design patterns to Snowflake Medallion architectures to turn \"messy data\" into governed, high-velocity business assets. The 2026 Value Proposition:DataOps Mastery: Architected Medallion (Bronze/Silver/Gold) platforms using Snowflake, dbt Core (Semantic Layer), and Airflow, reducing client onboarding from months to days.Cost & Governance (FinOps): Expert in Snowflake Horizon and Protegrity integration. I’ve delivered a 20% reduction in warehouse operational costs through metadata-driven design and Zero-Copy Cloning.AI-Accelerated Delivery: I don’t just use AI; I integrate it. I’ve boosted team velocity by 40% by rolling out Cursor AI and GitHub Copilot while piloting Agentic AI workflows (LangChain/CrewAI) for automated DataOps and root-cause analysis.Hybrid Architecture: 15+ years of.NET Core & AWS (SAA-C03) means I build the APIs that consume the data. I eliminate BI bottlenecks by serving Gold-layer data directly to custom Angular/React frameworks. Technical Arsenal:Data: Snowflake (Cortex, Data Share, Snowpipe, Masking), dbt, AWS Glue, Airflow (MWAA).Software.NET 10/Core, Angular, Microservices, RESTful APIs, SignalR.Cloud/DevOps: AWS (EKS, Lambda, Terraform, EventBridge), GitHub Actions, CI/CD.Next-Gen: LangChain, CrewAI, Vector Databases, Prompt Engineering. Certified: SnowPro Core (COF-C02)| AWS Solutions Architect (SAA-C03)| Azure Data Fundamentals.I am passionate about building \"un-layoffable\" engineering cultures where AI tools and software best practices meet massive-scale data.Let’s connect if you’re looking for a Principal or Staff Lead to architect your next-gen data platform.

Experience

1. Assistant Vice President

   LPL Financial

   Sep 2025 — Present · Fort Mill, SC, US

   Platform Architecture: Architected a Medallion (Bronze → Silver → Gold) data platform on Snowflake, leveraging S3 External Stages and Snowpipe for automated ingestion. Semantic Layer & DataOps: Developed complex dbt Core models utilizing incremental materializations and snapshots to build a robust Semantic Layer for financial reporting. Data Mesh & Distribution: Implemented Snowflake Data Share to enable zero-copy, governed distribution of curated datasets, eliminating ETL duplication and achieving near-real-time delivery. Infrastructure as Code (IaC): Led on-prem to AWS migration using EKS and Terraform to build scalable, cloud-native platform components. Advanced Security & Governance: Integrated Protegrity for tokenization and implemented Dynamic Data Masking and RBAC to ensure enterprise-grade PII protection and column-level access control. Environment Optimization: Utilized Zero-Copy Cloning to provision instant, isolated environments (Dev/Test/UAT), cutting setup time from days to minutes and reducing storage overhead. AI Integration: Leveraged Snowflake Cortex AI (SUMMARIZE, COMPLETE) to embed LLM-powered anomaly explanation and query analysis directly into SQL pipelines. Dev Acceleration: Drove a 40%+ improvement in team velocity by championing Cursor AI and GitHub Copilot adoption across the engineering lifecycle. Leadership: Mentored global offshore teams and led Agile ceremonies to ensure on-time delivery of high-impact FinTech features

Education

• Biju Patnaik University of Technology, Odisha

  Bachelor of Technology (B.Tech.), Computer Software Engineering

Skills

• Requirements Analysis
• Agile Methodologies
• Workforce Management
• Cascading Style Sheets (Css)
• C# 3.0
• Ado.net
• Integration
• Mvc
• Sdlc
• Iis
• Angularjs
• Microsoft Sql Server
• Linq
• Ektron
• Ext Js
• Jquery
• Pacs
• Testing
• Windows Phone
• C#
• .net
• Ssis
• Sql
• Asp.net
• Mysql
• Asp.net Mvc
• Javascript
• Html 5
• Ssrs
• Databases
• Msql
• Wcf