SQL Developer

SQL Developer

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, 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 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 include:

• 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.
• 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.