Sr. Data Warehouse Engineer

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.

Qualifications:

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

Work Experience:

• 5+ years As 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, Tabl