SQL Developer

Merchants Insurance Group•Buffalo, NY

3d•$60,000 - $80,000•Hybrid

About The Position

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

Requirements

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 C# is required to support and maintain an internal SharePoint application.
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.

Nice To Haves

Experience with Microsoft SQL Server is a plus but not required.
Experience with insurance or financial institution automation systems is a plus.

Responsibilities

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.

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