Skip navigation
Unable to save this job. Please try again later.


Email this Job to Yourself or a Friend

To begin the application process, please enter your email address.

Company Contact Info

  • Lincoln, RI

Already have an account?

Sign in to apply with your saved resumes.

New to CareerBuilder?

Don't have an account? Continue as a guest!

Sorry, we cannot save or unsave this job right now.

Report this Job

Trust and Site Security Team.

Don't miss out on new jobs!

Get the latest Enterprise Data Warehouse Architect jobs in Lincoln, RI delivered directly to your inbox. You can unsubscribe at any time.

Saving Your Job Alert

Job Alert Saved!

Could not save Job Alert!

You have too many Job Alerts!

This email address has reached the maximum of 5 email alerts. To create a new alert, you will need to log into your email and unsubscribe from at least one.

Sign Up

or   Sign In Here
Password Must Contain
8 to 15 characters
1 uppercase letter
1 number or symbol
1 lowercase letter
Create an Account with CareerBuilder to save jobs & unlock these great features
See similar job titles and skills to help you make your next move
Upload a resume and become visible to Hiring Managers and Employers
Compare Salary Information to see where you stand amongst your peers
Easily Quick Apply to jobs with just one click!

Email Send Failed!

Enterprise Data Warehouse Architect

Amica Insurance • Lincoln, RI

Posted 8 days ago

Job Snapshot

Degree - 4 Year Degree
Information Technology

Job Competition



How Do You Compare to the Competition?

Get facts about other applicants with a CareerBuilder Account

Job Description

Location: Lincoln, RI (Corporate Information Systems)

Are you looking for a job in a growing industry with new products, new markets and new technology?

Our office located in Lincoln, RI is seeking an Enterprise Data Warehouse Architect. This position will partner with business and Data and Analytics leadership to prioritize data and information requirements that will help shape the strategic direction of the data warehouse, and analytics and reporting efforts.

Job Functions and Responsibilities:
• Responsible for assisting in building and maturing the Enterprise Data Warehouse (EDW) strategy and roadmap. This position will be responsible for architecting and guiding the execution of the enterprise data strategy.
• Responsible for architecting and developing 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.
• Responsible for 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.
• Responsible for leading continuous improvement efforts to enhance performance and provide increased analytics and business intelligence capabilities.
• Responsible for researching industry trends related to enterprise data and incorporating best practices into the roadmap and solutions.
• Responsible for establishing current and long-range direction of technologies needed to support analytics and reporting solutions to remain current with product and technical capabilities.
• Works closely and collaborates with Amica’s external partners to provide direction and oversite of all analytics and Big Data solutions.
• Conducts research and makes recommendations on emerging technologies to support the company’s analytics goals.

Job Requirements:
• Seeking an individual with a 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.
• Candidate should have experience with Teradata concepts and architecture
• Candidate should have 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,
• Have strong analytical abilities and interpersonal skills needed to effectively gather and identify requirements. 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.

Benefits Include:
• 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

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.

Job ID: 19-0257
Help us improve CareerBuilder by providing feedback about this job: Report this Job.
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.
By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.
Don't miss out on new jobs like this
Get the latest jobs delivered to your inbox. Unsubscribe at any time.

Saving Your Job Alert

Job Alert Created

Well, this is embarrassing. We are having trouble saving your search. You can try again or come back at a later time.

Maximum Email Alerts

This email address has reached the maximum of 5 email alerts. To create a new alert, you will need to log into your email and unsubscribe from at least one.