Siddhesh's CV
Siddhesh Satish Rane
Senior Data Analytics Engineer | Analytics Lead
Profile summary
Accomplished Senior Data Analytics Engineer with 10 years of progressive experience in data engineering and analytics. Track record of directing analytics platform development, managing engineering teams, and building scalable dimensional data models across multiple sectors including fintech, banking, and blockchain. Dedicated to establishing robust engineering workflows, enforcing data quality practices, and delivering data warehouse infrastructure. Committed to translating complex requirements into reliable analytics solutions.
Career highlights
Data Warehouse Infrastructure: Directed analytics platform development by managing a team of 4 engineers and overseeing Snowflake and dbt data warehouse infrastructure across 20+ sources while cutting query latency by 70%.
Dimensional Data Modeling: Designed and built scalable dimensional data models using SQL and dbt across 5 end-to-end client engagements while managing scope and timelines directly with stakeholders.
Pipeline Engineering and Automation: Engineered ELT pipelines and dbt models to ingest and transform data across multiple accounts, reducing pipeline maintenance overhead by 25%.
Key skills
Professional experience
Directed analytics platform development, managing a team of 4 engineers and overseeing the Snowflake and dbt data warehouse infrastructure across sources. Managed the LookML semantic layer, standardized metric definitions for cross-functional stakeholders, and established engineering workflows including CI/CD pipelines, version control, and automated testing.
- Cut query latency by 70% by building a dimensional data warehouse using Snowflake and dbt across sources.
- Transformed Salesforce Sales Cloud CRM data into financial insights, enabling reporting on ARR, NRR, ACV, and bookings.
- Standardized dbt Cloud workflows, including version control, CI/CD pipelines, and dbt Docs for data catalog and lineage.
- Enforced data quality practices by automating validation and monitoring data integrity to resolve issues before stakeholder impact.
- Used Claude and GitHub Copilot to accelerate model development, debugging, and code reviews, reducing development cycle time.
Directed analytics engineering and data modelling initiatives for international clients, coordinating directly with business stakeholders to shape technical direction and scope.
- Designed and built scalable dimensional data models using SQL and dbt across 5 end-to-end client engagements, managing scope and timelines directly with stakeholders.
- Reduced data integration time by 30% through a unified architecture spanning Snowflake, dbt, ELT pipelines and AWS.
Managed engineering teams and collaborated directly with product stakeholders to shape data requirements, architectural standards, and operational workflows.
- Executed PostgreSQL to Snowflake migration through a phased schema-level approach, transforming datasets into analysis-ready outputs using dbt.
- Built and automated ELT pipelines using Apache Airflow, Fivetran, and dbt on Snowflake, embedding GitHub version control, testing, and documentation throughout.
- Designed and implemented enterprise Looker semantic models and dashboards, enabling scalable self-service business intelligence and standardized business metrics.
Directed engineering operations across fintech, banking, real estate, and blockchain sectors in the USA and UK, managing 4 engineers while owning end-to-end technical solution design, client communication, and version-controlled workflow implementation.
- Automated methodologies and workflows, reducing pipeline maintenance overhead by 25%.
- Designed and built Snowflake, dbt, and Fivetran data models across simultaneous multi-client accounts.
- Delivered scalable and tested data pipelines for clients including Novo, FundThatFlip, Site Impact, and Mina Protocol.
- Engineered ELT pipelines and dbt models to ingest and transform sports data from multiple global sources into Snowflake via Fivetran.
- Developed Oracle stored procedures for data migration validation using Smart-Migrate.
- Managed multiple data centre proof-of-concept initiatives.
- Implemented bulk-collect operations to optimize mass-update performance.
- Processed records to surface behavioural trends and inform product decisions.
- Built ELT pipelines and dbt models to ingest and transform sports data from multiple global sources into Snowflake via Fivetran.
- Developed Oracle stored procedures to execute data migration validation routines for Smart-Migrate.
- Implemented bulk collect operations to optimize mass update performance across large datasets.
- Built and maintained custom SQL scripts, analytical reports, and database queries.
Education
Information Technology | CERTIFICATION dbt Fundamentals 2026 dbt Labs