Enterprise Analytics Developer ( Airline )

About the job

BASIC PURPOSE : Responsible for building and maintaining the internal Enterprise Analytics Onboard Revenue solutions which includes 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 serves as the in-house expert that leads and promotes innovative data designs and data quality improvements.

POSITION RESPONSIBILITIES :

• Manage and support the analytical content for Onboard Revenue (OBR) Operations, which includes Shore Excursions and Land Programs, Retail Shops, Spa, Communications, Art, Photo, Bingo, Port Shopping, Weddings, and Food and Beverage.
• 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 (Explorer, Information Design Tool (IDT), Web Intelligence, Crystal Reports, Analysis for OLAP and Dashboards).
• 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 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 using applications such as Alteryx.
• 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 Onboard Revenue and Costs.
• 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.

KNOWLEDGE AND EXPERIENCE :

EDUCATION : MBA, MIS or Bachelor's Degree in 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 (Explorer, Information Design Tool (IDT), Web Intelligence, Crystal Reports, Analysis for OLAP and Dashboards).

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.

KNOWLEDGE & SKILLS : 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. Have a 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.

Excellent analytical, logical and problem-solving skills. Self-motivated, quality-oriented, delivery-oriented, and able to self-prioritize work.

Ability to thrive in a fast-paced and changing environment.

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide.

As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants.

Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit

https : / / dexian.com /

to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.