This site uses cookies. To find out more, see our Cookies Policy

Enterprise Data Warehouse Architect in Lincoln, RI at Amica

Date Posted: 6/18/2019

Job Snapshot

  • Employee Type:
  • Location:
    Lincoln, RI
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Enterprise Data Warehouse Architect
25 Amica Way, Lincoln, RI 02865

Want to be on a team that’s building the future?
The feeling is mutual.

Assist in building and maturing the Enterprise Data Warehouse (EDW) strategy and roadmap
Architect and develop scalable and comprehensive enterprise analytics solutions including extraction of data from multiple sources, transforming data according to business rules and MDM patterns, and loading data into operational and presentation models.
Design and implementation of data warehouse and data mart concepts.
Provide architectural direction to team members, mission critical work streams and work within the agile framework.
Lead continuous improvement efforts to enhance performance and provide increased analytics and business intelligence capabilities.
Research industry trends related to enterprise data and incorporating best practices into the roadmap and solutions.
Establish current and long-range direction of technologies needed to support analytics and reporting solutions to remain current with product and technical capabilities.
Collaborate with Amica’s external partners to provide direction and oversite of all analytics and Big Data solutions.
Conduct research and makes recommendations on emerging technologies to support the company’s analytics goals

Bachelor's degree and at least 9+ years’ experience in Data Analytics, Data Warehouse, and Data Modeling with experience architecting and developing scalable and comprehensive enterprise data solutions.
Strong understanding of relational/dimensional data structures and Big Data concepts or an equivalent combination of education and experience sufficient to successfully perform the essential functions of the job.
Experience with Teradata concepts and architecture
Experience with SAS, MicroStrategy or equivalent reporting toolset
Experience with ETL, Reporting, OLAP and BI tools; expertise in constructing data architectures, data marts and data stores.
Ability to exercise discretion and good judgement in decision making and handle confidential and sensitive data.
Strong knowledge of logical and physical data modeling concepts, hands-on development of attributes, facts, dimensions, transformations,
Strong analytical abilities and interpersonal skills
Translate business requirements into specifications required to drive data store/data warehouse/ data mart design and configuration.
Ability to work independently and within a team environment, while also managing multiple priorities.
Knowledge of software development life cycle and agile methodologies is 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, religion, sex, color, national origin, ethnicity, age, genetic information, disability or sexual orientation. 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.