Senior SQL Server Data Engineer - Remote

Overview

The Senior SQL Server Data Engineer plays a crucial role in maintaining and optimizing our legacy data systems while supporting the organization's migration to a modern data warehouse architecture. This position focuses on enhancing complex ETL processes built on SQL Server stored procedures, implementing robust data validation protocols for medical claims processing, and mentoring junior team members.

In Short

• Lead and enhance complex ETL processes built on SQL Server stored procedures
• Audit, optimize, and refactor existing data pipelines for performance and reliability
• Implement data validation protocols to ensure accuracy of medical claims processing
• Troubleshoot and resolve complex data issues in production environments
• Establish and enforce robust data validation standards for healthcare data processing
• Create systematic approaches to file specification validation and conformance checking
• Implement auditable processes for data quality assurance in a healthcare environment
• Ensure data handling meets relevant healthcare compliance standards
• Provide hands-on mentoring to junior team members
• Create documentation and knowledge transfer sessions on SQL Server best practices
• Establish coding standards and review processes for the legacy systems
• Collaborate with the migration team to ensure smooth transition to the new architecture
• Build reusable templates and frameworks to improve team productivity

Requirements

• Bachelor's degree in Computer Science, Information Systems, or related field
• 8+ years of experience with SQL Server and T-SQL development
• 5+ years specifically focused on ETL processes and data pipeline development
• Extensive experience with stored procedure optimization and complex query tuning
• Strong experience with database performance testing, optimization, and troubleshooting
• Demonstrated ability to mentor junior developers and improve team capabilities
• Experience with JIRA and agile project management tools
• Excellent problem-solving and analytical skills
• Outstanding communication and collaboration abilities

Benefits

• Opportunity to work in a dynamic and impactful environment
• Mentorship and professional development opportunities
• Work with a team dedicated to improving healthcare costs
• Flexible working conditions
• Engagement in meaningful projects