Senior Data Warehouse Designer
7 months ago
SG Consulting is an IT consulting firm based in New Zealand, Australia, and India and the business leaders come to us when they want enduring results. We find value across boundaries, develop insights to act on, and energize teams to sustain success.
We are looking for a **Senior Data Warehouse Designer** for one of our clients in Wellington, New Zealand.
**Short Description**:
Suppose your passion is to work with analysing complex source systems and modelling data structures, definitions, relationships, and mapping these to the requirements of the data warehouse. Then this role is for you.
**About the role**:
We are looking for a senior data warehouse designer with a strong track record leading the design of large/complex dimensionally modelled data warehouses, as well as being a strong communicator with senior business stakeholders.
**About you**:
This is a very senior role. To be considered for this role you will need to have _**ALL**_ of the following:
- Highly experienced at analysing complex source systems and modelling data structures, definitions, relationships, and mapping these to the requirements of the data warehouse.
- Understanding of modern ELT processing design/patterns for populating a dimensional model.
- Advanced SQL skills (preferably in Snowflake) to build queries to profile data and validate designs.
- Experienced at writing detailed design specifications for developers.
- Excellent written and oral communication / presentation skills with senior business leaders and an ability to convey complex ideas clearly and concisely and able to facilitate and document business requirements discovery.
- Overall strong analytical and problem-solving skills.
In addition, experience in the following areas would be advantageous:
- Scripting languages such as Python, PowerShell, Perl, Bash,.NET
- Cloud-based technology, such as Azure or Amazon Web Services
- Information management, data quality governance processes
You will most likely have a relevant tertiary qualification and have at least **15** years of data warehouse experience. Consulting experience in industries such as banking, insurance, energy, telco and/or government is also advantageous.
Schedule:
- Monday to Friday
Ability to commute/relocate:
- Wellington City, Wellington: Reliably commute or planning to relocate before starting work (required)
-
Senior Data Warehouse Developer
7 months ago
Wellington City, New Zealand HAYS Full time6-Month Contract Opportunity for a Senior Data Warehouse Developer (MS Stack) Title**:Senior Data Warehouse Developer** Organisation**:Public Sector** Length**:6 Months** Rate**:$115 - $130 p/hr** Location**:Wellington + WFH Flexibility** In this role, you'll be responsible for - Designing, implementing and maintaining complex data engineering solutions to...
-
Senior Data Engineer
3 months ago
Wellington, New Zealand Data Privacy Full timeThe New Zealand Government is seeking a Senior Data Engineer for NZTA | Waka Kotahi to help embed data principles and deliver a data-driven vision. This role is part of Te Aukaha | Digital, which supports NZTA's digital transformation by providing quality data, information, and security services. The team designs and implements new digital solutions to keep...
-
Senior Data Warehouse Engineer
7 months ago
Wellington City, New Zealand New Zealand Government Full timeTe tūnga | The role We have an exciting permanent full-time opportunity for a Senior Data Warehouse Engineer to join our Data & Analytics group. Reporting to our Business Intelligence & Analytics Manager, you will be responsible for the development and maintenance of ESR's enterprise data warehouse to support analysis and reporting for both internal and...
-
Senior Business Intelligence and Data Warehouse
7 months ago
Wellington City, New Zealand New Zealand Government Full timeContribute to transforming the future of health in this Senior Business Intelligence and Data Warehouse Developer role - Opportunity to thrive in a fast paced and dynamic environment - Flexible working fully supported to balance your workplace and lifestyle - Wellington Location preferred (negotiable for the right person) - Permanent, Full-time...
-
Senior Operational Data Warehouse Engineer, Data
7 months ago
Wellington City, New Zealand New Zealand Government Full timeContribute to transforming the future of health in this Senior Operation Data Warehouse Engineer role - Opportunity to thrive in a fast paced and dynamic environment - Flexible working fully supported to balance your workplace and lifestyle Join Te Whatu Ora at a key time of change where you will meaningfully contribute to our kaupapa of creating a more...
-
Senior Data Engineer
4 months ago
Wellington City, New Zealand Kiwibank Full time**Wellington **based opportunity - Banking benefits, health insurance, flexible working options and more - Join our Data Engineering Team! **This is us. Where making an impact matters.** We are seeking a Senior Data Engineer to join our team who are working on supporting the way the bank uses data. An exciting opportunity within our growing Digital &...
-
Data Warehouse Analyst
2 days ago
Wellington City, New Zealand H2R Consulting Full time**Location**: Wellington Type: Permanent / Full Time Reference: 653381 H2R Technologies are currently on the lookout for an experienced Data warehouse analyst to join a specialist unit within one of New Zealands largest central government organisations. **Requirements**: - Identify, investigate and resolve any discrepancies in data quality - Develop...
-
Senior Operational Data Warehouse Engineer
2 weeks ago
Wellington City, New Zealand New Zealand Government Full timeKo wai mātou | Our Organisation It's not very often something happens that's big; like, really big. Big to the point that it will touch the lives of every single person in the country. That's what we're talking about here. The provision of health in Aotearoa New Zealand, and how it's run is about to change in a big way. Te Whatu Ora and Te Aka Whai Ora will...
-
Data Warehouse Modeller
7 months ago
Wellington City, New Zealand New Zealand Government Full timeTe tūnga | The role We have an exciting permanent full-time opportunity for a Data Warehouse Modeller to join our Data & Analytics group. Reporting to our Business Intelligence & Analytics Manager, you will be responsible for creating efficient and scalable data models that support the organisation's data warehousing and business intelligence initiatives....
-
Data Engineer
2 months ago
Auckland City, New Zealand The Warehouse Full timeCompany Description Welcome! Kia Ora The Warehouse Group (TWG) is a Kiwi household name, and we proudly recognise the role that we play in communities throughout New Zealand. We are the largest general merchandise retailer in NZ across The Warehouse, Warehouse Stationery & Noel Leeming. We continue to have our customers top of mind as we work purposefully...
-
Senior Data Engineer
7 months ago
Auckland City, New Zealand HAYS Full timeSenior Data Engineer **Your new company** An organisation at the core of New Zealand's and Australia's economy, and one of New Zealand's largest private companies. Working culture at this organisation promotes responsibility and ownership, a relaxed and professional environment where you will have the opportunity to engage with end-users and senior...
-
Data Warehouse Modeller
7 months ago
Wellington City, New Zealand New Zealand Government Full timeTe tūnga | The role We have an exciting permanent full-time opportunity for a Data Warehouse Modeller to join our Data & Analytics group. Reporting to our Business Intelligence & Analytics Manager, you will be responsible for creating efficient and scalable data models that support the organisation's data warehousing and business intelligence...
-
Data Warehouse Developer
7 months ago
Wellington City, New Zealand New Zealand Government Full time**Kaiwhakawhanake Pātaka Raraunga**: Data Warehouse Developer (intermediate) Te Amorangi Mātauranga Matua, the TEC - is a small Crown agency with a big job to do - ensuring New Zealanders have the skills and the knowledge they need to build a great life, and ensure New Zealand thrives. We invest over $3 billion annually across the tertiary education and...
-
Data Engineer
2 months ago
Auckland City, New Zealand The Warehouse Group Full time**Company Description** Welcome! Kia Ora** The Warehouse Group (TWG) is a Kiwi household name, and we proudly recognise the role that we play in communities throughout New Zealand. We are the largest general merchandise retailer in NZ across The Warehouse, Warehouse Stationery & Noel Leeming. We continue to have our customers top of mind as we work...
-
Senior Data Engineer
7 months ago
Wellington City, New Zealand New Zealand Government Full time**Type**: PermanentHours: Full timeLocation: Wellington Business Group: Te Waka Aukaha/Planning Design and Assurance Branch: Kāwai ki te Iwi / Service Delivery and OperationsSalary: $117,742 - $157,843 We're looking for a driven and experienced Senior Data Engineer to join our Business Intelligence & Insights team to enable advanced analytics solutions...
-
Lead Operational Data Warehouse Engineer
2 weeks ago
Wellington City, New Zealand New Zealand Government Full timeKo wai mātou | Our Organisation It's not very often something happens that's big; like, really big. Big to the point that it will touch the lives of every single person in the country. That's what we're talking about here. The provision of health in Aotearoa New Zealand, and how it's run is about to change in a big way. Te Whatu Ora and Te Aka Whai Ora will...
-
Wellington City, New Zealand New Zealand Government Full timeJoin a supportive and inclusive team and workplace culture - Opportunity to thrive in a fast paced and dynamic environment where the work you do truly impacts! - Flexible working fully supported to balance your workplace and lifestyle Ko wai mātou | Our Organisation It's not very often something happens that's big; like, really big. Big to the point that...
-
Enterprise Data Warehouse Developer
2 months ago
Wellington, New Zealand New Zealand Government Full timeThe Data and Information Product Group are on the lookout for experienced Data Warehouse Developers! If you are passionate about data and information, this might be the opportunity for you. Join our digital whānau and support a variety of meaningful projects. - One permanent full-time position. - Two fixed term positions to June 2027. - All positions are...
-
Data Engineer
1 day ago
Auckland City, New Zealand Momentum Consulting Group Full timeTake ownership of Cloud DW and chance to upskill in Cloud tech - Input into strategic decisions and engage with senior stakeholders - Excellent salary **The Opportunity** *** A fantastic upskilling opportunity for a Data Engineer to take ownership of our client’s Cloud Data Warehouse journey, be involved on strategic data related decisions and have key...
-
Senior Data Engineer
4 days ago
Wellington City, New Zealand Precision Data Full time**Why we need you & what you will be doing** We are looking for 7 Software engineers to work with our team. This is a full time permanent role with 40 hours per week. **What we are doing**: Precision Data are working closely with a client who are doing a Risk assessment of payment transactions and this role is around upgrading their current platform, it...