Sr. SQL Server Data Engineer

Job Title : Senior SQL Server Data Engineer

Location : Remote / Hybrid

Department : Information Technology and Product Development

Reports To : Sr. Director of Engineering

Job Summary

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. The ideal candidate brings extensive experience in SQL Server development with specific expertise in healthcare data processing, with the ability to bridge the gap between our legacy systems and future state architecture.

We are seeking a highly skilled Senior SQL Server Data Engineer to join our dynamic team. The ideal candidate will have significant experience working with complex SQL Server environments, ETL processes, and stored procedure optimization. They should demonstrate expertise in data quality assurance and validation, along with a solid understanding of healthcare claims processing. Proficiency in T-SQL, performance tuning, and data pipeline development is essential. In this role, you will play a pivotal part in ensuring the stability of our current operations while facilitating a smooth transition to our new data architecture.

Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States.

Key Responsibilities

• 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

Qualifications

Preferred Qualifications

Who is SmartLight Analytics

SmartLight Analytics was formed by a group of industry insiders who wanted to make a meaningful impact on the rising cost of healthcare. With this end in mind, SmartLight works for self-funded employers to reduce the wasteful spend in their healthcare plan through our proprietary data analysis. Our process works behind the scenes to save money without interrupting employee benefits or requiring employee behavior changes.