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

Associate Data Warehouse Developer in Lincoln, RI at Amica

Date Posted: 6/18/2019

Job Snapshot

Job Description

Associate Data Warehouse Developer
25 Amica Way, Lincoln, RI 02865

Want to turn your IT expertise into customer solutions?
The feeling is mutual.

Develop and implement data extraction and integration procedures from insurance systems such as Policy Administration, Claims, Billing or HR to support data warehouse and analytics solutions
Assist in developing and maintaining the integrity of the Enterprise Data Warehouse.
Develop scalable and comprehensive enterprise analytics solutions including extraction of data from multiple sources, transforming data according to business rules and loading data into operational and presentation models.
Design, implement and support data warehouse and data mart structures.
Verify the structure, accuracy and quality of warehouse data.
Map data between source systems, data warehouse repositories and data marts
Support daily operations, monitor performance, debug issues and fine-tune data processes to optimize performance
Support continuous improvement efforts to enhance performance and provide increased analytics and business intelligence capabilities.

Bachelor's degree and a minimum of 4 years’ experience in Data Analytics, Data Warehouse, and Data Modeling with experience in supporting scalable and comprehensive enterprise data solutions or an equivalent combination of education and experience sufficient to successfully perform the essential functions of the job.
Experience in data migration, modernization, or Data Warehousing projects
Strong SQL knowledge working with complex queries and stored procedures
Experience with relational databases such as DB2, Teradata, and SQL Server. As well as NoSQL databases, such as MongoDB.
Experience with ETL data integration tools; expertise in constructing data architectures, data marts and data stores.
Understanding of relational/dimensional data structures and Big Data concepts
Understanding of SAS, MicroStrategy or equivalent reporting toolset.
Ability to exercise discretion and good judgement in decision-making and handle confidential and sensitive data.
Knowledge of logical and physical data modeling concepts, hands-on development of attributes, facts, dimensions, transformations,
Strong interpersonal skills to communicate with product owners and translate business requirements into specifications required to develop 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.
Experience with Teradata concepts and architecture. Knowledge of BTEQ 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.

ind 15