Application Engineer ETL

Our IT department is seeking an ETL Developer to join our growing team in our Worcester, MA office.

Position summary:

The ETL Developer will be responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions. Proven experience in data profiling, analysis and cleansing.

This is a Full-time, Exempt role.

Responsibilities/Essential Functions:        

• Interprets and may contribute to the technical design and specifications, writes code, and assists in development of new applications and products and enhancements to existing applications and products, helps to solve complex problems.
• Writes test cases and executes thorough unit testing to verify the accuracy and quality of all software developed. This may include preparation of sample test data, execution of scripts and programs, and system integration testing. 
• Performs required functions in accordance with the various application development methodologies i.e. Agile / Waterfall etc.
• Identifies risks, escalates appropriately, seeks guidance and recommend alternative approaches.
• Supports setup of multiple test environments.
• Engages in application defect resolution identified during project lifecycle and in support of production systems.
• Adheres to all application development quality standards and suggests areas of improvement.
• Will support technical implementation planning and execution of software releases.
• Contributes to project planning, design, and estimating activities.  
• Stays current and builds knowledge of programming languages, application development tools, best practices, and methodologies. 
• Provides timely and accurate project status reporting, proactively identifies risks and challenges. 
• Collaborates and facilitates effectively with team members, including offsite and offshore. 
• Builds knowledge of P&C insurance concepts, business processes and Hanover systems. 
• Responsible for developing software application solutions of intermediate complexity for all or a component part of an assigned project.

Position Requirements:

• Bachelor’s degree is required
• 3+ years of working experience on ETL tools like Informatica PowerCenter and databases like Oracle & SQL server.
• 1+ years of working experience on reporting tools like PowerBI.
• Must be eligible to work in the United States without sponsorship now or in the future

Personal and Professional Competencies: 

• Highly self-motivated contributor with proven track record of obtaining results without significant direct report authority assigning tasks.
• Capability to manage multiple priorities and tasks simultaneously; Easily adapts to new or different changing situations, requirements or priorities.
• Interpersonal & relationship building skills: ability to work well as an individual and within a team personal drive to continually grow and enhance skills, knowledge, and scope of responsibilities.
• Demonstrates solid verbal/written communication, listening, communication skills with and ability to communicate across all employee and management levels.
• Displays a high degree of initiative and effective organization and time management skills, strong analytical ability, and ability to work with data.
• Excellent organizational skills and attention to detail, Quality oriented, self-directed, with problem solving ability.

Vaccination Status:

Hanover has enacted policies and protocols throughout the COVID-19 pandemic to promote employee health and safety. To that end, all employees are expected to provide true and accurate information regarding their vaccine status, and when requested, employees are expected to provide proof of such status. Hanover recognizes employee privacy concerns and only provides vaccine status information on a need-to-know basis.  The Hanover complies with all federal, state and local laws, and with respect to such laws related to COVID-19 health and safety, it is typical for there to be a distinction in compliance obligations between vaccinated and unvaccinated individuals. Therefore, various Hanover policies and requirements are connected to vaccine status, including but not limited to, the company’s Facial Coverings and Social Distancing policy.  Employees declining to provide information related to their vaccine status, will be considered unvaccinated or not fully vaccinated for the purposes of The Hanover’s COVID-19 health and safety policies and protocols.

Please be advised that while Hanover does not expect to institute a vaccine mandate at this time, Hanover encourages employees to get vaccinated and boosted, and provides paid time off to both obtain and recover from the vaccine(s) and booster(s).

EEO statement:

The Hanover values diversity in the workplace and among our customers.  The company provides equal opportunity for employment and promotion to all qualified employees and applicants on the basis of experience, training, education, and ability to do the available work without regard to race, religion, color, age, sex/gender, sexual orientation, national origin, gender identity, disability, marital status, veteran status, genetic information, ancestry or any other status protected by law.  

Furthermore, The Hanover Insurance Group is committed to providing an equal opportunity workplace that is free of discrimination and harassment based on national origin, race, color, religion, gender, ancestry, age, sexual orientation, gender identity, disability, marital status, veteran status, genetic information or any other status protected by law.” 

As an equal opportunity employer, Hanover does not discriminate against qualified individuals with disabilities.  Individuals with disabilities who wish to request a reasonable accommodation to participate in the job application or interview process, or to perform essential job functions, should contact us at: HRServices@hanover.com and include the link of the job posting in which you are interested.

Privacy Policy:

To view our privacy policy and online privacy statement, click here.  

Applicants who are California residents: To see the types of information we may collect from applicants and employees and how we use it, please click here.