SQL Report Developer in Lincoln, RI at Amica

Date Posted: 11/24/2021

Job Snapshot

Job Description

SQL Report Developer
50 Amica Way, Lincoln, RI 02865

Want to build the future?
The feeling is mutual.


  • Collaborate with technical & business partners to enhance the analytic capabilities of the Accounting Department through development and maintenance of financial & operational reporting
  • Gather requirements, develop, and manipulate reports by translating raw data from various sources into meaningful reports
  • Research discrepancies between report output and end user expectations
  • Assist in supporting and maintaining data repositories
  • Serve as a technical liaison between departments and consultants regarding technical issues
  • Assist BI group with resolution of defects and development of reports and BI tools


  • Bachelor’s Degree in Accounting, Finance or Information Technology
  • At least 1 year of work experience in Business Intelligence is preferred
  • Solid commitment to pre-production testing and strong attention to detail.
  • Ability to work independently on multiple tasks with differing priorities.
  • Strong knowledge of SQL, MS Excel, and Business Intelligence tools.
  • Familiarity with data storage, retrieval, and manipulation methods within both relational and non-relational database architectures.
  • Capacity for troubleshooting data- or performance-related system issues using logical problem-solving methods and process of elimination.
  • Excellent written and verbal communication skills.
  • Experience with Oracle Financials products preferred but not required
  • Python, VBA, and/or batch scripting languages will also be a plus.
  • Understanding of key financial performance metrics and knowledge of basic accounting principles preferred.

This position is not remote and will require the selected candidate to report to the office in Lincoln, RI.

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.