Business Intelligence (BI) Analyst in Lincoln, RI at Amica

Date Posted: 10/16/2021

Job Snapshot

Job Description

Amica Life – Data Services
10 Amica Way
Lincoln RI 02865

Want to provide customers with solutions for life?
The feeling is mutual.


  • Drive business value by transforming data and analytics into actionable insights
  • Serve as a liaison between business users and technical resources
  • Demonstrate strong business acumen and understanding of insurance concepts
  • Review new and existing data sources to ensure integrity of data collection and utilization
  • Write SQL or other querying code to extract and manipulate data from database systems
  • Design and implement data management procedures, including cleaning and organizing raw data and writing technical requirements
  • Perform data profiling to identify and understand anomalies and errors and provide timely resolutions
  • Identify and analyze significant trends that affect the organization and their key drivers to optimize business decisions
  • Utilize business intelligence tools to design, construct, test, and deploy self-service reports and visualizations
  • Assist business users by sharing insights, providing supporting details, making recommendations, and measuring results
  • Ensure accuracy of data results and analytic methods through testing and validation of underlying report data
  • Translate and summarize data results into written reports, tables, graphs and charts to convey information to management
  • Perform ongoing monitoring and refinement of analytics and metrics
  • Provide advanced technical support for analytics consumers
  • Committed to continuous professional improvement and displays a desire to learn the new and different (through conferences, publications, courses, local academia and meetups)
  • Promote collaboration with other business intelligence teams and encouraging reuse of artifacts
  • Follow applicable enterprise wide data standards, policies and processes are executed and observed


  • Bachelor’s degree in Computer Information Systems, Computer Science or Math
  • Strong analytical skills
  • Strong organizational, written and verbal communication skills
  • Strong knowledge of Structured Query Language (SQL)
  • Experience with data warehouse principles
  • Experience with PowerBI or other data visualization software
  • Knowledge of Agile Methodology tools such as Jira and Confluence
  • Knowledge of Snowflake Data Warehouse preferred
  • Knowledge of life insurance principles a plus

Perks and Benefits

  • Paid vacation, holidays and sick days
  • Generous leave programs, including paid parental bonding leave
  • Medical, dental, vision coverage, short- and long-term disability, and life insurance
  • Generous retirement benefits
  • Opportunities for advancement in a successful and growing company

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.