Jr. SQL Developer
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 related to Microsoft SQL Server databases and the Merchants Insight Business Intelligence platform. It also provides development and maintenance support for an internal SharePoint application written in C#. The successful candidate will build knowledge of the company’s technology environment through formal and on-the-job training and stay informed about developments in its technology stack. The 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 role may provide after-hours technical support as needed and requires adherence to the change management process.
Requirements
- Bachelor’s degree in computer science.
- 0–3 years of experience in SQL development, with hands-on experience using 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.
- 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, SSRS, or 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 supporting data integration and Business Intelligence solutions.
- Meet timelines for assigned deliverables and promptly bring roadblocks or obstacles that could delay delivery to management for resolution.
- Unit test and system test all changes to ensure solutions operate according to specification.
- Provide after-hours technical support as needed and follow 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 with two full days per week in the office and flexibility to work remotely or in the office on remaining days.
- Competitive pay scale and an outstanding company bonus program.
- Generous paid time off package.
- Health, dental, vision, life insurance, and short-term disability benefits.
- 401(k) employer match of 100% up to 6% of annual contributions, immediately 100% vested.
- Tuition reimbursement.
- Equity component and comprehensive benefits package.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
