Senior Data Warehouse Designer

2 weeks ago


Wellington, Wellington, New Zealand SG Consulting Limited Full time

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 problemsolving skills.
In addition, experience in the following areas would be advantageous:

  • Scripting languages such as Python, PowerShell, Perl, Bash,.NET
  • Cloudbased 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)


  • Wellington, Wellington, New Zealand The Institute of Environmental Science & Research (ESR) Full time

    Te tūnga | The roleWe 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...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    Contribute 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, Fulltime opportunityJoin Te...


  • Wellington, Wellington, 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 careers...


  • Wellington, Wellington, New Zealand H2R Consulting Full time

    Location:WellingtonType:Permanent / Full TimeReference:653381H2R 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 processes for capturing and...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    Te 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.In...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    Te tūnga | The roleWe 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.In...

  • Senior Data Engineer

    2 weeks ago


    Wellington, Wellington, New Zealand IHC New Zealand Full time

    Join our team as a Senior Data Engineer and embark on an exciting professional journey Unlock a permanent opportunity for career growth and advancement Be a part of our Wellington National Office, located in a vibrant and dynamic settingMō te tūnga | About the roleAre you passionate about data architecture, platform design, and data management? Are you...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    Intermediate Data Warehouse DeveloperTe 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 careers systems.If you're looking for your...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    Contribute to transforming the future of health in this 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, Fulltime opportunityJoin Te Whatu Ora...


  • Wellington Central, Wellington, New Zealand Te Whatu Ora Full time

    Ko wai mātou | Our OrganisationIt'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, Wellington, New Zealand New Zealand Government Full time

    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 careers systems.If you're looking for your "why", then come and join us at TEC....

  • Senior Data Engineer

    2 weeks ago


    Wellington, Wellington, New Zealand New Zealand Government Full time

    Mō te tūnga | About the roleThe Senior Data Engineer is responsible for providing technical expertise for the improvement of data engineering capability across NZDF to mature how data is managed, transferred, and utilised across NZDF.Key responsibilities: Consult, advise, and work closely with stakeholders across NZDF to ensure their data engineering...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    Discover a career with purpose at MBIE Data and BI Analyst focused role using SQL, SSRS and Power BI Step up role for a Data Analyst or BI Analyst with growth opportunities within the organisation Work closely with Data Engineers Opportunity to work in Energy and Resources sector Permanent fulltime opportunity, based in Wellington Salary range $115,585 to...

  • Senior Data Engineer

    2 weeks ago


    Wellington, Wellington, New Zealand CM Group Full time

    Marigold is the largest sender of personalized email on the planet. But we're so much more than an email provider or cross-channel marketing hub. We're committed to creating true partnerships with our clients, not just being another vendor. Working with some of the biggest names in ecommerce and publishing, we help deliver personalized email, mobile...


  • Wellington, Wellington, New Zealand New Zealand Government Full time

    The Ministry acts in the world to build a safer, more prosperous and more sustainable future for New Zealanders.Kia hangai ake e te Manatu he ao-haumaru, ao-tonui, ao-pumau, ki te oranga tonutanga mo Aotearoa whanui.Mō mātou - About usOur people represent New Zealand on and offshore, and in doing so make New Zealanders safer and more prosperous. By...


  • Wellington, Wellington, New Zealand New Zealand Ministry of Justice Full time

    Senior BI Developer (PowerBI) - Business Intelligence ServicesData & InformationTe whiwhinga mahi/The OpportunityJoin a high performing team delivering Business Intelligence solutions for the Ministry of Justice. This role is based in Wellington and primarily focuses upon PowerBI reporting needs for a number of critical business functions including Property...

  • Senior Data Engineer

    2 weeks ago


    Wellington, Wellington, New Zealand New Zealand Government Full time

    Lead improvements and champion best practice data management Support our ongoing digital transformation programme Flexible working to support your worklife balanceMō te tūranga mahi | About the roleWe are running a transformation programme to implement the Ministry's Digital Strategy, which focuses on the delivery of digital projects and programmes across...

  • Senior Data Analysis

    2 weeks ago


    Wellington, Wellington, New Zealand New Zealand Government Full time

    The Ministry acts in the world to build a safer, more prosperous and more sustainable future for New Zealanders.Kia hangai ake e te Manatu he ao-haumaru, ao-tonui, ao-pumau, ki te oranga tonutanga mo Aotearoa whanui. Collaborative and supportive team environment Work is highly valued by stakeholders Good mix of system capability improvement and data...

  • Senior Data Analyst

    2 weeks ago


    Wellington Central, Wellington, New Zealand Absolute IT Recruitment Specialists Full time

    Wellington Central- Data/Data Warehousing/Business Intelligence- Market Rate- Full Time- Contracting- 26 Jun 2023ABOUT THE CLIENTOur client is a public sector organisation who play a key role in supporting a goods market that provides genuine value for the population of Aotearoa New ZealandABOUT THE ROLEWe have partnered exclusively with our client to...

  • Senior Data Engineer

    2 weeks ago


    Wellington, Wellington, New Zealand Absolute IT Recruitment Specialists Full time

    Wellington- Data/Data Warehousing/Business Intelligence- Salary up to $140,000 per annum- Full Time- Permanent- 31 Aug 2023- Exciting transformation piece. Hybrid Working Arrangement + Wellington based. Challenging & Progressive work.ABOUT THE COMPANYOur client is a State Owned Enterprise who are responsible for providing up-to-date information through...