Lead Data Engineer (Hybrid)

About UsAt Selective, we don't just insure uniquely, we employ uniqueness.Selective is a midsized U.S. domestic property and casualty insurance company with a history of strong, consistent financial performance for nearly 100 years. Selective's unique position as both a leading insurance group and an employer of choice is recognized in a wide variety of awards and honors, including listing in Forbes Best Midsize Employers in 2025 and certification as a Great Place to Work® in 2025 for the sixth consecutive year.Employees are empowered and encouraged to Be Uniquely You by being their true, unique selves and contributing their diverse talents, experiences, and perspectives to our shared success. Together, we are a high-performing team working to serve our customers responsibly by helping to mitigate loss, keep them safe, and restore their lives and businesses after an insured loss occurs.Overview“Applicants must be authorized to work for any employer in the United States. Selective will not sponsor or assume the sponsorship of an employment visa at this time”.Selective Insurance is seeking an energetic and collaborative Data Engineer Team lead to work on data and analytics projects supporting the Claims team within the Information Management group. This group is responsible for technology support of all Data Engineering, Analytics and Reporting for specific business areas. This includes Data Engineering services, Enterprise reporting support and ML Ops Engineering operations for these groups. An ideal candidate will leverage their technical proficiency and leadership competencies to drive the delivery of key objectives. ResponsibilitiesLead a high performing team in the delivery of key components and business deliverables.Ensure both on-time successful delivery, and the technical and architectural quality of the solutions.Collaborate with individuals from all areas of the business and IT organizations to develop accurate business requirements and design architectural solutions.Resolve and escalate technical and project delivery issues as needed.Drive process improvements within the team and across the department to improve efficiency and quality.Work directly with the architecture group to coordinate new design patterns and technology.Assist in prioritizing new development projects, enhancement projects for existing systems, and system maintenance requests.Act as a key contributor in planning and estimation of projectsSupport development of talent within the organization through coaching and mentoring of team members.Ensure design, code, and test plan reviews are conducted as appropriate.QualificationsRequired:Proven history of owning and taking accountability for leading others to complete complex deliverables.Excellent communication skills7+ years of experience leading and/or hands-on development of Data Warehouse/DataLakes, Data integration or Data Engineering projects.Experience in ETL and ELT tools (Databricks preferred)Proficient in Data modeling, PySpark and SQLProficient in modern data architectureExperienced in any of these analytical platforms - PowerBI, AzureMLExperience with DataOps or other automation frameworks.Preferred:SAFe agile work experience or similar agile processCollege degree in Computer Science or Management Information systemsProperty Casualty Insurance experienceExperience working within Azure ecosystemTotal RewardsSelective Insurance offers a total rewards package that includes a competitive base salary, incentive plan eligibility at all levels, and a wide array of benefits designed to help you and your family stay healthy, achieve your financial goals, and balance the demands of your work and personal life. These benefits include comprehensive health care plans, retirement savings plan with company match, discounted Employee Stock Purchase Program, tuition assistance and reimbursement programs, and 20 days of paid time off. Additional details about our total rewards package can be found by visiting our benefits page.The actual base salary is based on geographic location, and the range is representative of salaries for this role throughout Selective's footprint. Additional considerations include relevant education, qualifications, experience, skills, performance, and business needs.Pay RangeUSD $130,000.00 - USD $176,000.00 /Yr. Additional InformationSelective is an Equal Employment Opportunity employer. That means we respect and value every individual’s unique opinions, beliefs, abilities, and perspectives. We are committed to promoting a welcoming culture that celebrates diverse talent, individual identity, different points of view and experiences – and empowers employees to contribute new ideas that support our continued and growing success. Building a highly engaged team is one of our core strategic imperatives, which we believe is enhanced by diversity, equity, and inclusion. We expect and encourage all employees and all of our business partners to embrace, practice, and monitor the attitudes, values, and goals of acceptance; address biases; and foster diversity of viewpoints and opinions.For Massachusetts ApplicantsIt is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.