Senior Data Engineer at The Hanover Insurance Group will design, develop, implement, and maintain data integrations and pipelines while guiding cross-functional data initiatives and collaborating with business partners.
Responsibilities
- Become proficient with all internal and external data produced and consumed by THG.
- Drive larger, more complex projects independently.
- Mentor less experienced engineers.
- Collaborate with business partners and assume a data/tech lead role on cross-functional teams delivering data and reporting solutions.
- Lead design, development, implementation, optimization, and maintenance of data integrations, pipelines, and solutions.
- Design and implement data solutions utilizing Azure resources (Azure Data Factory, Azure Synapse, ADLS, etc).
- Apply strong experience in data integration, ETL processes, and data warehousing.
- Demonstrate advanced proficiency in SQL, Python, and PowerShell.
- Show knowledge of data modeling, governance, and data engineering best practices and patterns.
- Optimize data ingestion pipelines and notebooks for scale, performance, reliability, and cost efficiency.
- Familiarity with integration connectors (APIs, File, SFTP/FTPS, Streaming Data, DB Connectors, SOAP, REST).
- Demonstrate strong problem-solving, communication, and collaboration skills.
- Create documentation for data processes and solutions.
- Ensure data security and compliance with industry standards.
- Apply experience in agile development methodologies and DevOps practices.
- Utilize Git/GitHub for CI/CD.
- Coach, mentor, and provide technical guidance for junior team members.
- Profile and analyze large data sets.
- Apply critical thinking and attention to detail.
- Debug data solution issues.
- Collaborate with data scientists, analysts, and stakeholders.
- Monitor and maintain data pipelines.
- Design, develop, and test data mapping with transformation rules.
- Ensure data quality and reliability.
- Develop and maintain documentation for data integration and ETL solutions.
Requirements
- Bachelorβs degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent.
- 5 plus years of professional experience in data engineering, data architecture, data integration.
- Must be eligible to work in the United States without sponsorship now or in the future (US citizen or green card holder).
Technologies
- Azure Data Factory
- Azure Synapse
- Azure Data Lake Storage (ADLS)
- SQL
- Python
- PowerShell
- APIs
- File-based connectors (SFTP/FTPS, other file connectors)
- Streaming Data
- DB Connectors
- SOAP
- REST
- Git/GitHub
- Power BI
- Microsoft Fabric
Benefits
- Medical, dental, vision, life, and disability insurance
- 401K with a company match
- Tuition reimbursement
- PTO
- Company paid holidays
- Flexible work arrangements
- Cultural Awareness Day in support of IDE
- On-site medical/wellness center (Worcester only)
- Click here for the full list of Benefits
What You Need to Apply
- Bachelorβs degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent.
- 5 plus years professional experience in data engineering, data architecture, data integration.
- Must be eligible to work in the United States without sponsorship now or in the future (US citizen or green card holder).
Preferred
- Microsoft DP-203 or DP-700 certification.
- Microsoft Fabric experience
- Power BI experience
- Masterβs degree in data science, mathematics, statistics, computer science, information systems, business information technology, or equivalent.
Career Development
It is a career path supported by on-the-job experiences, personalized coaching, and comprehensive learning programs designed to help you grow and advance at every level.
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.
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.
Compensation
The target hiring range for this role may vary based on geographic location and other factors, including merit or performance, demonstrated proficiency, skills for the role, education, travel requirements, and experience. The posted salary is USD 100,000 - 125,000 per year. Additional compensation may include an annual bonus, long-term incentive, or spot recognition awards.
