Note: The job is a remote job and is open to candidates in USA. The Hanover Insurance Group is committed to delivering on their promises for over 170 years. They are seeking a Senior Data Engineer to drive complex projects, mentor less experienced engineers, and collaborate with cross-functional teams on data and reporting requests.
Responsibilities
- Complete data integration, data warehouse design, and build scalable ETL pipelines
- Display data engineering best practices for data storage, integration, transformation, and access within cloud and on-premises platforms
- Have a strong understanding of Medallion Architecture and Data Lake best practices
- Have knowledge of data modeling, governance, and security best practices
- Ensure data security and compliance within industry standards
- Have familiarity with integration connectors (APIs, File, SFTP/FTPS, Streaming Data, DB Connectors, SOAP, REST)
- Develop and maintain documentation for data integration and ETL solutions
- Build solutions within Azure Data Services (Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage)
- Create solutions using pySpark/SparkSQL, and Delta Tables
- Create documentation for data processes
- Collaborate with data scientists, analysts, and stakeholders
- Coach, mentor, and serve as technical guidance for junior team members
- Work within agile development methodologies and use DevOps best practices
Skills
- 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, and/or data integration
- Advanced proficiency in SQL and Python
- Experience working with Azure, AWS, GCP, or other cloud
- Strong problem-solving, communication, and collaboration skills
- Critical thinking and attention to detail
- Must be eligible to work in the United States without requiring sponsorship now or in the future (ie. US Citizen or green card holder)
- Microsoft DP-203 or DP-700 certification
- Experience in optimizing data pipelines for scale, performance, reliability, and cost efficiency
- PowerBI experience
- Azure DevOps experience
- Azure Synapse Analytics and/or Microsoft Fabric experience
- Masters in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent
- Actuarial or pricing experience within insurance industry
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)
- Additional compensation may include an annual bonus (which could take the form of a general bonus, sales incentive, or short-term incentive), long-term incentive or spot recognition awards
Company Overview
The Hanover Insurance Group, Inc., based in Worcester, Mass., is the holding company for several property and casualty insurance companies. It was founded in 1852, and is headquartered in Worcester, Massachusetts, USA, with a workforce of 5001-10000 employees. Its website is http://www.hanover.com/.