Data Architect – SQL Server | Power BI | NetSuite ERP

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 strong 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