Job Title: Data Integration Specialist (SQL Server) 

Location: Remote 

Job Type: Full-Time  

Job Description: 

We are seeking an experienced Data Integration Specialist to lead and manage data integration efforts between our organization and a third-party partner. This role requires strong SQL Server expertise and experience in both database administration and development. Familiarity with Oracle is a significant plus. 

Key Responsibilities: 

• Design, implement, and maintain robust and scalable data integration processes between internal systems and external partners. 
• Develop and maintain ETL (Extract, Transform, Load) processes using SQL Server technologies. 
• Optimize and troubleshoot SQL queries, stored procedures, and data pipelines. 
• Monitor data flow and integrity across systems to ensure accuracy, consistency, and performance. 
• Perform database administration tasks including backups, restores, performance tuning, and security management. 
• Collaborate with internal teams and external stakeholders to define data integration requirements. 
• Document data mapping, workflows, and integration processes. 
• Ensure compliance with data governance and security standards. 

Requirements: 

• Proven experience in SQL Server database development and administration (minimum 5 years). 
• Strong understanding of data modeling, indexing, and query optimization. 
• Proficient in writing complex T-SQL queries, stored procedures, triggers, and functions. 
• Experience with data integration, data migration, or ETL tools and frameworks. 
• Knowledge of Oracle database concepts and ability to work across Oracle systems is a plus. 
• Familiarity with data security, privacy regulations, and best practices. 
• Strong problem-solving skills and attention to detail. 
• Excellent communication and collaboration abilities. 

Preferred Qualifications: 

• Experience with SSIS (SQL Server Integration Services) or similar tools. 
• Experience working on cross-organizational or B2B data integration projects. 
• Knowledge of cloud data platforms (Azure) is a plus.