ANALYTICS ENGINEER· AUCKLAND, NZ· dbt · SNOWFLAKE · DATA VAULT

I build the data models a business trusts enough to make decisions on.

Analytics engineer in the Analytics Engineering team at 2degrees, working daily in dbt, Snowflake and SQL. I turn complex, fragmented source data into clean, tested, well-governed models that both reporting and AI systems can rely on, and I have spent the last two years retiring legacy reporting platforms and rebuilding what was inside them.

100+
reports migrated off SAP BusinessObjects and rebuilt as Snowflake models
NZ$150k+
annual platform cost removed by retiring a legacy reporting stack
200 → 5
Tableau licences, after reviewing what each team actually needed

I came up through BI and reporting, then got more interested in the layer underneath the dashboards: how data gets modelled, tested and governed before anyone sees a chart. That is the work I do now. Much of the last two years has gone into retiring legacy platforms, SAP BusinessObjects and Netezza, and rebuilding the business logic buried inside them as governed Snowflake models, so teams query a model instead of raising a request for a report.

A lot of what I build sits on sensitive and regulated data, so access control, lineage and auditability are part of building the model rather than something added at the end.

I also helped build the retrieval-augmented generation (RAG) pipeline for KiwiStart, an AI product for migrants and students. That gave me hands-on experience with the part of AI most analytics people never touch: the data and retrieval layer that decides whether the answers are any good.

Selected work

Projects, described without the confidential parts.

Real work at 2degrees and beyond. Where a dataset is sensitive, the detail is withheld and only the transferable skill is shown.

Analytics Eng 2024 – 2026

Retiring SAP BusinessObjects

Analytics Engineer, 2degrees

Worked with data leadership and report owners to take more than 100 reports off SAP BusinessObjects, rebuild the business logic inside them as governed Snowflake models, and move users onto Power BI or direct SQL. Saved over NZ$150,000 a year.

dbtSnowflakeSAP BusinessObjectsPower BI
Read more →
Analytics Eng 2024 – present

Regulatory reporting model on Snowflake

Analytics Engineer, 2degrees

Reassembled fragmented source records into complete, auditable activity for a high-sensitivity regulatory dataset, using window functions and layered CASE logic on incremental, micro-batched tables.

dbtSnowflakeSQL (window functions, arrays)Iceberg
Read more →
Analytics Eng 2024 – present

ServiceNow ITSM data pipeline

Analytics Engineer, 2degrees

End-to-end dbt pipeline bringing ServiceNow incidents, cases and SLA data into the warehouse for SLA and resolution reporting, with data contracts enforced across layers.

dbtSnowflakeData Vault 2.0Temporal satellites
Read more →
AI 2025

RAG knowledge layer for an AI product

Data & AI Engineer (Contributor), KiwiStart

Helped build the retrieval-augmented generation pipeline behind KiwiStart's AI chat: the knowledge base, embeddings and vector search that decide what the model retrieves before it answers.

RAGEmbeddingsVector searchPostgres / pgvector
Read more →
Analytics Eng 2024 – 2025

Cutting a 200-licence Tableau estate to 5

Analytics Engineer, 2degrees

Took over Tableau licence management for the wider business, reviewed what each team genuinely needed instead of handing out authoring licences by default, and reduced the estate from around 200 licences to 5 as reporting consolidated onto Power BI.

TableauPower BILicence governanceRequirements analysis
Read more →
Analytics Eng 2024 – present

Legacy Netezza to Snowflake migration

Analytics Engineer, 2degrees

Helped move reporting and data workloads off the decommissioned Netezza platform onto Snowflake: analysing existing solutions, rebuilding transformation logic, validating outputs, and keeping things steady for business users.

SnowflakedbtNetezzaSQL
Read more →

The skills map

Strong foundation, with a clear short list to add.

Strong now

  • dbt — models, tests, docs, contracts
  • Snowflake — RBAC, row-access policies
  • SQL — window functions, arrays, CASE logic
  • Data Vault 2.0 & dimensional modelling
  • Incremental / micro-batch, Iceberg
  • Legacy platform migration & decommissioning
  • Power BI, Tableau, SAP BusinessObjects
  • RAG, embeddings, vector search

Building

  • Semantic layer / MetricFlow
  • Model contracts & governance
  • Snowflake performance & cost tuning
  • Orchestration (Airflow / Dagster)
  • CI/CD for dbt
  • Data-quality frameworks

Toward AI engineering

  • Python for data (real depth)
  • APIs / FastAPI
  • Vector databases
  • RAG & agent patterns
  • LLM evaluation
  • GenAI-on-data (Cortex)

Where this is heading

Cement the engineer first. Then bridge to AI.

The semantic and governance layer is becoming the thing AI reads. The plan is to own it as an analytics engineer, then build AI engineering on top of the same foundation.

Now → ~24 months

Analytics Engineer, made solid

dbt + Snowflake mastery, semantic layer, governance and orchestration, backed by dbt and SnowPro certifications and a public portfolio.

~24 → 42 months

AI Engineer

Python, RAG and agents, LLM-on-data, one GenAI credential, built on top of the data foundation, not instead of it.

Get in touch

kishoremohini13@gmail.com
linkedin.com/in/kishoremohini-1109
Auckland, New Zealand · open to Australia