Jr. SQL Developer

Merchants Insurance Group • Buffalo, NY

1d • Hybrid

About The Position

Merchants Insurance Group is seeking a Jr. SQL Developer to join its Information Technology team in Buffalo, New York. Under the direction of the Manager, Enterprise Integration Services, this role supports SQL development and ETL/data integration for the company’s Microsoft SQL Server databases and Merchants Insight Business Intelligence platform. It also provides development and maintenance support for an internal SharePoint application written in C#. The successful candidate will learn the company’s environment and technology stack through formal and on-the-job training.

This position follows a hybrid schedule requiring two full days per week in the office, with flexibility to work remotely or in the office on the remaining days. The estimated salary range is $55,000–$81,000, depending on leveling and geography, with an equity component and comprehensive benefits. Actual compensation may vary based on skills, experience, and qualifications.

Requirements

• Bachelor’s degree in computer science.
• 0–3 years of experience in SQL development.
• Hands-on experience with an ETL platform.
• Experience with C# to support and maintain an internal SharePoint application.
• Solid working knowledge of SQL/T-SQL development.
• Familiarity with the IT Systems Development Lifecycle.
• Strong analytical skills and 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.
• Experience with insurance or financial institution automation systems.
• Experience with the Microsoft ETL stack, including SSIS, SSAS, and SSRS/Power BI; exposure to other ETL tools such as Informatica or Talend is acceptable.

Responsibilities

• Support the development and maintenance of SQL queries, stored procedures, and database objects in Microsoft SQL Server under the guidance of senior developers.
• Support and maintain an internal SharePoint application written in C#, including bug fixes, enhancements, and ongoing development tasks.
• Develop and maintain ETL processes for data integration and Business Intelligence solutions.
• Meet timelines for assigned deliverables and complete work within expected timelines.
• Bring roadblocks or obstacles that could cause a missed deliverable due date to management’s attention promptly.
• Unit test and system test all changes to ensure solutions operate according to specification.
• Provide technical support after hours as needed and adhere to the change management process.

Benefits

• Welcoming and positive work environment.
• Colleague appreciation events.
• Flexible work arrangements, including flexible scheduling and summer hours.
• Hybrid work schedule.
• Competitive pay scale.
• Company bonus program.
• Generous paid time off package.
• Health, dental, vision, and life insurance.
• Short-term disability coverage.
• 401(k) employer match of 100% up to 6% of annual contributions, with immediate 100% vesting in employer match dollars.
• Tuition reimbursement.
• Equity component.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level