Bharadwaj Rohan Anandan

I’m a data engineer who designs modern analytical data platforms that make messy, multi-source data usable. I’ve engineered Snowflake-based architectures using dimensional modeling and end-to-end ingestion to improve data availability for business teams.

In cloud environments, I build parameterized, metadata-driven pipelines with Azure Data Factory to ingest into Azure Blob Storage and keep Snowflake external tables refreshed. I also refactor legacy SQL (including T-SQL stored procedures and Oracle package logic) into modular, testable dbt models for reliable daily Fact/Dimension/Staging refreshes.

To ensure correctness and usability, I implement advanced modeling such as SCD Type 2 for asset tracking and replace legacy logic for better historical accuracy. I’ve also created an interactive Streamlit application connected to Snowflake to deliver real-time asset visibility using heartbeat data.

Earlier work included migrating mission-critical Supply Chain pipelines from Oracle/Mulesoft to Snowflake and dbt, and extracting Oracle data via AWS Glue into S3 using Snowflake storage integrations and external tables. I value maintainability, code quality, and automation—whether orchestrating dbt Cloud with serverless AWS or preventing concurrent job overlap with resilient polling and alerting.