Offshore Resource Requirement

Estia Health Data Platform Program

Contents

Resource Requirement Summary 3

1. Senior Data Engineer Offshore / Vendor 4

Role Purpose 4

Minimum Experience Required 4

Core Responsibilities 5

Core Technical Skills Required 5

Nice to Have Skills 7

Expected Deliverables 7

Must Not Be 7

2. Senior BI Analyst / Senior BI Developer Offshore / Vendor 9

Role Purpose 9

Minimum Experience Required 10

Core Responsibilities 10

Core Technical Skills Required 11

Migration / Metric Rationalisation 12

Mandatory Delivery Expectations 12

Nice to Have Skills 13

Expected Deliverables 13

Must Not Be 13

Resource Requirement Summary

We require 3 offshore/vendor delivery resources to support a modern data platform migration and build program.

Role

Count

Primary Focus

Senior Data Engineer

2

Snowflake, dbt, ADF, SQL, stored procedure migration, Kimball modelling

Senior BI Analyst / Senior BI Developer

1

Power BI semantic model, report migration, SQL, dimensional modelling, metric migration

The resources must have prior experience in data platform migration projects, specifically moving from legacy SQL Server / stored procedure-heavy warehouse logic into a modern cloud data platform.

Senior Data Engineer Offshore / Vendor

Number of Resources -2

Seniority - Senior

Primary Technology Stack

- Snowflake
- dbt Cloud or dbt Core
- Azure Data Factory
- SQL Server / T-SQL
- Azure DevOps / Git
- Kimball dimensional modelling

Role Purpose

The Senior Data Engineer will support the migration of complex legacy SQL Server stored procedure logic into modular, governed and reusable data platform layers across Bronze, Silver and Gold.

This is a hands-on build and delivery role, not a design-only consulting role. Solution design, architecture decisions and modelling standards will be owned by the internal technical lead. The resource is expected to implement, test, validate, document and deliver agreed designs using Snowflake, dbt and Azure Data Factory.

The role requires genuine data engineering experience, not report support, dashboard development or light SQL analysis.

Minimum Experience Required

- Minimum 4+ years hands-on data engineering experience.
- Minimum 1+ years Snowflake or modern cloud data warehouse experience.
- Minimum 1+ years dbt Cloud or dbt Core experience.
- Minimum 1+ years Azure Data Factory experience.
- Must have delivered at least one data platform migration or modernisation project.
- Must have migrated or refactored SQL Server stored procedures, or similar legacy stored procedure logic, into modern data platform patterns such as Snowflake, Databricks, Microsoft Fabric or AWS/Azure-native data platforms.
- Must have hands-on experience building facts, dimensions, SCDs, incremental models and batch pipelines.
- Must be comfortable working from incomplete or complex legacy logic and converting it into clean, governed data models.

Core Responsibilities

- Analyse complex SQL Server stored procedures and identify embedded business rules.
- Convert procedural SQL logic into reusable Snowflake and dbt models.
- Build Bronze, Silver and Gold transformation layers.
- Build Kimball-style facts, dimensions and star schemas.
- Implement SCD Type 1 and Type 2 patterns.
- Build incremental, batch and CDC-style processing patterns.
- Build Azure Data Factory ingestion and orchestration pipelines.
- Build dbt models, macros, tests, snapshots, documentation and YAML configuration.
- Support source-to-target mapping, reconciliation and data validation.
- Implement data quality checks and validation rules.
- Support deployment automation, Git and CI/CD processes.
- Maintain mandatory technical documentation covering lineage, transformation rules, reconciliation outcomes, deployment steps and handover notes.
- Work with the internal technical lead to follow engineering standards, naming standards and modelling patterns.

Core Technical Skills Required

The candidate must have robust hands-on delivery experience across SQL, Snowflake, dbt, Azure Data Factory and dimensional modelling.

SQL / Data Engineering

- Strong SQL engineering experience, including complex joins, CTEs, window functions, stored procedure analysis, performance tuning and reconciliation.
- Experience migrating or refactoring legacy SQL Server stored procedures into modern cloud data platform patterns.
- Experience building ETL/ELT pipelines, batch loads, incremental loads and CDC-style processing.
- Ability to read complex legacy logic, extract embedded business rules and rebuild them into clean governed data models.

dbt

- Hands-on experience with dbt Cloud or dbt Core.
- Ability to build dbt models across staging/source-clean, intermediate, canonical and mart layers.

Practical experience with ref(), source(), incremental models, snapshots, materialisations and model dependencies.

- Experience writing and maintaining dbt YAML files, including model documentation, column documentation, source definitions, tests and freshness checks.
- Experience with dbt tests such as not_null, unique, accepted_values, relationships and custom generic tests.
- Experience creating and using dbt macros to reduce duplicated SQL logic.
- Ability to follow a structured dbt project layout using models, macros, tests, snapshots, seeds and documentation.

Azure Data Factory

- Experience building ADF ingestion and orchestration pipelines.
- Experience with parameterised pipelines, datasets, linked services, variables, dependencies and environment-specific configuration.
- Experience implementing error handling, retry logic, audit logging, incremental loads and batch orchestration.
- Experience integrating ADF with Azure DevOps / Git and supporting CI/CD promotion across environments.

Snowflake

- Strong Snowflake SQL development experience.
- Experience creating and managing databases, schemas, tables, views and transformation layers.
- Understanding of Snowflake warehouses, compute/storage separation, roles,



access control, stages, file formats and COPY INTO.
- Experience with incremental loading patterns, query performance tuning, warehouse sizing, auto-suspend / auto-resume and cost-aware development.

Data Warehouse / Modelling

- Strong Kimball dimensional modelling experience.
- Experience designing and building facts, dimensions, star schemas, conformed dimensions and surrogate keys.
- Experience with Type 1 and Type 2 slowly changing dimensions.
- Experience with transaction facts, snapshot facts, accumulating snapshot facts and bridge tables where required.
- Strong understanding of fact table grain, source-to-target mapping, lineage, reconciliation and control totals.

Nice to Have Skills

- Power BI awareness.
- HR, workforce or rostering data experience.
- dbt package experience.
- dbt Labs certification or formal dbt training.
- Data observability experience.
- Data quality framework experience.
- Metadata-driven ingestion framework experience.
- Audit logging and operational monitoring experience.

Expected Deliverables

- ADF ingestion pipelines and reusable pipeline templates.
- Snowflake raw, clean and curated transformation tables.
- dbt model files, macros, tests, snapshots and YAML documentation.
- Bronze-to-Silver and Silver-to-Gold mapping logic.
- Kimball facts and dimensions.
- SCD Type 1 and Type 2 logic.
- Incremental and batch load logic.
- Reconciliation reports and data quality checks.
- Mandatory documentation pack covering source-to-target mappings, dbt model documentation, YAML definitions, macro documentation, pipeline documentation, reconciliation evidence, deployment steps and handover notes.

Must Not Be

The candidate must not be primarily:

- a Power BI-only developer,
- a dashboard developer,
- a report support analyst,
- a production support-only resource,
- a manual tester,
- a business analyst with light SQL,

a SQL analyst who has not built pipelines or data models,

- someone who has only consumed facts/dimensions but not built them
- someone whose recent experience is mostly non-engineering BI work
- a design-only consultant who produces recommendations but does not build, test, validate, document and deliver working pipelines, models or data platform assets.

Senior BI Analyst / Senior BI Developer Offshore / Vendor

Number of Resources - 1

Seniority - Senior

Primary Technology Stack

- Power BI
- Power BI semantic model
- DAX
- SQL
- Snowflake / dbt
- Snowflake Presentation layer
- Dimensional modelling
- Report migration
- Metric migration

Role Purpose

The Senior BI Analyst / Senior BI Developer will support reporting migration, semantic layer delivery and Snowflake/dbt Presentation layer build for the new platform.

The role will focus on Power BI semantic modelling, report migration, metric rationalisation, DAX review, SQL validation and alignment of reporting logic to the new Snowflake Gold and Presentation layers.

This is a hands-on build and delivery role, not a visual-only Power BI role or design-only consulting role. BI architecture, metric ownership decisions and platform design will be owned by the internal technical lead. The resource is expected to build, test, validate, document and deliver agreed designs.

A key expectation is to help move heavy reusable calculations, duplicated measures and report-specific business logic out of Power BI and into Snowflake/dbt Presentation layer models where appropriate. Power BI should consume curated, semantic-ready Snowflake outputs rather than perform complex transformations in the report layer.

The candidate must understand semantic models, facts and dimensions, DAX, SQL validation and the difference between metrics that belong in:

- Power BI visuals,
- Power BI semantic model,
- Snowflake Gold layer,
- Snowflake Presentation layer,

dbt models.

This role sits between the Snowflake/dbt Presentation layer and Power BI. The resource must be able to build and validate reporting-ready SQL/dbt outputs, not only create Power BI visuals.

Minimum Experience Required

- Minimum 3+ years BI / analytics delivery experience.
- Minimum 2+ years Power BI experience.
- Minimum 2+ years semantic model experience.
- Minimum 3+ years SQL experience.
- Must have worked on at least one reporting migration or data platform migration project.
- Must have experience working with fact and dimension models.
- Must have experience validating report outputs against SQL / warehouse outputs.
- Must have experience rationalising measures, duplicated metrics and report logic.
- Must be able to build or contribute to reporting-ready Snowflake views/tables or dbt presentation models.

Core Responsibilities

- Build and maintain Power BI semantic models.
- Build and migrate Power BI reports and dashboards.
- Build or contribute to Snowflake Presentation layer tables/views required for Power BI reporting.
- Build or update dbt presentation models where reporting logic needs to be moved out of Power BI and into the data platform.
- Move reusable metrics, heavy calculations and duplicated report logic from Power BI into Snowflake Gold / Presentation / dbt layers where appropriate.
- Review existing report-level logic, DAX measures and business metrics.
- Identify which metrics should remain in Power BI and which should move into Snowflake Gold / Presentation / dbt layers.
- Work with data engineers to ensure Gold and Presentation layer models support reporting requirements.
- Validate semantic model and report outputs against Snowflake / dbt outputs.
- Build and optimise DAX measures where required.

Support report testing,



UAT and defect resolution.

- Support row-level security and reporting security patterns.
- Work with data engineers to ensure dbt models are deployed and orchestrated correctly through the agreed ADF / dbt run process.
- Support Power BI connectivity to Snowflake Presentation outputs, including agreed Import, DirectQuery or composite model patterns where required.
- Document semantic model relationships, metric definitions, DAX logic, validation outcomes and handover notes.
- Support Power BI performance optimisation and report migration clean-up.

Core Technical Skills Required

The candidate must have strong hands-on delivery experience across Power BI, semantic modelling, DAX, SQL, Snowflake/dbt and dimensional reporting models. Power BI / Semantic Modelling

- Strong Power BI semantic model design experience.
- Strong understanding of star schemas, facts, dimensions and model relationships.
- Experience with single-direction and bi-directional relationships.
- Experience creating measure tables and reusable DAX measures.
- Experience with row-level security.
- Experience with report performance tuning.
- Experience with Power BI deployment pipelines or controlled release processes.
- Experience validating migrated reports against source, warehouse or Snowflake Presentation layer outputs.
- Understanding of when Import, DirectQuery or composite model patterns are appropriate for Power BI over Snowflake.

SQL / Snowflake / dbt Presentation Layer

- Strong SQL skills.
- Ability to query Snowflake Gold and Presentation layer tables.
- Ability to build reporting-ready Snowflake views or tables where required.
- Ability to contribute to dbt presentation models, especially where Power BI metrics are being moved into Snowflake.
- Ability to build semantic-ready Snowflake Presentation layer objects that reduce heavy calculation load in Power BI.

Awareness of dbt models, dbt runs, dbt documentation and dbt deployment flow.

- Ability to validate Power BI semantic model outputs against Snowflake/dbt outputs.
- Ability to understand fact table grain and dimensional joins.
- Ability to identify duplicated metrics across reports.
- Ability to design SQL/dbt outputs that minimise complex DAX and reduce data growth inside Power BI datasets.
- Ability to decide whether a calculation belongs in:
- Power BI visual,
- Power BI semantic model,
- Snowflake Gold layer, Snowflake Presentation layer,
- dbt model.

Migration / Metric Rationalisation

- Experience migrating reports from legacy platforms or legacy semantic models.
- Experience reviewing existing DAX and report-level calculations.
- Experience documenting metric definitions and mapping them to target-state Gold / Presentation models.
- Experience working with data engineers to move reusable business logic from Power BI into Snowflake/dbt where appropriate.
- Experience supporting UAT, reconciliation and report sign-off.

Mandatory Delivery Expectations

- Must be able to build, test, validate and document working BI and Presentation layer assets.
- Must produce documentation as part of delivery, including semantic model design, report inventory, metric catalogue, DAX measure definitions, source-to-report mapping, validation evidence, RLS/security notes and handover documentation.
- Must be comfortable working from incomplete or inconsistent existing report logic and helping rationalise it into clean target-state metrics.
- Must not wait for fully finished reports only; the resource should also support creation and validation of semantic-ready Snowflake/dbt reporting outputs.

Nice to Have Skills

- Hands-on Snowflake experience.
- Hands-on dbt experience for building presentation-layer models.
- dbt Labs training or certification.
- ADF orchestration awareness, including understanding how dbt/Snowflake jobs are scheduled and refreshed.
- Healthcare, aged care, HR, workforce or rostering reporting experience.
- Power BI deployment pipelines.
- Power BI RLS / security modelling.
- KPI catalogue or metric governance experience.
- Power BI performance tuning experience.

Expected Deliverables

- Power BI semantic model.
- Migrated Power BI reports and dashboards.
- Snowflake Presentation layer views/tables where required for reporting.
- dbt presentation models where reporting metrics or reusable logic are moved out of Power

BI.

- DAX measure review and rationalisation.
- Metric mapping documentation.
- Recommendation list of metrics to move into Snowflake Gold / Presentation / dbt.
- Report validation outputs.
- Reconciliation between Power BI outputs and Snowflake/dbt outputs.
- UAT support and defect fixes.
- RLS / security configuration where required.
- Mandatory BI documentation pack covering semantic model design, report inventory, metric catalogue, DAX measure definitions, source-to-report mapping, validation evidence, RLS/security notes and handover documentation.
- Handover notes.

Must Not Be

The candidate must not be primarily:

a visual-only dashboard developer,

- a business analyst with no semantic modelling experience,
- a report support-only resource,
- a tester who only validates reports,
- an ad hoc SQL analyst,
- someone with no dimensional modelling experience,
- someone who cannot explain whether a metric belongs in DAX, semantic model, Snowflake Presentation layer or warehouse,
- someone who can only build Power BI visuals and cannot work with SQL-based presentation tables, views or semantic-ready datasets,
- someone who expects all heavy calculations to remain in Power BI rather than helping move reusable logic to Snowflake/dbt,
- a design-only consultant who produces recommendations but does not build, test, validate, document and deliver working semantic models, presentation-layer models, reports or BI assets.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 LEAD DATA ENGINEER - Snowflake (Bengaluru)
🏢 Happiest Minds Technologies
📍 Bengaluru