Data Warehouse Analyst II - New York, United States - HYATT Hotels
Description
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.
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.
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
Bachelor's 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
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 contractor's legal duty to furnish information.
41 CFR 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.
#J-18808-Ljbffr