Core Responsibilities

Design and enforce an on-premises SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server 2025 Standard Edition.

Architect robust, metadata-driven ingestion patterns to extract data from a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL, specifically engineering solutions for hard-delete detection.

Develop custom T-SQL frameworks for data quality, matching, and survivorship in the Silver layer to offset the deprecation of Microsoft DQS and MDS.

Design Kimball-style dimensional models (Star/Snowflake schemas) optimized for downstream consumption by Power BI Service via an Enterprise On-Premises Data Gateway.

Evaluate and implement high-volume data ingestion tooling, determining the optimal balance between metadata-driven SSIS pipelines and hybrid SaaS agents (e. g. , Fivetran) within strict network security boundaries.

Technical Prerequisites

Expertise in Microsoft SQL Server internal architecture, specifically configuring Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition.

Proven experience migrating legacy ERP historical data and merging it with new cloud ERP operational data within an on-premises data warehouse.

Deep understanding of NetSuites data model, ODBC drivers, and SuiteAnalytics connection concurrency limits.

Mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and on-premises gateway capacity planning.

Robust background in establishing automated, idempotent ETL/ELT patterns that decouple extraction logic from business transformation.

Making a mid-flight leadership change is never easy, but protecting the architectural baseline now is the only way to safeguard the projects cutover. Core Responsibilities

Design and enforce an on-premises SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server 2025 Standard Edition.

Architect robust,



metadata-driven ingestion patterns to extract data from a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL, specifically engineering solutions for hard-delete detection.

Develop custom T-SQL frameworks for data quality, matching, and survivorship in the Silver layer to offset the deprecation of Microsoft DQS and MDS.

Design Kimball-style dimensional models (Star/Snowflake schemas) optimized for downstream consumption by Power BI Service via an Enterprise On-Premises Data Gateway.

Evaluate and implement high-volume data ingestion tooling, determining the optimal balance between metadata-driven SSIS pipelines and hybrid SaaS agents (e. g. , Fivetran) within strict network security boundaries.

Technical Prerequisites

Expertise in Microsoft SQL Server internal architecture, specifically configuring Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition.

Proven experience migrating legacy ERP historical data and merging it with new cloud ERP operational data within an on-premises data warehouse.

Deep understanding of NetSuites data model, ODBC drivers, and SuiteAnalytics connection concurrency limits.

Mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and on-premises gateway capacity planning.

Robust background in establishing automated, idempotent ETL/ELT patterns that decouple extraction logic from business transformation.

Making a mid-flight leadership change is never easy, but protecting the architectural baseline now is the only way to safeguard the projects cutover.

Timing : 11:00 am to 8 pm

(Candidate has to be flexible, and may require 4 hours overlap of US hours with EST)

Hybrid/ Remote

(Pune, Bangalore, Mumbai, Hyderabad, Noida)

(Hybrid - Candidate has to work 2/3 days from office in a week)

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.

📌 Data Architect (Bengaluru)
🏢 Kastech
📍 Bengaluru