Senior SQL Engineer

Wellfleet, a Berkshire Hathaway company, delivers customer-centric accident and health insurance, with quality service and uncompromising ethics. Wellfleet works to protect people against risk throughout every stage of life – from grade school to college to the workplace. Founded in 1993 as Consolidated Health Plans (CHP), Wellfleet, headquartered in Springfield, Mass., is one of the nation’s leading providers of health and accident insurance products to the higher education market. The Senior SQL Engineer will lead the design, optimization, and maintenance of mission-critical data systems that power our healthcare operations. This includes planning, developing and maintaining company databases while solving performance challenges in a complex environment. This role will also work closely with cross-functional teams, external vendors, and IT leadership to ensure our data infrastructure is robust, scalable, and secure. In this role, you will… Architect and optimize complex SQL Server databases, ensuring scalability, reliability, and performance across high-volume healthcare systems Design and implement advanced T-SQL solutions including stored procedures, triggers, views, and indexing strategies for mission-critical applications Lead performance tuning efforts, including query profiling, execution plan analysis, and database refactoring to reduce latency and improve throughput Develop and maintain robust ETL pipelines using SSIS or custom frameworks to ingest, transform, and deliver healthcare data across systems Collaborate with DevOps to enhance CI/CD pipelines for database deployments, version control, and rollback strategies Drive data architecture decisions, including normalization, partitioning, and schema evolution to support long-term growth and analytics Mentor junior developers, conduct peer code reviews, and establish SQL development standards and best practices Partner with business analysts and stakeholders to translate complex requirements into scalable data solutions Automate and monitor overnight jobs and scheduled processes, ensuring proactive resolution of failures and bottlenecks Manage production environments, triaging issues across web applications, databases, and third-party integrations Document and maintain operational procedures, data flow diagrams, and system dependencies for transparency and continuity Analyze system metrics, identify root causes of performance degradation, and recommend long-term solutions Participate in strategic planning, contributing to data governance, compliance, and security initiatives Support system upgrades and deployments, including early morning or after-hours maintenance windows Lead demos and technical showcases, presenting new features and optimizations to IT and business teams. Perform other duties as assigned We are looking for candidates with… Bachelor’s degree in Computer Science, Information Technology, or related field and 5+ years of experience in an information technology role, or an equivalent combination of education and experience Proven ability of requirement development experience with strong analytical and prioritization skills to ensure business expectations and goals are met 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 (e.g., Jenkins, Git) and automated deployments Proficiency in Microsoft Office Suite applications including Excel, Visio, PowerPoint, Word and Access Possess critical thinking skills with proven ability to identify and analyze complex problems and review related information to develop and evaluate options to implement solutions Strong written, verbal and presentation skills Excellent project management skills Demonstrated ability to efficiently manage multiple assignments and prioritize a variety of projects in a fast-paced environment to meet deadlines Self-motivated with the ability to work independently, with very little supervisory direction Ability to adapt and pivot and when presented with new information or circumstances Strong interpersonal and communication skills with the ability to work effectively with both internal team members, cross department business areas and external stakeholders Strong collaborative skills to work effectively with business areas at all levels of the organization 2+ years of experience in healthcare insurance, preferred. Familiarity with ETL tools, data warehousing, and healthcare data standards Experience with LAMP stack, JIRA, and PBM/PPO integrations Why Wellfleet? Here at Wellfleet, we foster a culture of growth that enables engaged and high-performing professionals to be empowered to deliver our mission and vision. Our employees are a team devoted to providing customer service that exceeds expectations of our members and clients. Successful team members continually look for ways to improve product delivery and value. Wellfleet offers a competitive compensation package and comprehensive benefits package including life, health and dental, vision, 401K retirement plan, short- and long-term disability coverage, flexible/dependent care spending account, tuition reimbursement, and business casual dress. Are you interested in exploring a career at Wellfleet? Explore our open positions. General: Wellfleet is part of the MedPro Group family. As such, all Wellfleet team members are employees of MedPro Group Inc. We are an Equal Opportunity Employer. The annual gross base salary range is $90,000 to $120,000. This range anticipates the low and high end of the salary for this position. Actual salaries will vary and are based on factors such as a candidate’s qualifications, skills and competencies. Salary is one component of Wellfleet’s total compensation and benefits package, which includes medical, vision and dental insurance options, life and accident insurance, 401(k), and short-term and long-term disability insurance. For a more detailed overview, visit our careers website at: wellfleetinsurance.com/about/careers. #LI-KS1 #LI-Remote