Hi, I’m Sohan Pujar.

Data & Analytics Manager with experience across higher education, banking, and enterprise platforms. I build reliable analytics products end-to-end — from modelling and ingestion to governed reporting, automation, and delivery.

About

I work at the intersection of data engineering and analytics delivery, turning business questions into dependable datasets, models, and dashboards. I’m most effective when the work spans multiple teams — aligning requirements, enforcing quality and governance, and shipping outcomes that stakeholders can trust.

Skills

Core

  • Analytics engineering (modelling + transformation)
  • Data platforms & pipeline delivery
  • Reporting automation & governed access
  • Stakeholder engagement & delivery leadership

Tools & Platforms

Data
Snowflake dbt Core dbt Fusion SQL Server Oracle MongoDB
Cloud
AWS Azure GCP SAP BTP
BI
Power BI Tableau SAP Analytics Cloud MicroStrategy
Dev
GitHub Bitbucket CI/CD

Practices

  • Automated testing (dbt Core/Fusion), governance, and metadata tagging
  • Secure reporting (RLS), refresh automation, and lineage
  • Code review standards and production readiness
  • Enablement: workshops, mentoring, and coaching

Experience

  1. Data & Analytics Manager

    RMIT University · Full-time
    Jun 2024 — Present
    Melbourne, Australia
    • Built scalable Snowflake models and transformation layers using dbt Core and dbt Fusion to standardise student lifecycle and application data, including JSON sources.
    • Delivered secure, automated ingestion into Snowflake via AWS AppFlow, integrating Salesforce, Studylink and internal systems.
    • Owned Power BI reporting with row-level security, drill-down experiences and refresh automation, plus lineage and health monitoring for conversion and campaign performance.
    • Introduced automated tests, metadata tagging and governance controls to reduce manual checks and improve audit readiness.
    • Implemented CI/CD in Bitbucket to streamline releases and enforce quality and governance gates.
    • Led code reviews and coached team members to lift capability and accelerate onboarding into the analytics engineering stack.
    • Led development of student interaction, application, and prospective student lead datasets into Adobe martech platforms to enable targeted personalisation and marketing.
    • Contributed to RMIT being named a 2026 Adobe Experience Maker Awards finalist (Experience Maker of the Year category) by delivering the RT-CDP/CJA data foundations and governance needed for targeted, measurable journeys.
  2. Data Platforms Senior Associate

    Macquarie Group · Full-time
    Feb 2023 — May 2024
    Melbourne, Australia
    • Built Alteryx pipelines and SQL transformations to deliver financial data extracts for treasury, liquidity and regulatory reporting (IFRS 9 aligned).
    • Partnered with stakeholders to design and monitor Informatica data-quality rules so only validated data reached reporting systems.
    • Improved ETL performance and Oracle data structures using indexing, partitioning and storage techniques.
    • Maintained Informatica MDM workflows to reconcile master data, reduce duplication and improve integrity across platforms.
    • Delivered repeatable MicroStrategy reporting for non-technical business users.
  3. Analytics & Insights Consultant

    SAP Australia · Full-time
    Jan 2021 — Feb 2023
    Australia
    • Implemented SAP Analytics Cloud Planning and SAP Data Intelligence for enterprise clients, including data modelling, pipeline configuration and enterprise authentication.
    • Led SAP Build and SAP Datasphere workshops, enabling 1,000+ partner employees on data modelling, pipelines, and low-code development.
    • Created implementation and BAU documentation (data flows, runbooks, troubleshooting) to support client teams.
    • Published thought-leadership articles on data analytics for SAP.

Selected Projects

SAP Innovator Challenge (Winner)

Collaborated with teams across Japan, Korea and India to design and develop a health application tracking historic records in a global SAP hackathon. Received Crowd Favourite recognition from SAP’s Chief People & Operating Officer.

Product Analytics Team delivery

Loan Default Prediction

Designed an end-to-end GCP workflow to predict loan default rates, using Cloud Functions for preprocessing, Cloud Storage for staging, and Vertex AI for batch prediction and deployment.

GCP Vertex AI AutoML

Bushfire Predictive Analytics

Leveraged publicly available sensor data to predict high-risk bushfire regions. Designed an end-to-end data architecture using Kafka and Spark, visualised results in Matplotlib, and stored data in MongoDB.

Kafka Spark MongoDB

Tesla Stock Price Prediction

Produced a stock analysis and prediction using OLS regression and statistical testing for autocorrelation and heteroskedasticity.

Statistics Python/R Time series

Education

Bachelor of Computer Science & Commerce

Monash University · Feb 2019 — Dec 2022
  • Majors: Finance & Data Science
  • WAM: 79.922 · GPA: 3.5 / 4.0 (Distinction average)
  • 2× Community Leaders Scholarship recipient

Certifications

  • Microsoft Azure Data Fundamentals
  • Snowflake SnowPro Associate Platform
  • Alteryx Design Core
  • Practera Dealbook for Consulting
  • CFA Level 2 Candidate

Contact

Availability
Open to opportunities
Phone