Holland America Line Data Architect in SEATTLE, Washington

Data Architect

Santa Clarita, CA or Seattle, WA

The Holland America Group is currently searching for a highly motivated Data Architect who will design, build, and map dimensional data models in the HA Group next generation enterprise data warehouse as well as raw or lightly modeled data in Amazon Redshift/S3 as well as recommend and guide the best use of Amazon Web Services technologies to achieve the most efficient, scalable and responsive solutions to absorb and deliver new data sources blended with legacy data in a hybrid AWS/Oracle ecosystem.

We welcome your interest in joining the Holland America Group - a division of Carnival Corp. The Holland America Group includes Holland America Line and Seabourn (both headquartered in Seattle, Washington), Princess Cruise Lines (headquartered in Santa Clarita, California), and P&O Australia (headquartered in Sydney). The Holland America Group operates a combined total of 41 cruise ships with over 36,000 employees worldwide. This position will be located in our Santa Clarita, CA offices.

Responsibilities

  • Work closely with business users, Architecture, ETL, and Reporting teams to define, document, and deliver modeled subject areas within the Oracle data warehouse.

  • Create source to target mapping specifications for handoff to both local and offshore ETL developers.

  • Help establish, maintain, and improve standards, procedures, and best practices for data storage and movement into and out of Redshift/S3/Snowflake.

  • Leverage AWS and compatible tools/services for rapid prototyping and delivery of new data sets.

Requirements

  • Bachelor's Degree in Computer Science or equivalent experience and five or more years of on the job experience using relevant technology and software.

  • Expert SQL coder.

  • Experience with other scripted languages such as PL/SQL and Python are a plus.

  • Ability to accurately estimate work, manage project scope, and identify and communicate issues early to meet deadlines.

  • Strong knowledge and experience implementing dimensional data models using the Kimball design approach.

  • Strong knowledge and experience using Oracle Database Technologies (12c).

  • Strong knowledge and experience using AWS tools and technologies in Redshift/S3/Snowflake.

  • Excellent meeting facilitation, organizational and communication skills.

  • Ability to interact well with all levels with the organization.

  • Excellent problem solving/analytical skills with a high level of accuracy.

  • Ability to work flexible hours as needed to complete projects.

Benefits

  • Time off benefits - 8 paid holidays, paid vacation, bonus vacation time and paid sick time

  • Travel - Cruise and Travel Privileges for you and your family

  • Health - Complete benefit plans including medical, dental, vision and flexible spending accounts

  • Wellness - Health and wellness programs include onsite exercise classes, onsite nutrition and lifestyle classes and discounted gym memberships

  • Tuition Reimbursement - up to 75% with a maximum of $2000 per year

  • 401(k) - Company match up to 6% of salary at 50% for the first 5 years and 100% thereafter

  • Employee Stock Purchase Plan - up to a 15% discount off of FMV of CCL stock

  • Training - In-house Princess University courses on professional development

  • Rewards & Incentives - Employee Recognition and Reward Programs; rideshare, financial commuter incentives and free parking; special employee discounts for banking services and retail stores

Next Steps…

Apply today and set sail on an exciting new career course! Our goal is to be the number one cruise and cruise-tour provider. To make that happen, we need qualified, top-notch team members. If you’re looking to get your talent noticed, apply today! Our application process is quick and easy:

Apply online at http://princess.com/careers . Enter the job title into the keyword search to access the job. If you are already on the Princess Cruises website be sure to create a profile and then apply directly to your specific job.

Princess Cruises is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, disability or protected veteran status.

*LI-CW1