Data Warehouse

**About CTM**
CTM is a global award-winning provider of innovative and cost-effective travel management solutions to the corporate, events, leisure and loyalty travel markets. CTM provides personalised service excellence with client-facing technology solutions in offices all around the world, including New Zealand, Australia, Asia, North America and Europe with over 3000 employees and growing.

At CTM, our people are our greatest asset. We are a team of collaborative, innovative and future-focused professionals we work with the company's values in mind; Connect, Deliver and Evolve.

**About the Role**
The purpose of this role is to design, implement, and optimise data models, data structures, and integration processes that support the organisation's analytical and reporting capabilities within the global enterprise data warehouse environment. The Data Warehouse Modeler is responsible for translating business requirements into scalable and efficient data warehouse designs, ensuring that data is structured to enable accurate reporting, analysis, and decision-making. The role includes designing and developing semantic and tabular models that provide a business-friendly data layer, supporting efficient and self-service analytics across the organisation.

This role will work closely with business stakeholders, business analysts, data quality, data assurance, and reporting teams to deliver dimensional models, fact/dimension structures, and data marts. The position contributes to the ongoing improvement of data quality, performance, and governance across the enterprise data platform. The Data Warehouse Modeler will empower internal stakeholders by providing well-structured, reliable, and accessible data models that support self-service analytics and business intelligence initiatives. Ensure that data models are aligned with business definitions and enable accurate, efficient, and self-service analytics.

**Technical Skills**:

- Experience with dimensional modelling (star, snowflake schemas) and data warehouse design methodologies - Strong proficiency in SQL and database design principles.
- Knowledge of ETL/ELT development and integration with modelling requirements.
- Familiarity with cloud-based data platforms.
- Experience working with data modelling tools.
- Familiarity with CI/CD pipelines for data projects.
- Understanding data governance practices including metadata management, data quality and master data management.
- Experience with automated testing frameworks to validate data integrity, accuracy, and performance of ETL pipelines and models.
- Experience in the design, implementation, and optimisation of scalable data warehouse structures, dimensional models and semantic/tabular models. Soft

**Soft Skills**
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
- Adaptability to changing business needs and technology trends.

**Why CTM?**
CTM offer a strong, established, and sustainable work environment which will support your career development and wellbeing.
As a global organization CTM offers a range of employee benefits that you can access, including;

- Travel discounts
- Perkbox - Retail, Lifestyle, Entertainment and Health and Wellness discounts & benefits
- Training and Development opportunities
- Annual Volunteer Day
- x2 Wellness/Chillout Days
- Blended work arrangements with hybrid WFH flexibility 2 Weeks extra leave - Purchase Leave