[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.ResponsibilitiesComplete data integration, data warehouse design, and build scalable ETL pipelinesDisplay data engineering best practices for data storage, integration, transformation, and access within cloud and on-premises platformsHave a strong understanding of Medallion Architecture and Data Lake best practicesHave knowledge of data modeling, governance, and security best practicesEnsure data security and compliance within industry standardsHave familiarity with integration connectors (APIs, File, SFTP/FTPS, Streaming Data, DB Connectors, SOAP, REST)Develop and maintain documentation for data integration and ETL solutionsBuild solutions within Azure Data Services (Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage)Create solutions using pySpark/SparkSQL, and Delta TablesCreate documentation for data processesCollaborate with data scientists, analysts, and stakeholdersCoach, mentor, and serve as technical guidance for junior team membersWork within agile development methodologies and use DevOps best practicesSkillsBachelor's degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent5 plus years professional experience in data engineering, data architecture, and/or data integrationAdvanced proficiency in SQL and PythonExperience working with Azure, AWS, GCP, or other cloudStrong problem-solving, communication, and collaboration skillsCritical thinking and attention to detailMust 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 certificationExperience in optimizing data pipelines for scale, performance, reliability, and cost efficiencyPowerBI experienceAzure DevOps experienceAzure Synapse Analytics and/or Microsoft Fabric experienceMasters in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalentActuarial or pricing experience within insurance industryBenefitsMedical, dental, vision, life, and disability insurance401K with a company matchTuition reimbursementPTOCompany paid holidaysFlexible work arrangementsCultural Awareness Day in support of IDEOn-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 awardsCompany OverviewThe 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/.