Senior SQL Engineer: Data Performance & ETL Lead

Wellfleet; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Wellfleet, part of the Berkshire Hathaway family, seeks a Senior SQL Engineer to lead design, optimization, and maintenance of critical data systems powering healthcare operations. You will develop databases, optimize performance, and work with cross-functional teams to ensure robust, scalable data infrastructure.

Responsibilities include implementing advanced T-SQL solutions, ETL pipelines with SSIS, and guiding data governance while mentoring junior developers and aligning with IT leadership.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field
• 5+ years of experience in an information technology role
• Proven ability with requirement development and strong analytical skills
• Deep expertise in T-SQL, stored procedures, indexing, and query optimization
• Strong understanding of the Microsoft tech stack (.NET, Visual Studio)
• Experience with CI/CD tools (Jenkins, Git) and automated deployments
• Proficiency with Microsoft Office Suite incl. Excel, Visio, PowerPoint, Word and Access
• Ability to juggle multiple tasks in a fast-paced environment
• Healthcare insurance domain experience is a plus

Responsibilities

• Architect and optimize complex SQL Server databases for high-volume healthcare systems
• Design and implement advanced T-SQL solutions including stored procedures, triggers, views, and indexing strategies
• Lead performance tuning with query profiling and execution plan analysis
• Develop and maintain ETL pipelines using SSIS to ingest and transform healthcare data
• Collaborate with DevOps to enhance CI/CD pipelines for DB deployments
• Drive data architecture decisions including normalization and partitioning
• Mentor junior developers and establish SQL development standards
• Translate business requirements into scalable data solutions
• Automate and monitor overnight jobs and scheduled processes
• Manage production environments and triage issues across systems
• Document data flows and system dependencies
• Analyze metrics and recommend long-term improvements
• Support system upgrades and after-hours maintenance
• Lead demos of new features to IT and business teams
• Perform other duties as assigned

Skills

T-SQL

Stored procedures

Indexing

Query optimization

CI/CD concepts

Microsoft .NET/Visual Studio

Analytical reasoning

Education

Bachelor's degree in Computer Science/IT or related

5+ years in IT role

Tools

SQL Server

SSIS

Jenkins

Git

Jira

Job description

Wellfleet, part of the Berkshire Hathaway family, seeks a Senior SQL Engineer to lead design, optimization, and maintenance of critical data systems powering healthcare operations. You will develop databases, optimize performance, and work with cross-functional teams to ensure robust, scalable data infrastructure.

Responsibilities include implementing advanced T-SQL solutions, ETL pipelines with SSIS, and guiding data governance while mentoring junior developers and aligning with IT leadership.