Senior Business Analyst - Data

Senior Business Analyst - Data (Corporate Strategy) 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 mission and broaden our vision of what’s possible. We refocused 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 the DEI page to read about it! This position is hybrid and requires onsite days at our Lincoln, RI campus. This role does not currently offer employment visa sponsorship. Job Overview Are you a data‑driven problem solver who thrives at the intersection of business and technology? Join our Corporate Strategy team and help shape how we acquire, integrate, and leverage data to drive strategic outcomes. As a Business Analyst – Data, you’ll work closely with business stakeholders, Data & IT teams, and external partners to gather requirements, analyze data sources, and translate business needs into clear technical specifications. Responsibilities Partner with stakeholders to understand business use cases Translate business needs into data requirements and technical specifications for data engineers Analyze source system APIs and data to guide ingestion and transformation Define data mapping, lineage, transformation, and data quality rules required to bridge the gap between source and target Create clear data flow and process diagrams for technical and non‑technical audiences Support development of scalable, reliable data pipelines for analytics and AI Promote data integrity, quality, and governance Communicate insights and recommendations clearly to stakeholders and leadership Recommend tools, products, and services that support enterprise data goals Requirements Bachelor’s degree and 3+ years’ experience as a business or data analyst in a data migration or data warehouse role Strong knowledge of the P&C insurance domain, especially claims and policy administration systems (Guidewire experience is a plus) Familiarity with the Investments domain is a plus Hands‑on experience with AWS (S3, Glue, Athena, Redshift, Lambda), SQL, and BI tools (MicroStrategy a plus), and data platforms like Teradata or Snowflake Proficiency with Agile, Jira, Confluence, Lucid/Visio, and Excel Excellent communication skills and a collaborative mindset A growth mindset and commitment to continuous learning Total Rewards Medical, dental, vision coverage, short‑ and long‑term disability, and life insurance Paid vacation – at least 13 vacation days in the first 12 months; amounts could be greater depending on the role. Vacation time accrues monthly. 14 paid holidays observed 6 days sick time at hire, plus 6 additional days at 90 days of employment Generous 401(k) with company match and immediate vesting; annual 3% non‑elective employer contribution Annual Success Sharing Plan – paid to eligible employees if the 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 opportunities Strong relationships, lifelong friendships Opportunities for advancement in a successful and growing company 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. #J-18808-Ljbffr Amica Mutual Insurance Co