Senior Business Analyst - Data

Senior Business Analyst - Data (Corporate Strategy)

50 Amica Way, Lincoln, RI 02865

This position is hybrid and requires onsite days at our Lincoln, RI campus.

This role does not currently offer employment visa sponsorship.

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.

• Partner with stakeholders to understand the 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 the 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.

• Bachelor’s degree and 3+ years’ experience as a business or data analyst in a data migration or data warehouse role.
• Strong knowledge of 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 (Micro Strategy 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.

• Medical, dental, vision coverage, short‑ and long‑term disability, and life insurance.
• Paid Vacation – at least 13 vacation days in the first 12 months, with accrual monthly.
• Holidays – 14 paid holidays observed.
• Sick time – 6 days at hire, 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 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 include a review of criminal, educational, employment, and social media histories; background checks are not initiated until after a conditional offer 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 customers is a top priority. Employees may have access to 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’ well‑being may result in the withdrawal of the conditional offer of employment.

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 policyholders, a mission that thousands of employees nationwide share and support.

Equal Opportunity Policy:
All qualified applicants who are authorized to work in the United States will receive…