Skip to content
View shashankthimmegowda's full-sized avatar

Highlights

  • Pro

Block or report shashankthimmegowda

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

Header

LinkedIn Email GitHub Phone

📍 Shrewsbury, MA | 🎓 MS in Data Science | 💼 5+ Years Enterprise Data Engineering


🎯 EXECUTIVE SUMMARY

Data Engineering Leader specializing in cloud-native data architectures that drive measurable business outcomes. Proven track record of designing and deploying enterprise-scale ELT/ETL pipelines that process 100M+ records, reduce operational costs by 40%, and accelerate time-to-insight for executive decision-making.

📊 Leadership Impact Dashboard

🏢 TEAMS LED

Cross-functional
Data Teams

Collaborated with 15+ engineers, analysts, and stakeholders
💰 COST OPTIMIZATION

40%

Warehouse cost reduction through performance tuning
📈 DATA SCALE

100M+

Customer records consolidated and unified
🚀 PRODUCTS SHIPPED

12+

Production data platforms and analytics solutions
⚡ PERFORMANCE GAINS

60%

Query performance improvement via optimization
🔄 PIPELINE UPTIME

99.8%

Reliability through automated orchestration
📚 CAREER TRAJECTORY

3 Promotions

Associate → Engineer → Senior Engineer
🎓 EDUCATION

MS + BS

Data Science & Engineering foundations

💡 LEADERSHIP PHILOSOPHY

"Data engineering excellence is not just about building pipelines—it's about architecting strategic solutions that empower organizations to make data-driven decisions at scale. I lead by designing resilient, cost-effective systems while mentoring teams to embrace modern data practices and continuous innovation."

My approach centers on three pillars:

  • 🎯 Strategic Alignment: Translating business requirements into scalable technical architectures
  • ⚙️ Operational Excellence: Implementing governance, testing, and monitoring frameworks that ensure reliability
  • 👥 Team Empowerment: Knowledge-sharing through documentation, code reviews, and hands-on mentorship

🏗️ STRATEGIC IMPACT ARCHITECTURE

graph TB
    A[Business Vision<br/>Revenue Analytics & Customer 360] --> B[Strategic Planning<br/>Multi-Region Architecture Design]
    B --> C[Technical Leadership<br/>ELT Pipeline Development]
    C --> D[Team Enablement<br/>DBT Best Practices & CI/CD]
    D --> E[Operational Excellence<br/>Cost Governance & Performance]
    E --> F[Business Impact<br/>Actionable Insights & ROI]
    
    style A fill:#1e3a8a,stroke:#f8fafc,stroke-width:2px,color:#f8fafc
    style B fill:#1e40af,stroke:#f8fafc,stroke-width:2px,color:#f8fafc
    style C fill:#2563eb,stroke:#f8fafc,stroke-width:2px,color:#f8fafc
    style D fill:#3b82f6,stroke:#f8fafc,stroke-width:2px,color:#f8fafc
    style E fill:#60a5fa,stroke:#f8fafc,stroke-width:2px,color:#f8fafc
    style F fill:#4ade80,stroke:#f8fafc,stroke-width:2px,color:#f8fafc
Loading

📈 CAREER PROGRESSION TIMELINE

timeline
    title Leadership Journey in Data Engineering
    section Foundation
        2019 : Associate Data Engineer
             : Dess Technologies
             : Built Customer 360 Platform
    section Growth
        2021 : Snowflake Data Engineer
             : Tata Consultancy Services
             : Led ELT Modernization
    section Leadership
        2023 : MS Data Science
             : UMass Dartmouth
        2025 : Data Engineer
             : Emburse
             : Revenue Analytics Lead
Loading

🎖️ KEY ACHIEVEMENTS & BUSINESS METRICS

💼 Emburse | Data Engineer | Sept 2025 – Present

🏆 Led end-to-end revenue analytics platform transformation serving multi-region enterprise customers

Strategic Initiatives:

  • 🎯 Multi-Region Data Consolidation: Architected cross-region data aggregation strategy consolidating 3 Snowflake regions, enabling precise usage metering and billing reconciliation for SaaS revenue operations
  • 💰 Revenue Operations Enablement: Developed Python-based customer usage reporting system that automated billing reconciliation, reducing manual finance operations by 30 hours/month
  • 🚀 Semantic Layer Implementation: Pioneered dbt Semantic Layer adoption defining reusable KPIs via Metrics package, accelerating analytics development velocity by 50%
  • Real-Time Metering: Implemented Snowflake Dynamic Tables for frequent meter updates, achieving near-real-time usage tracking for customer-facing dashboards

Technical Leadership:

  • Designed Medallion architecture (Bronze/Silver/Gold) using dbt with incremental models and SCD Type 2 snapshots
  • Orchestrated complex ELT workflows via Airflow (MWAA) integrating Fivetran ingestion from Billing Platform APIs
  • Built lightweight Master Data Management tool using Streamlit for business user self-service data governance

Technologies: Fivetran, dbt, Snowflake, Airflow (MWAA), Python, Streamlit, Semantic Layer


💼 Tata Consultancy Services | Snowflake Data Engineer | Nov 2021 – Aug 2023

🏆 Spearheaded enterprise data warehouse modernization delivering 40% cost savings

Strategic Initiatives:

  • 💰 Cost Governance Leadership: Led Snowflake cost optimization initiative using Query Profiler analysis and dynamic warehouse management, achieving 40% reduction in compute spend (~$180K annual savings)
  • 🎯 Single Source of Truth: Architected centralized financial and asset data platform consolidating 20+ disparate sources into governed Snowflake warehouse, eliminating data silos
  • Performance Engineering: Optimized query performance by 60% through strategic clustering key implementation and warehouse right-sizing
  • 🔄 CI/CD Modernization: Implemented Git-based CI/CD pipelines for dbt deployments, reducing release cycles from weeks to days

Technical Leadership:

  • Designed event-driven ingestion patterns using Snowpipe with S3 and Azure Blob Storage auto-ingest
  • Built incremental ELT framework using Snowflake Streams & Tasks for real-time data processing
  • Developed reusable dbt macro library with Jinja templating, accelerating team development velocity by 40%
  • Integrated dbt testing framework with 95%+ test coverage ensuring data quality

Technologies: Fivetran, dbt, Snowflake, Snowpipe, S3, Azure Blob Storage, SQL, Jinja, Git


💼 Dess Technologies Pvt Ltd | Associate Data Engineer | June 2019 – Nov 2021

🏆 Designed Customer 360 platform processing 100M+ records and 5TB data

Strategic Initiatives:

  • 🎯 Customer 360 Vision: Led design and implementation of unified customer data platform consolidating 10+ source systems, enabling enterprise-wide customer analytics
  • 📊 Marketing Analytics Enablement: Integrated social media APIs into Snowflake supporting Marketing Mix Modeling, driving $2M+ in attributed campaign ROI
  • Scalability Engineering: Built incremental dbt models processing 5TB of customer data with 99.9% pipeline reliability
  • 🔄 Orchestration Framework: Designed Apache Airflow DAGs automating ETL workflows, reducing manual data operations by 80%

Technical Leadership:

  • Optimized Snowflake query performance using clustering keys and dynamic warehouse scaling
  • Developed aggregated data models supporting executive spend analysis dashboards
  • Implemented Python Snowflake connectors for automated data quality monitoring

Technologies: Snowflake, dbt, Fivetran, Apache Airflow, Python


🧠 TECHNICAL EXPERTISE LANDSCAPE

mindmap
  root((Shashank<br/>Thimmegowda))
    Data Engineering
      ETL/ELT Design
      Pipeline Orchestration
      Data Modeling
      Performance Tuning
    Cloud Platforms
      Snowflake Architecture
      AWS S3 & Services
      Azure Blob Storage
      Multi Region Strategy
    Development
      Python
      SQL
      dbt
      Jinja Macros
    Governance
      Data Quality Testing
      Cost Optimization
      SCD Tracking
      Master Data Management
    Orchestration
      Apache Airflow
      Fivetran
      Snowpipe
      Dynamic Tables
    Analytics
      Semantic Layer
      Streamlit Apps
      KPI Development
      Business Intelligence
Loading

🛠️ ENTERPRISE TECHNOLOGY STACK

Cloud Data Platforms

Snowflake AWS Azure

Data Engineering & Transformation

dbt Apache Airflow Fivetran Python SQL

Development & Orchestration

Git GitHub Actions Jira Docker

Analytics & Visualization

Streamlit Jupyter Tableau

Data Storage & Integration

S3 Azure Blob Snowpipe Postman


🚀 FEATURED STRATEGIC PROJECTS

🎯 dbt MCP + Snowflake Cortex Chat Analytics

View Project

Business Value: AI-powered conversational analytics interface enabling executives to query dbt Semantic Layer using natural language

Strategic Impact:

  • Democratized data access for non-technical stakeholders through chat interface
  • Reduced time-to-insight from hours to seconds via LLM-orchestrated queries
  • Integrated Snowflake Cortex COMPLETE functions with dbt's Model Context Protocol (MCP)

Architecture Highlights:

  • Streamlit in Snowflake (SiS) application leveraging Cortex LLM capabilities
  • MCP server integration for semantic layer metadata (metrics, dimensions, entities)
  • Multi-tool orchestration enabling complex analytical workflows via natural language

Technologies: Streamlit, Snowflake Cortex, dbt Semantic Layer, Python, MCP Protocol


📊 End-to-End Pipeline: Snowflake + dbt + Tableau

View Project

Business Value: Production-grade sales analytics pipeline delivering real-time profit insights across locations, customers, and products

Strategic Impact:

  • Enabled executive dashboards with live Snowflake-Tableau connection for real-time KPI tracking
  • Implemented star schema design optimizing query performance for OLAP workloads
  • Automated CI/CD via GitHub Actions ensuring continuous data quality

Architecture Highlights:

Popular repositories Loading

  1. jaffle-shop jaffle-shop Public template

    Forked from dbt-labs/jaffle-shop

    Open source dbt sandbox exploring data modeling workflows via a fictional sandwich shop's data — covers models, tests, documentation, and seeds. Great reference for dbt fundamentals and best practi…

  2. Data_Profiler_App Data_Profiler_App Public

    Native Streamlit app for interactive data profiling and exploration within Snowflake — schema inspection, column statistics, null analysis, and data quality checks. Stack: Python · Streamlit · Snow…

    Python

  3. shashankthimmegowda shashankthimmegowda Public

    Profile README

  4. contribution-history contribution-history Public

    Auto-generated GitHub contribution history — tracks and visualizes commit activity across repositories. Stack: GitHub API · Python

  5. elt-pipeline-dbt-snowflake-airflow elt-pipeline-dbt-snowflake-airflow Public

    End-to-end ELT pipeline with Apache Airflow for orchestration, dbt (Medallion architecture) for SQL transformations, and Snowflake as the cloud data warehouse. Features incremental models, SCD Type…

    HTML

  6. realtime-warehousing-with-snowflake realtime-warehousing-with-snowflake Public

    Real-time data warehousing using Snowflake Streams & Tasks for incremental change propagation, Snowpipe for automated ingestion from S3/Azure Blob, and dynamic warehouse management for cost governa…