Responsibilities:• Build and maintained weekly and monthly reports for the business owner to monitor business performance • Gather report requirement, perform data analyzing, modelling and visualizing in SQL, Excel and Power BI for business owner with information from various sources such as Auckland Prison Director Dashboard, Overtime Shift dashboard and Good to Grow Dashboard• Streamlined reporting process through developing complex SQL and using of Macro to increase efficiency such as This Way for Work dashboard• Support internal and OIA data request.• Build Tabular Model for Auckland Prison Director Dashboard

Responsibilities:• Generate weekly or monthly reports for the management team, Network & scheduling department, Finance department, Revenue department, Sales department and Marketing department• Automate and Schedule routine reports• Generate ad-hoc reports such as passenger demography reports, sales agent performance reports, sales reports during promotion period• Create new and modify existing reports upon request• Manage and monitor company intranet and CRM system• Prepare company intranet and CRM system user guide• Raise ticket to vendor on issues found in company intranet and CRM system• Liaise with user and vendor on any necessary enhancement to current company intranet and CRM system• Installation and updating of digital survey devices

Responsibilities:• Develop reports, dashboard and business intelligence maintenance page• Perform ETL to extract and merge data needed in reporting• Perform unit testing of reports, user maintenance page and ETL jobs• Write program specification documentation• Fixing bugs and errors found during development and Quality Assurance testing• Perform system installation for presentation/demonstration, and Quality Assurance testing• Support user acceptance testing