Business Intelligence Architect

Job Description
Available Openings: 1
Job Title: Project Architect - Business Intelligence - Data
Job ID: 83768

Location: DePere, WI

Business Unit: Auto Home
Full/Part Time: Full-Time
Eligible for Relocation: N
Regular/Temporary: Regular
Travel Percentage: None
License:

About Ameriprise

You're ambitious and confident, ready for a challenge and looking for the right opportunity. You want a career with a company that enables you to achieve your highest potential while rewarding you for your efforts. Ameriprise Auto Home Insurance is a division of Ameriprise Financial, a FORTUNE 500 ® company⊃1;, and one of the fastest growing insurance companies in the country.

We provide automobile, homeowners and umbrella insurance products, generating more than $600 million in annual premiums. If you're driven to succeed and prepared to meet the ever-changing needs in our industry, you're ready for a career at Ameriprise Auto Home Insurance. You'll advance your career with a company committed to being the most respected personal insurance company in the country.

Ameriprise Auto Home is an equal opportunity employer.

⊃1; FORTUNE Magazine, May 4, 2009.
© 2009 Ameriprise Financial, Inc. All rights reserved.

Responsibilities
Ameriprise Auto Home Insurance currently has an opening for a project architect specializing in the technology and architecture for the Business Intelligence (BI) and Data Warehousing space. The ideal candidate would have been directly accountable for the successful definition and implementation of enterprise-wide strategy, direction, and design on projects related to data architecture, data modeling, and data analysis. Experience in business intelligence tools (e.g. Cognos, SSAS, or Oracle) along with experience in OLAP architecture design, data mart design, and ETL processes and process modeling is expected.

The BI Project Architect position will be responsible for the following:

· Leveraging new and existing technologies to translate vision into detailed designs

· Identifying key business and technology drivers that impact data or application architectures, such as user requirements, existing application environment and performance requirements.

· Conducting both functional and technical assessments of current business and technology architectures especially in the data management space.

· Providing guidance to project teams regarding principles of data management, design, and modeling along with system/application design, coding, standards and system performance

· Developing and communicating best practices in software development especially in BI space

· Evaluating, selecting and implementing development tools

Qualifications
· Bachelor's Degree in Information Systems or a related field

· 10+ years overall Business Intelligence experience

· 8 years of Data Architecture experience with at least 3 years of Data Modeling and Analysis experience

· Experience in all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing, documentation, and training other team members.

· Experience in at least one of the following (Cognos/SSAS/SSRS/Oracle/Business Objects)

· Experience in at least one of the following (Informatica/Datastage/SSIS/Oracle Warehouse/Ab Initio)

· Strong background in constructing and deploying system solutions following best practices and standards

· Excellent communication skills including the ability to effectively present complex technical topics to large teams

JCODE

JCODE:23914

JCODE

JCODE:23912