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
