Service · Snowflake consulting

Snowflake consulting and migration from an independent engineering team.

Most Snowflake problems are design problems: one schema doing the job of four layers, warehouses sized by guesswork and Power BI figures that no longer match the source. MV.tech is not a Snowflake reseller or partner programme member; it works as an independent engineering team that migrates legacy reporting and SQL Server, Oracle and spreadsheet estates into Snowflake with raw, staging, curated and reporting layers, fact and dimension models for Power BI, and reconciliation at every stage. In a previous engagement at Volvo Cars via Toptal, MV.tech's founder migrated legacy and manual reporting into a Snowflake warehouse with those four layers, built fact and dimension models for Power BI with source-to-target mappings, and delivered a lead-to-sale matchback comparison between Volvo's attribution and an external vendor across about 427K lead-month records.

  • Remote from Ahmedabad, India
  • Overlap with your timezone
  • Senior specialists, direct access
  • Scope agreed in writing

The starting point

When does a Snowflake consultant make sense?

  • Reporting still runs on SQL Server, Oracle or a folder of spreadsheets, Snowflake has been chosen as the target, and nobody has mapped what depends on the old estate.
  • Snowflake is already in place, but everything landed in one schema with no raw, staging, curated or reporting separation to build on.
  • Power BI reads Snowflake through hand-written queries rather than fact and dimension tables, so every report calculates its own version of revenue.
  • Monthly credit consumption keeps rising and nobody can say which warehouses, queries or refreshes are responsible.
  • Figures in Snowflake, Salesforce CRM Analytics and the finance system disagree, and reconciling them is a manual job each month.
  • Ingestion through Azure Data Factory or Python jobs works most days, with no validation that would catch the days it does not.
  • A previous migration attempt stalled because the new numbers did not match the old ones and no one could explain why.

What we deliver

What does Snowflake consulting from MV.tech include?

01

Migration from SQL Server, Oracle and spreadsheets

Catalogue the source estate from the information schema, DDL, query logs and job schedules, then write a source-to-target mapping per object: target table and layer, data types, transformation rules, keys, grain and historical scope. Spreadsheet reporting is handled the same way, with the rules that live in formulas written down before they are modelled. Each load is reconciled against the legacy figures so cutover happens on evidence rather than on a date.

02

Raw, staging, curated and reporting layers

Design Snowflake as four separated layers: raw as it arrived, staging typed and conformed, curated facts and dimensions, and reporting views shaped for the tools that read them. Each layer has an owner, a refresh dependency and a check that proves it loaded, which is what keeps the warehouse maintainable after the project ends.

03

Fact and dimension models for Power BI

Build fact and dimension tables at an agreed grain, with conformed dimensions, bridge tables for many-to-many relationships and source-load tracking, then the curated views Power BI imports or queries directly. Existing Power BI and DAX models are profiled first, so a rebuild is a justified decision rather than a default.

04

Views and curated datasets

Publish curated datasets analysts can query without writing joins: consistent naming, a description on every column, technical fields hidden and governed measures kept apart from someone's own analysis. Secure views and role-based grants control who sees what without copying the data.

05

Validation and reconciliation across sources

Automated comparison at each stage: record counts, date coverage, nulls, duplicates, control totals and metric-level comparison of the figures people report, across the source systems, Snowflake and the BI layer. Differences are explained rather than rounded away, and each one ends as a fix or a documented, deliberate change.

06

Cost and performance tuning

Reduce what each query reads and what each warehouse costs: clustering keys chosen against real query patterns, warehouse sizes and auto-suspend settings taken from the query history rather than guesswork, incremental loads in place of full refreshes, and materialised results where a report reads the same aggregate every hour. The before-and-after is measured on your own queries and credit consumption.

07

Salesforce CRM Analytics and Azure Data Factory ingestion

Where reporting already lives in Salesforce CRM Analytics, handle the datasets, recipes, dataflows and field mapping so Snowflake and CRM Analytics agree on the same figures. Where sources sit in Azure, build Azure Data Factory pipelines through Blob Storage into Snowflake with incremental loads, retries and logging, and Python and SQL ingestion elsewhere.

08

Handover and operating documentation

Mappings, ER diagrams, validation results, refresh schedules, the role and grant model, cost monitoring and runbooks, written for the people who will run Snowflake after the engagement. Handover is part of the scope, not an extra.

  • Snowflake
  • SQL Server
  • Oracle
  • Azure SQL
  • Azure Data Factory
  • Matillion
  • Salesforce CRM Analytics
  • Power BI
  • DAX
  • Python
  • SQL
  • Parquet
  • Excel
  • Dimensional modelling
  • Semantic models

A useful first project

What is a sensible first Snowflake project?

One reporting domain, taken the whole way. Pick finance, sales or operations and cover discovery of its sources, source-to-target mapping, the four Snowflake layers, a fact and dimension model, reconciliation against the figures people trust today and one Power BI report repointed at the result. It is small enough to correct cheaply and complete enough to prove the layer design, the validation approach and the cost profile on your data. The remaining domains are then estimated from what the first one showed rather than from a template, and we quote after a scoping call.

See our delivery process

Working together

A practical path from scope to delivery.

  1. 01

    Discover and map

    Profile the source estate, its dependencies and any existing Snowflake usage, agree the layer design and write the source-to-target mapping and migration sequence.

  2. 02

    Build and reconcile

    Load and model one domain at a time, comparing each layer with the source on counts, coverage, totals and reported metrics before the next domain begins.

  3. 03

    Tune, cut over and hand over

    Set clustering, warehouse sizing and refresh schedules from real query history, repoint Power BI on evidence, and hand over mappings, grants and runbooks.

Teams our engineers have worked with

  • Google
  • Volvo
  • BCW
  • RootstockLabs
  • Chainlabs
  • Toptal
  • Turing

Before we begin

Questions about Snowflake consulting.

Not answered here? Ask us directly or read the full FAQ.

Is MV.tech a Snowflake consulting partner?

No. MV.tech is not a Snowflake reseller or a member of the Snowflake partner programme; it works as an independent engineering team that designs, migrates and tunes Snowflake warehouses on your own Snowflake account. You buy Snowflake from Snowflake and engineering from us, so there is no resale margin in the advice. The founder holds the Google Cloud Professional Data Engineer certification; MV.tech makes no Snowflake certification or partner claims.

How much does Snowflake consulting cost?

For Snowflake work, we quote after a scoping call. The estimate depends on the number of source systems, the volume of historical data, how much logic is hidden in views, stored procedures and spreadsheets, the Power BI models to be repointed and the support expected afterwards. A first domain is scoped as a bounded piece of work so the figure for the rest of the estate rests on your data rather than on a template.

How do you migrate SQL Server or Oracle to Snowflake without breaking reports?

Dependency analysis first, reconciliation throughout. Before anything moves we trace which reports, extracts and semantic models read each object and flag the platform-specific SQL, cross-database joins and hardcoded rules that will not survive the move. Layers are then built and compared with the legacy numbers stage by stage, and dashboards are repointed visual by visual, usually while both platforms run in parallel.

Should Power BI connect to Snowflake with Import or DirectQuery?

Import for most governed reporting, DirectQuery where data must be current to the minute or is too large to hold in memory, and a composite model when one report needs both. The more important decision is upstream: Power BI should read fact and dimension tables and curated views from the reporting layer, not raw tables, so the model stays small and the business logic lives in one place. We profile the existing model before recommending a change.

Why is our Snowflake bill rising, and can you reduce it?

Usually because warehouses stay awake for queries that scan more than they should. The common causes are missing clustering on large tables, full refreshes where incremental loads would do, oversized warehouses with long auto-suspend settings and reports that repeat the same aggregate many times an hour. We measure from the query history, change the few things that account for most of the spend and show the before-and-after on your own credit consumption.

Can a remote team in India run our Snowflake migration?

Yes. MV.tech works from Ahmedabad, India, and agrees a collaboration window in your timezone before work begins: US Eastern mornings, UK and European business hours, Gulf hours or Asia-Pacific afternoons. Snowflake work suits remote delivery because access is role-based and every change can be reviewed as SQL in a pull request. Reconciliation results, decisions and handover notes are written down where your team can read them the next morning.

Can you reconcile Snowflake with Salesforce CRM Analytics and our finance system?

Yes, and it is often the part that earns trust in the warehouse. We compare the same metric across the source systems, Snowflake and the CRM Analytics or BI layer at an agreed grain, then investigate every difference until it is fixed or documented as a deliberate change. That investigation sometimes shows that the legacy figure was the wrong one.

Your next step

Tell us what needs to work better.

Bring your goal, current tools and preferred working hours. We use the first 30-minute conversation to clarify fit and an initial scope, and you leave with a written next step.

Book a 30-minute call Email your brief contact@mvtech.solutions

Remote from Ahmedabad, India · Overlap with any timezone · No obligation