Data Engineer

Data Engineer - Marketing Data Science - Hybrid (Marketing & Communications) 50 Amica Way, Lincoln, RI 02865 Thank you for considering Amica as part of your career journey, where your future is our business . At Amica, we strive to build a culture of belonging where employees are encouraged to share their unique experience to enrich our workplace, strengthen our company's mission and broaden our vision of what's possible. We're focused on creating a workplace that works for all. We'll continue to provide training, guidance, and resources to make Amica a true place of belonging for all employees. Want to learn more about our commitment to diversity, equity, and inclusion? Visit our DEI page to read about it As a mutual company, our people are our priority. We seek differences of opinion, life experience and perspective to represent the diversity of our policyholders and achieve the best possible outcomes. This position is hybrid and requires onsite days at our Lincoln, RI campus. This role does not currently offer employment visa sponsorship. Job Overview: This position involves designing and maintaining large data systems to help deliver analytical solutions that will influence brand and acquisition marketing spend through Online and Print Channels. This position requires strong analytical and problem-solving skills as well as outstanding communication skills, both verbal and written, with the ability to clearly summarize and present insights. Responsibilities: Design, build and maintain Marketing Data Infrastructure in partnership with vendor companies that support processing of credit bureau data. Consult and partner with internal stakeholders to develop analytic agenda to optimize direct marketing spend for customer acquisition. Manage execution of analytics projects and deliverables including developing project plans and reviewing results. Collaborate with Data Scientists to deploy and maintain state of the art predictive analytic approaches to optimize end-to-end acquisition economics (including response, conversion, premium, risk and lifetime value models). Design and deploy framework for Campaign execution to enable audience-based targeting across both online and offline channels, utilizing the Marketing Infrastructure. Design and deliver key marketing metrics and results to track business performance and identify areas of opportunities and risks. Utilize deep understanding of media program results and strong communication skills to influence decision making and spend optimization decisions. Build partnerships with other leaders in marketing and across data analytics organizations to share knowledge and insights, align on best practices, and drive improvements. Monitor and report test results and enable adoption of appropriate tests in all Marketing Channels and across customer life cycle. Requirements: 5 years data analytics experience within the Financial Services sector, particularly consumer P&C insurance business Direct Marketing subject matter expertise. Analytical and problem-solving skills including the ability to develop solutions to direct marketing business problems using data analysis. Experience designing and deploying analytical framework for Campaign execution - including data validation, model scoring, audience selection, automated quality checks. Advanced knowledge and experience in Python. Discover, understand, and integrate new internal and external data sources, structures, and process pipelines Experience with AWS or similar cloud environments. Experience exploring and manipulating large amounts of structured and unstructured data using SQL. Excellent written and oral communication skills and ability to present technical results to non-technical audiences. Ability to work in a matrixed environment with excellent interpersonal and influencing skills. Strong project management skills, capable of managing project timelines and deliverables autonomously. Total Rewards: Medical, dental, vision coverage, short- and long-term disability, and life insurance Paid Vacation - you will receive at least 13 vacation days in the first 12 months, amounts could be greater depending on the role. While able to use prior to accrual, vacation time will accrue monthly. Holidays - 14 paid holidays observed Sick time - 6 days sick time at hire, 6 additional days sick time at 90 days of employment Generous 401k with company match and immediate vesting. Additionally, annual 3% non-elective employer contribution Annual Success Sharing Plan - Paid to eligible employees if company meets or exceeds combined ratio, growth and/or service goals Generous leave programs, including paid parental bonding leave Student Loan Repayment and Tuition Reimbursement programs Generous fitness and wellness reimbursement Employee community involvement Strong relationships, lifelong friendships Opportunities for advancement in a successful and growing company Amica conducts background checks which includes a review of criminal, educational, employment and social media histories, and if the role involves use of a company vehicle, a motor vehicle or driving history report. The background check will not be initiated until after a conditional offer of employment is made and the candidate accepts the offer. Qualified applicants with arrest or conviction records will be considered for employment. The safety and security of our employees and our customers is a top priority. Employees may have access to employees' and customers' personal and financial information in order to perform their job duties. Candidates with a criminal history that imposes a direct or indirect threat to our employees' or customers' physical, mental or financial well-being may result in the withdrawal of the conditional offer of employment. About Amica Amica Mutual Insurance Company is America's oldest mutual insurer of automobiles. A direct national writer, Amica also offers home, marine and umbrella insurance. Amica Life Insurance Company, a wholly owned subsidiary, provides life insurance and retirement solutions. Amica was founded on the principles of creating peace of mind and building enduring relationships for and with our exceptionally loyal policyholders, a mission that thousands of employees in offices nationwide share and support. Equal Opportunity Policy: All qualified applicants who are authorized to work in the United States will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity, gender expression, sexual orientation, family status, ethnicity, age, national origin, ancestry, physical and/or mental disability, mental condition, military status, genetic information or any other class protected by law. The Age Discrimination in Employment Act prohibits discrimination on the basis of age with respect to individuals who are 40 years of age or older. Employees are subject to the provisions of the Workers' Compensation Act.