[Remote] Senior Data Engineer (REMOTE OR MA BASED)
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