Data Architect – SQL Server, Power BI & NetSuite

About this role

Summary

We are seeking a highly experienced Data Architect to lead the design and evolution of our enterprise data landscape. In this pivotal role, you will be responsible for architecting robust solutions that leverage SQL Server, Power BI, and NetSuite to drive data integrity and business intelligence. This position is critical for ensuring that complex data flows are optimized, secure, and capable of supporting advanced analytical requirements across the organization.

Responsibilities

• Design and implement advanced SQL Server 2025 architectures utilizing temporal tables for historical data tracking and Resource Governor for workload management.

• Develop and enforce Row-Level Security (RLS) protocols to ensure data privacy and access control compliance.

• Architect ETL processes using SSIS to facilitate seamless data integration and transformation.

• Write and optimize complex T-SQL scripts to enhance query performance and system efficiency.

• Establish comprehensive data quality frameworks to maintain accuracy and consistency across all datasets.

• Implement sophisticated deduplication strategies to eliminate redundant records and improve data reliability.

• Collaborate with stakeholders to translate business requirements into scalable technical data solutions.

Requirements

Requirements:

• Minimum of 12 years of professional experience in data architecture and database management.

• Proven expertise with SQL Server 2025, including deep knowledge of Temporal Tables and Resource Governor features.

• Strong proficiency in implementing Row-Level Security (RLS) and managing data quality initiatives.

• Hands-on experience with SSIS for data integration and T-SQL for advanced database programming.

• Demonstrated ability to handle data deduplication and ensure high standards of data integrity.

• Familiarity with Power BI and NetSuite ecosystems for enterprise reporting and resource planning.

• Ability to work within the IT Services sector and deliver solutions aligned with industry standards.

Originally posted on Himalayas