What are the responsibilities and job description for the Workflow & Extract, Transform and Load (ETL) Developer position at Merchants Group?
Workflow & Extract, Transform and Load (ETL) Developer
Hybrid Work Schedule
Buffalo, NY
Merchants Insurance Group is a leading Property and Casualty Insurer in the Northeast and is looking for a Workflow & ETL Developer to join our Information Technology team located in Buffalo, New York.
The Workflow & ETL Developer will support and administer ImageRight, our document management and workflow system, and manage ETL(Extract, Transform, Load) process to ensure smooth data integration and workflow optimization. This role involves troubleshooting workflows, writing and optimizing SQL queries, collaborating with business teams to enhance business processes, and ensuring seamless data exchange with third-party vendors or systems. Responsibilities also include working on importing data into ImageRight to streamline operations.
Merchants Insurance Group, rated A- (Excellent) with a positive outlook by the A.M. Best Company, is proud to be one of Buffalo Business First’s Best Places to Work in Western New York (2023, 2024), a Fast Track company (2019-2024), and a Top Private Company (2019-2024). Merchants has been granted Ward’s 50 designation as a top-performing property-casualty insurance company for four consecutive years. In October 2024, Newsweek and Statista included Merchants Insurance Group on their first-ever America’s Most Reliable Companies list, which highlights organizations that other companies can feel confident doing business with in 2025. Of 1,500 B2B companies evaluated, Merchants was one of only 300 companies to make the list.
Merchants offers its colleagues a Hybrid work schedule. The Hybrid work schedule requires 8 full days per month in the office, with the option to work the remaining days at home or in the office. This exciting Hybrid Work benefit offers colleagues a flexible work schedule with the ability to remain connected with their Merchants team and colleagues.
Essential Duties and Responsibilities include, but are not limited to :
- Develop and maintain the technical infrastructure required for ImageRight, including designing and maintaining a new workflow. Ability to Extract Data and report to third-party services.
- Perform unit testing on changes and follow the Change Management process for implementation.
- Prepare Technical Specification documentation before the beginning of development and complete technical documentation for all assigned development initiatives. Review approaches for compliance with technical architecture standards.
Qualifications & Skills :
Merchants Insurance Group Pay information :
Merchants Insurance Group offers a competitive pay scale. The actual compensation will be determined based upon experience and other factors permitted by law. The initial pay range for this position is $53,700 - $71,500.
Merchants Insurance Group Benefits :
And many more exciting company benefits!! EOE
Salary : $53,700 - $71,500
