Exciting Data Engineer opportunity at award winning corporate travel management company - CTM! 14th February, 2024 About CTM CTM is an award-winning provider of travel solutions spanning corporate, events, film & music, sport, leisure and loyalty markets. Headquartered and founded in Australia, CTM has offices all around the world, including Australia, New Zealand, Asia, North America and Europe with over 3000 employees and growing. Visit our website: About the Role We currently have an opportunity for an experienced BI/Data Engineer to join an award-winning travel management company that is revolutionizing online technology capabilities within their sector! You will play a pivotal role in continuing the growth of the online platform and ensuring that the web applications are best of breed. Key Responsibilities Translating business requirements into efficient technical design Contributing to development of new Azure-based data warehouse platform and migration of SSIS packages to Azure Data Factory pipelines Working with the Lead Data Engineer to manage and maintain a global data warehouse environment/ETL framework and database integrations Managing current BI solutions, design and creating new SSIS packages and SSRS and Power BI reports Problem analysis, process improvements and efficient issue resolution 14th February, 2024 About CTM CTM is an award-winning provider of travel solutions spanning corporate, events, film & music, sport, leisure and loyalty markets. Headquartered and founded in Australia, CTM has offices all around the world, including Australia, New Zealand, Asia, North America and Europe with over 3000 employees and growing. Visit our website: About the Role We currently have an opportunity for an experienced BI/Data Engineer to join an award-winning travel management company that is revolutionizing online technology capabilities within their sector! You will play a pivotal role in continuing the growth of the online platform and ensuring that the web applications are best of breed. Key Responsibilities Translating business requirements into efficient technical design Contributing to development of new Azure-based data warehouse platform and migration of SSIS packages to Azure Data Factory pipelines Working with the Lead Data Engineer to manage and maintain a global data warehouse environment/ETL framework and database integrations Managing current BI solutions, design and creating new SSIS packages and SSRS and Power BI reports Problem analysis, process improvements and efficient issue resolution Skills and Experience At least 5-10 years' experience managing and developing complex ETL, data integration and data warehousing solutions within predominantly MS-BI environments Experience with Azure Cloud Data Warehouse/Azure Synapse, Azure Data Factory, Azure Analysis Services, Power BI highly regarded Develop, manage, and maintain ETL frameworks, data modelling and analysis using Kimball dimensional modelling methodology Demonstrated experience with database design using MSSQL, implementing data solutions, developing complex Stored Procedures, Functions, User-defined Functions and Views Experience/interest in AI/ML approaches to data analysis is desirable Strong communication and teamwork skills Ability to work both individually and collaboratively and enjoy taking ownership of a project Why CTM? As a global organisation CTM offer a range of employee discounts which include travel discounts, Health and Wellness perks, Training and Development opportunities. Employee well-being and flexibility is part of our DNA – we offer blended work arrangements with hybrid WFH flexibility, Monday to Friday working days, Wellness/Chill-out days throughout the year, Annual Volunteer Day and strong sustainability focus. CTM is an inclusive workplace and is committed to the unique contributions of all our people and actively encourage candidates with all abilities and diverse backgrounds to apply. Come work for a global award-winning company that values its people and community. APPLY NOW to get started with your career at CTM.Apply For Job #J-18808-Ljbffr