Job Description
JOB SUMMARY
Responsible for building and maintaining internal Enterprise Analytics solutions which include but is not limited to database design/modeling, database creation, performance optimization, data loads, reporting and dashboards. Provide senior level technical expertise in overseeing the design, implementation and maintenance of the data architecture function as well as serve as the in-house expert that leads and promotes innovative data designs and data quality improvements.
DUTIES & RESPONSIBILITIES
- Lead and support the analytical content for data related to onboard systems which includes (Fleet) HR data, Hotel/Property Management data, Point of Sale data and Dining System data amongst others.
- Lead and provide technical guidance for design and implementation of data storage and governance systems.
- Design and develop highly visual, interactive, and layered Enterprise Analytics solutions using Tableau, Business Objects (utilizing Information Design Tool, Web Intelligence, & Crystal Reports).
- Triage requests, gather user requirements, and ultimately facilitate ad hoc report/data requests with a quick turn-around time and/or develop production reports originating from the Data Warehouse (Snowflake) to be used by the business for ongoing analytical and operational needs.
- Responsible for the construction of basic to advanced SQL (Oracle / SQL Server) and basic PLSQL that provide the necessary data to support the business and feed our Enterprise Analytics platforms.
- Responsible for data preparation, data blending, the creation of data models /sets.
- Provide application support to internal users of the Enterprise Analytics applications including fleet and shore-side departments.
- Define and document processes, best practices, and strategies for existing and future Enterprise Analytics solutions, optimizing business efficiencies as it relates to process improvement.
- Responsible for the education of users on available Enterprise Analytics platform.
- Design test plans, including definition of test cases and the creation of detailed solution test scripts. Work with other teams and vendors to explore methods for automation of testing. Audit and analyze application data, when requested by management.
- Act as a liaison between business users, management and application system IT support.
- Maintain documentation of database workflows, requirements, policies, and procedures as they relate to Enterprise Analytics reporting.
- Prepare, assist, and conduct presentations to management and team members related to analytical findings across various areas of the business that will be utilizing the data.
- Support the creation, implementation, communication and ongoing support of data standards and processes to ensure standardized data naming, establishing consistent data definitions and monitoring overall data quality.
- Assist business and IT areas in developing relevant exception reporting and addressing existing exceptions reports to ensure that mistakes, inaccuracies and discrepancies are highlighted, addressed and ultimately resolved.
- Interface with Data Warehouse and Architectural staff to provide data requirements to support ongoing Enterprise Analytics initiative.
- Perform other job-related functions as assigned.
QUALIFICATIONS
DEGREE TYPE: Bachelor's Degree
FIELD(S) OF STUDY: Computer Engineer Science, Statistics, Industry Engineering, Business Administration or related field of study; or any equivalent combination of experience and training.
EXPERIENCE
Minimum 4 years' experience in Information Technology, Enterprise Analytics and Database, developing data visualizations, end user reports and performing data analysis, using Enterprise Analytics platforms including Tableau, Business Objects (Information Design Tool, Web Intelligence & Crystal Reports).
COMPETENCIES/SKILLS
- Strong ability to use SQL for analyzing data. In-depth Knowledge of Software Development Lifecycle and methodologies.
- Project management and data warehouse technologies experience, preferred.
- Strong background developing data visualizations, end user reports and performing data analysis.
- Strong understanding of design strategies around information display.
- End to end knowledge of Enterprise Analytics and data warehousing architectures.
- Fundamental understanding of data management systems and processes within the ecosystem (source systems, data feeds, reference data management, ETL, Data Warehouses and Marts, data cube design, etc.).
- Strong RDBMS background, have excellent SQL skills.
- Excellent analytical skills and organizational skills to gather and document business requirements.
- Strong verbal and written communication skills to thoroughly prepare specifications, make recommendations and effectively work with internal and external members.
- Self-motivated, quality-oriented, and delivery-oriented.
Job Tags