Data Architect – SQL Server, Power BI & NetSuite
Experience: 12+ Years
Location: Remote
Duration: 6 Months
Working Hours: 11:00 AM – 8:00 PM IST
US Overlap: Candidate must be adaptable to provide up to 4 hours of overlap with US EST hours, as required.
Engagement: Contract
Role Overview
We are looking for a highly experienced Data Architect with strong expertise in Microsoft SQL Server, Power BI, NetSuite ERP, and enterprise data warehousing.
The candidate will be responsible for architecting and implementing an SQL-first Medallion Architecture (Bronze, Silver, Gold) on an on-premises SQL Server 2025 Standard Edition environment. The role requires hands-on expertise in data architecture, ETL/ELT, NetSuite data integration, data quality, dimensional modeling, and Power BI.
The ideal candidate should be comfortable taking architectural ownership, defining technical standards, and making critical decisions around data ingestion, transformation, security, performance, and reporting.
Key Responsibilities
1. Data Architecture & Medallion Framework
* Design and enforce an on-premises SQL-first Medallion Architecture consisting of Bronze, Silver, and Gold layers.
* Architect scalable and maintainable data warehouse solutions using SQL Server 2025 Standard Edition.
* Establish architectural standards for data ingestion, transformation, quality, governance, and consumption.
* Ensure the architecture supports reliable, scalable, and high-volume analytical workloads.
2. NetSuite ERP Integration
* Architect metadata-driven ingestion frameworks for extracting data from NetSuite ERP.
* Work extensively with SuiteAnalytics Connect, SuiteQL, and NetSuite data models.
* Design mechanisms for hard-delete detection and incremental data extraction.
* Understand NetSuite ODBC connectivity, data structures, limitations, and connection/concurrency considerations.
* Integrate historical ERP data with new cloud ERP operational data.
3. SQL Server & Data Engineering
* Develop advan
📌 Data Architect (India)
🏢 Ancilar
📍 India