The Data Architect will design and implement advanced SQL Server architectures to ensure data integrity and business intelligence. They will also manage ETL processes, optimize T-SQL scripts, and enforce security protocols across the enterprise data landscape.
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.
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”