About the company
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Data Architect – SQL Server, Power BI & NetSuite based in India.
Responsibilities
- Design and evolve robust data architectures that support complex operational and analytical requirements while ensuring scalability, reliability, security, and performance.
- Design and implement advanced SQL Server 2025 solutions, including the use of Temporal Tables for historical data tracking and Resource Governor for effective workload management.
- Establish and enforce Row-Level Security (RLS) protocols to protect sensitive information and ensure appropriate access controls and compliance requirements are maintained.
- Architect and optimize SSIS-based ETL processes to enable seamless data integration, transformation, and movement across enterprise systems.
- Write, review, and optimize complex T-SQL scripts to improve query performance, system efficiency, and overall database reliability.
- Establish comprehensive data quality frameworks and processes to maintain accurate, consistent, complete, and reliable datasets across the organization.
- Implement sophisticated deduplication strategies to eliminate redundant records and strengthen the overall reliability and integrity of enterprise data.
- Partner with stakeholders to understand business requirements and translate them into scalable, secure, and effective technical data solutions.
- Support enterprise reporting and analytical capabilities by ensuring data architectures are structured to meet advanced Power BI and business intelligence requirements.
Requirements
- Minimum of 12 years of professional experience in data architecture, database management, or closely related disciplines.
- Deep expertise with SQL Server 2025, including hands-on knowledge of Temporal Tables and Resource Governor capabilities.
- Strong proficiency in implementing and managing Row-Level Security (RLS) and applying appropriate data access and privacy controls.
- Hands-on experience with SSIS for data integration and transformation, combined with strong proficiency in advanced T-SQL development and optimization.
- Demonstrated experience establishing data quality practices, maintaining data integrity, and implementing effective deduplication strategies.
- Familiarity with Power BI and NetSuite ecosystems, particularly in relation to enterprise reporting, analytics, and resource planning.
- Ability to design scalable technical solutions and make sound architectural decisions across complex enterprise data environments.
- Strong communication and collaboration skills, with the ability to translate business requirements into practical technical solutions.
- Ability to work effectively within the IT Services sector and deliver data solutions aligned with established technical and industry standards.
- Strong problem-solving skills, attention to detail, and a structured approach to improving data performance, quality, and reliability.
Conditions
- Compensation of ₹15–18 LPA.
- Full-time position.
- Fully remote opportunity based in India.
- Opportunity to take ownership of enterprise data architecture and contribute to critical data and business intelligence initiatives.
- Work across SQL Server 2025, SSIS, T-SQL, Power BI, and NetSuite in an enterprise data environment.
- Direct opportunity to strengthen data integrity, security, performance, and analytical capabilities across the organization.