SQL Developer

Merchants Insurance Group; Buffalo (NY); Hybrid; USD 60,000 - 80,000; Full time

Benefits offered by this job

Hybrid work schedule

Two in-office days per week

Job summary

Merchants Insurance Group is seeking a SQL Developer to join the IT team in Buffalo, NY. The role focuses on SQL development, ETL/data integration, and supporting an internal SharePoint app written in C#. The position blends in-office collaboration with flexible remote work.

The ideal candidate has 2-3 years of SQL development experience, strong T-SQL, and familiarity with the Microsoft ETL stack (SSIS/SSAS/SSRS) or similar tools. A CS degree is required.

Qualifications

• Bachelor's degree in CS or equivalent.
• 2-3 years' SQL development experience with ETL.
• Experience with Microsoft SQL Server preferred but not required.
• Experience with C# to support SharePoint application.

Responsibilities

• Develop and maintain SQL queries, stored procedures, and database objects in MS SQL Server.
• Support and maintain internal SharePoint app written in C#; fix bugs and implement enhancements.
• Develop and maintain ETL processes for data integration and BI solutions (SSIS/SSAS).
• Meet timelines and escalate blockers to management.
• Unit and system test changes to ensure specifications.
• Provide after-hours support as needed and follow change management.

Skills

SQL development

ETL

T-SQL

C#

SharePoint

MS SQL Server

BI tooling

Analytical skills

Communication

Education

Bachelor's degree in computer science

Tools

SSIS

SSAS

SSRS/Power BI

Microsoft SQL Server

Job description

Hybrid Work Schedule Buffalo, NY Merchants Insurance Group is a leading Property and Casualty Insurer in the Northeast and is looking for a SQL Developer to join our Information Technology team located in Buffalo, New York.

The SQL Developer Under the direction of the Manager, Enterprise Integration Services, the SQL Developer is responsible for SQL development and ETL/data integration support related to Merchants' Microsoft SQL Server databases and Merchants Insight Business Intelligence platform, along with development support of an internal SharePoint application written in C#. The successful candidate will strive, through formal and on-the-job training, to be knowledgeable about our environment as well as recent developments in the technology stack that have been implemented.

Merchants Insurance Group Is Rated A- (Excellent) With a Stable Outlook By A.M. Best And Is Consistently Recognized As a Top Employer And High-performing Organization. Recent Honors Include

• Best Places to Work in Western New York (Buffalo Business First, 2023--2026)
• Fast Track Company (2019--2025) and Top Private Company (2019--2025)
• Ward's 50® top-performing property-casualty insurer (2021--2024)
• Ivans Spark Award for Innovation (2024--2025)
• Named to Newsweek and Statista's America's Most Reliable Companies list (2025), ranked among the top 300 of 1,500 B2B organizations evaluated

We offer a hybrid work schedule, requiring two full days per week in the office, with flexibility to work remotely or in office the remaining days. This model supports collaboration while providing flexibility and work-life balance.

Essential Duties and Responsibilities include, but are not limited to:

• Supports the development and maintenance of SQL queries, stored procedures, and database objects in MS SQL Server under the guidance of senior developers.
• Supports and maintains an internal SharePoint application written in C#, including bug fixes, enhancements, and ongoing development tasks.
• Develops and maintains ETL processes to support data integration and Business Intelligence solutions; the Microsoft ETL stack (SSIS/SSAS) is preferred, but exposure to other ETL platforms is acceptable.
• Works to meet timelines for assigned deliverables and completes work within expected timelines. Immediately brings identified roadblocks and/or obstacles that would result in missing a deliverable due date, to management's attention for a resolution.
• Unit and System test all changes to ensure solutions operate according to specification.
• Provides after-hours of technical support as needed and adheres to change management process.

Qualifications & Skills

• Bachelor's degree in computer science required.
• 2-3 years' experience in SQL development required along with hands on experience with ETL Platform
• Experience with Microsoft SQL Server is a plus but not required.
• Experience with C# is required to support and maintain an internal SharePoint application.
• Experience with insurance or financial institution automation systems is a plus.
• Solid working knowledge of SQL/T-SQL development.
• Experience with C# for application development and ongoing support of an internal SharePoint application.
• Experience with an ETL platform; the Microsoft ETL stack (SSIS, SSAS, SSRS/Power BI) is preferred, but exposure to other ETL tools (e.g., Informatica, Talend) is acceptable.
• Familiarity with the IT Systems Development Lifecycle.
• Strong analytical skills and the ability to work effectively with business partners, stakeholders, developers, and DBAs.
• Proven ability to troubleshoot issues and provide appropriate technical resolution in a timely manner.

Merchants Insurance Group Pay Information

Merchants Insurance Group offers a competitive pay scale. Merchants Insurance Group offers a competitive pay scale. The estimated salary for this role ranges from $60,000 - $80,000 based on leveling and geography, along with an equity component and a comprehensive benefits package. This range is merely an estimate; actual compensation may deviate from this range based on skills, experience and qualifications.

Merchants Insurance Group Benefits

• Welcoming and positive work environment.
• Colleague Appreciation events.
• Flexible work arrangements, including flex scheduling and summer hours.
• Hybrid work schedule. The Hybrid work schedule will require 2 full days per week in the office, with the option to work the remaining days per month at home or in the office.
• Flexible work arrangements, including flex scheduling and summer hours.
• Competitive pay scale.
• Outstanding company bonus program.
• Generous paid time off package.
• Full Benefits: Health, Dental, Vision, Life Insurance, Short Term Disability, 401(k) employer match amount is 100% up to 6% of your annual contributions. You are immediately 100% vested in the employer match dollars.
• Tuition Reimbursement.

And many more exciting company benefits!!

Merchants Insurance Group is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Merchants Insurance Group supports a safe workplace through pre-employment background screenings.