![SG Consulting Limited](https://media.trabajo.org/img/noimg.jpg)
Senior Data Warehouse Designer
2 weeks 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
2 weeks 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 Warehouse Developer
7 days ago
Auckland City, New Zealand Auckland Council Full time**Senior Data Warehouse Developer** **The opportunity** You will be working closely with business units across council as well as ICT support teams to deliver agile Business Intelligence (BI) and data warehousing solutions. You will analyse business requirements, business process modelling/mapping, data warehouse solution design and build using the Kimball...
-
Senior Data Warehouse Engineer
2 weeks 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...
-
Data Warehouse Developer
7 days ago
Wellington City, New Zealand New Zealand Government Full time**Kaiwhakawhanake Pātaka Raraunga**: Data Warehouse Developer (Senior-level) 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...
-
Senior Business Intelligence and Data Warehouse
2 weeks 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
4 weeks 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...
-
Data Warehouse Analyst
2 weeks 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 Data Engineer
3 weeks 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 &...
-
Senior Data Engineer
3 weeks ago
Wellington City, New Zealand HAYS Full time9-month Contract - Senior Data Engineer - Wellington **Your new company** You will be working for a government agency, that is contributing to the social and economic growth of the whole country based in Wellington CBD. **Your new role** As a Data Engineer you will be working on an Oracle to Snowflake migration project. You will be working closely...
-
Data Warehouse Modeller
4 weeks 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....
-
Senior Data Engineer
3 weeks 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 Engineer
2 weeks 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...
-
Data Warehouse Developer
5 hours ago
Auckland City, New Zealand Beyond Recruitment Full timeData Warehouse Developer - Permanent Full Time - South Auckland Looking for an experienced Data Warehouse Developer for my client who runs a complex systems landscape and is currently on the move for reducing dependence on legacy systems through investment in improvement and replacement programs, across both large platforms and bespoke software. You will...
-
Data Technology Designer
7 days ago
Wellington City, New Zealand Accident Compensation Corporation Full timeACC is a unique organisation - there's nothing quite like it in the rest of the world! Our purpose at ACC is to improve lives every day. It's to enable everyone in Aotearoa the freedom to live their lives knowing that if they need us, we'll be there. We are refreshing our core data platforms and data consumption tools and as a Data Technology Designer you...
-
Data Warehouse Modeller
2 weeks 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...
-
Senior Operational Data Warehouse Engineer
4 weeks ago
Wellington Central, New Zealand Te Whatu Ora Full time**Ko 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...
-
Data Engineer
2 weeks 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...
-
Data Warehouse Developer
2 weeks 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...
-
Senior Data Engineer
4 weeks ago
Auckland City, New Zealand The Warehouse Full timeCompany Description Welcome! Kia Ora This isn’t your average Data Engineer role. We’re on the hunt for a seasoned Data Engineering professional with hands-on experience in Snowflake and DBT implementations to join our growing team. As we modernize our Data Engineering toolset with new technologies, you’ll play a key role in major migration and...
-
Data Warehouse Analyst
4 weeks ago
Auckland City, New Zealand New Zealand Government Full timeHealth Information Group We are looking for an experienced Data Warehouse Analyst to support and develop our data warehouse environment. This is your chance to add value in an innovative and ever-changing department. You will have rich experience in working with information, reconciling of independent systems, and have participated in the creation of data...