Skip to main content

Sr. Data Warehouse Engineer

Job ID 8281 Location Miami Date posted 05/29/2024

Company Overview

At Carnival Cruise Line, our mission is to create safe, fun, and memorable vacations at a great value. As a valued member of our team, you'll actively contribute to developing exceptional travel experiences and unforgettable moments, every single day. Your Carnival journey begins here!

Our Culture Essentials

Joining the Carnival team means embracing our six Culture Essentials, which are the cornerstone values shaping our identity, principles, and actions. These beliefs and behaviors not only define who we are but also unite us as a team, guiding us in decision-making, fostering relationships, tackling challenges, and reaching milestones. These culture essentials propel us toward a shared vision of success, ensuring a collective effort in shaping our future.

  • Speak Up
  • Respect & Protect
  • Empower
  • Improve
  • Listen & Learn
  • Communicate


Job ID 8281 Location Miami, FL Date posted 05/29/2024

Job Description

The Senior Data Warehouse Engineer is responsible for the analysis, design, development, documentation, and maintenance of the CCL Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts, CRM/Guest Loyalty Management system, Data integrations, Data Security, and Business owned reporting and analytic solutions.   These tasks will be carried out with minimal guidance and supervision from the Data Warehouse Supervisor or the Senior Data Warehouse Architect.

Job Functions:

  • Design, develop, and document complex code integrating warehouse and transactional business applications using current knowledge of enterprise application technologies and development techniques.
  • Design, develop, and test dimensional data model extensions using Star & Snowflake schema methodologies under the Kimball and Inmon methodologies
  • Lead troubleshooting and debugging of software integration and performance problems. Conduct performance analysis and suggest potential solutions for highly complex integrations and reporting needs
  • Partner with the business teams in defining the end state reporting goals and/or dashboard requirements. Design and develop data-based solutions that meet either a 'publish or 'subscribe' data requirement.
  • Construct and maintain the necessary support Run Book, scheduling, and Embarcadero data model documentation and artifacts in accordance with Carnival’s System Development Methodology (SDM).
  • Assist in developing and then meet agreed-upon deadlines and perform other project duties as assigned.
  • Communicate technical and non-technical information clearly, concisely, and effectively both orally and in writing. Present findings, recommendations, and specifications in formal reports and/or oral presentations.

Required for all Jobs:

  • Performs other duties as assigned.
  • Complies with all policies and standards.


  • Education:  bachelor’s degree in computer science, Engineering or a similar technical discipline required.  Master’s degree preferred.

Work Experience:

  • 5+ yearsAs an Engineer or comparable experience in Data Warehousing, Informatica products and Oracle databases.  Primarily on-premise with some Cloud experience a plus required.
  • Experience in analysis, design, construction, documentation, and the support of very high-volume/performance data warehouse integrations using the following set of technologies (Oracle, Informatica, UNIX) required.
  • Experience in Waterfall and Agile development disciplines required.
  • Cross functional work experience with teams comprised of business, IT applications, 3rd parties, and vendors required.
  • Experience in designing and developing for Privacy/PI, EUGDPR, CCPA, Data Retention, and Data Privacy, Protection and Data Governance requirements required.
  • 10+ years of overall experience working with Data Warehousing, Informatica products, and Oracle databases. Primarily On-Premise with some Cloud experience a Plus preferred
  • Experience and/or Training in Informatica Intelligent Data Management Cloud (IIDM) and on-premise to cloud conversion is a strong plus preferred.
  • Experience in handling/analyzing customer related data (CRM) and understanding of casino player related data is a plus preferred.

Knowledge, Skills & Abilities:

  • Knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and Microsoft PowerBI
  • Expert understanding of PL/SQL developer, functions, procedures, packages, and triggers.
  • Knowledge of Informatica Dynamic Data Masking (DDM), Data Privacy Manager (DPM), Data Archive (IDA), Enterprise Data Catalogue (IDA), and Data Governance (IDG), Intelligent Data Management Cloud (IDMC). 
  • Expert experience with Informatica Power Center version 9.x. including Workflow Manager, Workflow Monitor, Repository Manager, Designer, Server Manager, Power Exchange and ETL. 
  • Expert understanding of the concept of code objects re-use and business rules standardization
  • Expert understanding of SQL Navigator and/or Toad. Recent experience developing on Oracle 19c or higher.
  • Prior Cruise Line, Casino or Retail related business experience. 
  • Strong verbal and written communication and skills. 
  • Able to meet aggressive project timelines and to escalate appropriately when issues are encountered.
  • Able to provide technical leadership and mentoring to junior and intermediate level data warehouse staff. 
  • Performance Management and Data Privacy and Protection knowledge a plus.
  • Knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and Microsoft technologies

Licenses & Certifications:

Informatica and Oracle are a Plus but not required but preferred.

Physical Demands:  Must be able to remain in a stationary position at a desk and/or computer for extended periods of time. 

Travel:  No travel.

Work Conditions:  Work primarily in a climate-controlled environment with minimal safety/health hazard potential. 

The range for this role’s salary $83,182-$130,000.  Offers to the selected candidates will be made on a fair and equitable basis, taking into account specific job-related skills and experience. 

At Carnival, your total rewards package is much more than your base salary. All non-sales roles participate in an annual cash bonus program, while sales roles have an incentive plan. Director and above roles may also be eligible to participate in Carnival’s discretionary equity incentive plan. Plus, Carnival provides comprehensive and innovative benefits to meet your needs, including:

  • Health Benefits: 
    • Cost-effective medical, dental and vision plans
    • Employee Assistance Program and other mental health resources
    • Additional programs include company paid term life insurance and disability coverage
  • Financial Benefits: 
    • 401(k) plan that includes a company match
    • Employee Stock Purchase plan
  • Paid Time Off 
    • Holidays – All full-time and part-time with benefits employees receive days off for 7 company-wide holidays, plus an additional floating holiday to be taken at the employee’s discretion.
    • Vacation Time – All full-time employees at the manager and below level start with 14 days/year; director and above level start with 19 days/year.  Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 84 hours/year.  All employees gain additional vacation time with further tenure.
    • Sick Time – All full-time employees receive 80 hours of sick time each year.  Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 60 hours each year. 
  • Other Benefits 
    • Complementary stand-by cruises, employee discounts on confirmed cruises, plus special rates for family and friends
    • Personal and professional learning and development resources including tuition reimbursement
    • On-site preschool program, wellness center, and health clinic at our Miami campus



About Us

In addition to other duties/functions, this position requires full commitment and support for promoting ethical and compliant culture. More specifically, this position requires integrity, honesty, and respectful treatment of others, as well as a willingness to speak up when they see misconduct or have concerns.

Carnival Cruise Line is the most popular cruise brand in North America and operates a fleet of ships designed to foster exceptionally safe, fun and memorable vacation experiences at an outstanding value. Our employees have a responsibility to be accountable for all actions. We consider the environment in all aspects of our business and have a responsibility to put safety and sustainability first. We live and share a positive attitude which is based on fostering an environment of inclusion, trust, a willingness to listen, openness and integrity. Doing this helps us to achieve our ultimate goal, which is to include FUN in everything we do! Speaking of fun, we are officially certified as a Great Place to Work aboard our ships as well as in our global corporate headquarters!

Carnival Corporation & plc and Carnival Cruise Line is an equal employment opportunity/affirmative action employer. In this regard, it does not discriminate against any qualified individual on the basis of sex, race, color, national origin, religion, sexual orientation, age, marital status, mental, physical orsensory disability, or any other classification protected by applicable local, state, federal, and/or international law. 

Employee Benefits

  • Hybrid Work Environment

    Empowering work-life integration and flexible opportunities for your personal and career success

  • Wellness Programs

    Comprehensive employer wellness programs featuring mental health support and fitness options, including an on-site gym

  • Cruise Benefits

    An array of qualified complimentary and heavily discounted cruise options for the ultimate dream getaway

  • Parental Programs

    Generous parental leave time and adoption assistance programs

  • Retirement Plan

    Secure your future with our exceptional Traditional and Roth 401(k) options complemented by valuable company contributions

  • Employee Stock Purchase

    Invest in tomorrow with the opportunity to purchase Carnival shares at a discounted rate from their fair market value

In addition to the above, we offer PTO and company holidays as well as a variety of medical, dental, and voluntary plans


In our virtual contact center, we're all about unlimited growth opportunities and creating a supportive, inclusive environment. We believe in fostering professional development and providing our team members with the tools and resources they need to excel in their roles. Our community values diversity, ensuring that everyone feels respected and supported in a welcoming atmosphere where personal and professional growth knows no limits. Above all, we're committed to delivering an exceptional guest experience, making customer satisfaction a top priority in everything we do.

I love the variety in my work at Carnival. Each day brings new challenges that require creative thinking. Collaborating with different team members on projects keeps things fresh and interesting, making every day unique and exciting. Moreover, being part of Carnival means being part of a culture that values initiative and fosters continuous improvement. This sense of empowerment fuels my passion for what I do and inspires me to strive for excellence every day.

Miguel Fleet Technical Document Center Manager Summit Seeker

Carnival is a great place to learn and grow.

Tyrone Lost Mail Clerk Chess Master

Carnival’s culture is fun, welcoming, vibrant, flexible, fast-paced, diverse, and innovative. Carnival welcomes guests from all over the world to sail on our ships. Our crew members are caring and make the guest experience awesome. The fun continues to connect shoreside where I have an opportunity to interact with employees from all levels of the organization to assist them with their HR questions. From the guest to shoreside experience, we embrace the FUN!

Annelys HR Services and Shoreside Immigration Supervisor Fitness Guru

Carnival has been instrumental in my personal growth by providing opportunities to step out of my comfort zone and develop essential skills like flexibility and teamwork. Professionally, their commitment to continuous learning and career development has empowered me to take on new challenges and advance in my field.

Conchita Senior Revenue Business Analyst
Culinary Explorer
Restaurant Explorer

Be The First To Know

Get the latest job openings right in your inbox.

Customize your alertsSelect a job category from the list of options. Finally, click "Add" to create your job alert.

  • Information Systems, Miami, Florida, United StatesRemove

By uploading your resume you are not submitting an application for employment.

By submitting your information, you acknowledge that you have read our privacy policy (opens in new window) and consent to receive email communication from CARNIVAL CRUISE LINE.