About CTM Corporate Travel Management (CTM) is a global leader in business travel management services. We drive savings, efficiency, safety and sustainability to businesses and their travellers in every corner of the world. Its proven business strategy combines personalised service excellence with client-facing technology solutions to deliver a return on investment to clients. CTM was founded in 1994 in Brisbane, and today is one of the largest travel management companies in the world!
About the role The BI Developer role sits within the Planning & Reporting Team – in the ANZ Finance department. This role will support the Head of Financial Planning & Analysis and will consist of day-to-day and Ad-Hoc support requests from key department managers, drive business improvement through the identification, recommendation and implementation of value adding initiatives & analysis, development and improvement of internal reporting to meet business requirements, and contributing to continuous business process improvements.
Key Requirements
Advanced SQL and PowerQuery
Advanced PowerBI and DAX
Knowledge of best practice management of large data models
Experience building and editing tables in SQL databases
Experience setting up and managing Row Level Security for large multi-level organisations
Preferred/Desirable
Experience with migrating large data models between platforms (noting we have a planned move from PowerBI to Azure)
Travel industry experience
Skills
Advanced SQL, PowerQuery, Power BI and DAX
Understanding of best practice management of large data models
Experience building and editing tables in SQL databases
Experience setting up and managing Row Level Security for large multi-level organisations
Proficient in Microsoft Products including advanced Excel skills
Ability to think through and solve complex problems
Demonstrated capacity to consistently deliver a high level of customer service and develop and maintain ongoing relationships with customers and colleagues
Effective communication skills. Demonstrated effective written and interpersonal communication skills. Able to communicate at all levels within the business
Able to manage a high-volume workload to meet reporting deadlines
Good time management and organisational skills and the ability to meet strict deadlines and prioritise own work
Self-starter. You are highly motivated and dedicated to delivering the optimum outcome for your customers and the business
Thorough, accurate, diligent and an excellent attention to detail
Experience with migrating large data models between platforms is desirable, but not essential
Experience with SAP Business One and Tramada system or similar accounting / travel package is desirable, but not essential.
Experience in/knowledge of the travel industry is desirable, but not essential
Why CTM? CTM offer a strong, established, and sustainable work environment. We support and empower our employees and their development guided by our core values Connect, Evolve & Deliver. CTM offers a range of employee benefits including;
Travel & Hotel discounts
Health and Wellness (eg Health Rebate, Mental Health Support)
Training and Development opportunities
Two paid Chill-out Days
Annual Volunteer Day
Purchase Leave
Blended work arrangements with hybrid WFH flexibility
CTM is committed to the unique contributions of all our people and actively encourage candidates with all abilities and diverse backgrounds to apply.APPLY NOW to get started with your career at CTM!
#J-18808-Ljbffr