Senior Analyst, Data Modeling Royal Caribbean Group - 4.2 Miramar, FL Job Details Full-time 22 hours ago Qualifications Hyperion Commercial use (data warehousing systems) Cloud analytics services Data visualization software proficiency Data Integration (Data management) Business intelligence report generation Schema design SQL Data Architecture Design (Architecture design skills) Cloud database architecture Metadata Query management Entity-relationship diagrams OBIEE Metadata management Data analysis software Dimensional modeling Full Job Description Journey with us! Combine your career goals and sense of adventure by joining our exciting team of employees Royal Caribbean Group is pleased to offer a competitive compensation and benefits package and excellent career development opportunities each offering unique ways to explore the world We are proud to be the vacation-industry leader with global brands — including Royal Caribbean International Celebrity Cruises and Silversea Cruises — the most innovative fleet and private destinations and the best people Together we are dedicated to turning the vacation of a lifetime into a lifetime of vacations for our guests The Royal Caribbean Group's Analytics Team has an exciting career opportunity for a full-time Senior Analyst Data Modeling reporting to the Senior Manager Data Solutions Engineering This position is onsite and based in Miramar Florida This position is also not eligible for work authorization sponsorship

Position Summary:

The Senior Analyst Data Modeling is responsible for both the theory and practice of making RCG a data-driven organization In this role the Senior Data Analyst/Modeler will design develop and manage data solutions for use by internal stakeholders in all areas of RCG including Product Management Revenue Sales Marketing Digital to name a few Working closely with Data Solutions Engineering he or she will architect data definitions and structure and oversee the ETLs that populate them in order to deliver meaningful high-quality data to downstream users and platforms including data scientists business and product analysts reporting platforms and automated processes Strong experience in requirements engineering and the design development and deployment of ETL and Data Modeling A broad set of skills and knowledge including software systems and solution development spanning multiple technical domains Strong communication skills including the ability to socialize influence and gain support for proposed technology and solution architectures from the business and IT community Technical team leadership mentorship and collaboration as well as the ability to cultivate strong working relationships with end-users peers and vendors

Essential Duties and Responsibilities:

Key areas of responsibility in descending order with the responsibility requiring the most amount of time first Gather and translate requirements — work directly with business stakeholders to understand what they're trying to decide and turn that into clear data and reporting requirements Design logical and conceptual data models — define entities relationships grain and business rules ahead of physical implementation Analyze and interpret data to be modelled into the enterprise data platform Define and enforce standards for the data platform Maintain the semantic layer — define certified metrics and dimensions so the same term means the same thing everywhere it's used Deliver analysis and insight — run the ad hoc analysis cohort/trend work and investigative queries that answer specific business questions Partner with Data Engineering — hand off logical models with clear documentation and collaborate on how they get physically implemented and tested work with Data Engineers on the boundary between raw ingestion and modeled data and flag upstream data issues early Define requirements for engineers developing new data pipelines database infrastructure and instrumentation Communicate findings — present analysis and recommendations to non-technical stakeholders in a way that drives decisions not just describes data Partner with stakeholders — work with product managers business partners and analysts to understand business rules to understand what the model needs to support not just what it needs to store Draw on deep experience with data management and analysis to identify improvements and increase efficiency reliability and usability of data across the organization Define and document the underlying metrics and design robust infrastructure (ETLs table structures metadata) to enable consistent reporting on those metrics throughout the organization

Qualifications:

5+ years of experience with data in a cross-functional role (analytics business intelligence data science data warehousing product management) Bachelor's degree or similar work experience in a technical discipline (information science mathematics computer science econometrics etc ) Expert-level skills in SQL (preferably in more than one dialect) ideally with exposure to both SQL and NoSQL databases Strong analytical skills with the ability to collect organize analyze and disseminate significant amounts of information with attention to detail and accuracy Expertise in data modelling concepts database design building or maintaining a semantic/metrics layer that feeds BI tools Experience with a modern cloud data warehouse or lakehouse (eg Databricks Snowflake BigQuery Redshift) Proven ability to overcome the challenges of processing large structured datasets (tens of billions of rows) Well-versed in the tradeoffs of different data storage approaches (row-oriented vs columnar relational vs non-relational structured vs unstructured) Exposure to big data and real-time event data streaming Setting and ensuring data platform standards for the management governance and usage of data

Knowledge and Skills:

Specific knowledge and skills necessary to perform this job related to the Essential Duties and Responsibilities identified above Technical capabilities in: Erwin or similar Oracle SQL Server Synapse Couchbase (cloud and on-prem) DW modeling Expert SQL ETL concepts (working knowledge of Informatica Cloud Informatica PowerCenter ADF and/or Talend) Reporting tools (Microsoft Power BI Hyperion Oracle OBIEE Tableau) Data governance (knowledge collecting keeping cataloging and using data efficiently)

Agency and Third-Party Submissions:

Please note this is a direct search by the Company and applications through agencies and other third parties will not be accepted nor will fees be paid for unsolicited resumes Any unsolicited resumes will be considered the Company's property We know there's a lot to consider As you go through the application process our recruiters will be glad to provide guidance and more relevant details to answer any additional questions Thank you again for your interest in Royal Caribbean Group We'll hope to see you onboard soon! It is the policy of the Company to ensure equal employment and promotion opportunity to qualified candidates without discrimination or harassment on the basis of race color religion sex age national origin disability sexual orientation sexuality gender identity or expression marital status or any other characteristic protected by law Royal Caribbean Group and each of its subsidiaries prohibit and will not tolerate discrimination or harassment #LI-SS1

Nearest Major Market:

Miami