Data Warehouse Analyst Ii

Job Description

The Data Warehouse Analyst II (DW Analyst) plays a critical role in developing and maintaining a Data Warehouse for Genting Americas to deliver strategic business decisions across all levels of the organization.

DW Analyst will report to Director Planning and Analysis, and oversee the evolution of the current Data Warehouse, which is a comprehensive data repository for all relevant KPIs to include financial and statistical data. The individual must be proficient in database engineering and have expertise in

interacting with a Data Warehouse using SQL language. DW Analyst will bring the necessary skills to the team with respect to structuring the warehouse using best data science practices that result in an efficient and scalable structure. In working with an application specialist, he/she will be responsible for the design and validation of all Data Warehouse feeds governed by automated or manual procedures. The ideal

candidate will create a work environment that supports our core values, and promotes integrity, teamwork, performance, recognition, mutual respect, and employee satisfaction.

Essential Duties

• Develops processes for the extraction, transformation, and loading of data from source systems to the Data Warehouse.
• Ensures that the Data Warehouse properly supports the functionality of Anaplan - our BI
• Builds, manages and maintains Power-Automate
• Carries sufficient knowledge of the Anaplan import process and can evolve the data ingestion with the evolution of Anaplan.
• Ensures a high level of accuracy by validating the newly ingested data in
• Takes the lead on data management, data quality, and
• Is responsible for data mapping and data
• Assist P&A in setting up departmental and property reports, analyses, and
• Provide technical input when necessary in the implementation of new BI software to ensure maximum compatibility of any new software with the existing apparatus
• Conduct audits and follow-up on completed projects to verify sustained impact
• Adapt quickly and effectively to procedural changes and assist with other special projects
• Perform other duties as Job Requirements

Physical and Mental

Ability to sit for extended periods of time as necessary to complete job assignments and job duties.

Ability to work on a PC. The individual may occasionally be asked to work a flexible schedule to include nights and weekends. Ability to lift 10 lbs. Required to understand and communicate and follow directions both verbally and in written English.

Work/Educational Experience

• Must be at least 18 years old, possess a high school or equivalent diploma and have the ability to obtain the appropriate license pursuant to the New York State Lottery regulations
• Bachelors Degree in Information Systems (IS), or related field
• Master of Science or equivalent degree preferred with financial and quantitative orientation preferred
• Two (2+) years work experience with large scale relational databases, Data Warehouses or similar
• Certified Model Builder Level 1 in Anaplan highly preferred
• Intermediate to advanced knowledge in setting up a SQL based relational databases that reflect best practices with respect to scalability, compatibility, and comprehensiveness
• Experience with gaming and hospitality industry systems (IGT/Konami, Agilysis, OnQ/ Opera, RedRock/Stratton Warren, SAP, Ultimate/Kronos etc.)
• Working knowledge with Microsoft SQL Server Suite (SSMS/SSIS/SSAS/SSRS) and business intelligence reporting software (Tableau/Power BI/IBM Cognos Analytics etc.)
• BPI Certification (Lean and/or Six Sigma), or experience with Kaizen
• Previous experience with project management and continuous improvement
• Intermediate to advanced knowledge of Power Automate or similar automation platforms
• Working knowledge of Microsoft Office
• Ability to work varied shifts, including nights, weekends and holidays
• Ability to effectively communicate in English
• Polished appearance and demeanor
• Excellent customer service skills
• Working knowledge of gaming regulations
• Previous experience working in a large, luxury resort setting preferred

Salary: $84,500 - $85,000

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c)

This position is at a location where Hyatt is not the employer. The employer of individuals working at this hotel may be a third-party management company that is responsible for all employment benefits and obligations at this location.