Data Architect – SQL Server | Power BI | NetSuite ERP

Experience: 12–15 Years

Location: Remote

Employment Type: C2H / C2C

Shift: 11:00 AM – 8:00 PM IST

Job Overview

We are looking for an experienced Data Architect with solid expertise in Microsoft SQL Server, Power BI, NetSuite ERP, ETL/ELT, and Data Warehousing.

Key Responsibilities

- Design SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server.
- Build metadata-driven data ingestion from NetSuite using SuiteAnalytics Connect and SuiteQL.
- Develop T-SQL frameworks for data quality, matching, survivorship, and hard-delete detection.
- Design Kimball dimensional models (Star/Snowflake) for Power BI.
- Develop automated and idempotent ETL/ELT pipelines using SSIS and/or Fivetran.
- Integrate legacy ERP historical data with new cloud ERP data.
- Design and optimize Power BI semantic models, DAX, RLS, and On-Premises Gateway solutions.

Mandatory Skills





- 12–15 years of experience in Data Architecture / Data Warehousing
- Expert-level Microsoft SQL Server & T-SQL
- SQL Server Resource Governor, Temporal Tables, Columnstore Indexes
- Strong NetSuite ERP, SuiteAnalytics Connect, SuiteQL & ODBC experience
- Knowledge of NetSuite data model and connection/concurrency limits
- Strong Power BI, DAX, RLS & Gateway expertise
- SSIS / ETL / ELT and metadata-driven pipeline development
- Kimball dimensional modeling
- ERP data migration and integration experience
- Experience with data quality, matching, deduplication, and survivorship

Pay: ₹90,000.00 - ₹120,000.00 per month

Experience

- Data Architecture : 10 years (Required)

Work Location: Remote

📌 Data Architect – SQL Server | Power BI | NetSuite ERP (India)
🏢 Technology next
📍 India