SQL Developer

Merchants • Buffalo, NY

3d • Hybrid

About The Position

Merchants Insurance Group is seeking a SQL Developer to join their Information Technology team in Buffalo, New York. This role involves SQL development and ETL/data integration support for the company's Microsoft SQL Server databases and Merchants Insight Business Intelligence platform. The developer will also provide support for an internal SharePoint application written in C#. The company values continuous learning and encourages employees to stay updated with technology advancements. Merchants Insurance Group is a highly-rated and recognized organization, known for being a top employer and high-performing company.

Requirements

• Bachelor’s degree in computer science required.
• 2-3 years’ experience in SQL development required.
• Hands-on experience with an 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.
• Competitive pay scale.
• Outstanding company bonus program.
• Generous paid time off package.
• Health, Dental, Vision, Life Insurance, Short Term Disability.
• 401(k) employer match amount is 100% up to 6% of your annual contributions.
• Tuition Reimbursement.

What This Job Offers

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