Data & Analytics Principal Consultant

2 weeks ago


Wellington, Wellington, New Zealand Datacom Full time
Our Purpose

Here at Datacom, we connect people and technology to solve challenges, create opportunities and discover new possibilities for the communities we live in whilst embodying a culture of trust and respect for employees and customers alike.

The Nuts and Bolts
Why You Want to Join Us - Our Team and Culture,Benefits, Career Growth and Flexibility
We are local at heart, yet world-class in capability. We've managed to maintain our local family feel whilst expanding globally across Australia, ASIA, US and the UK.

In the regions we continue to grow and actively support local workforces and their families, and we are focused on being a great place to work to facilitate an environment that encourages our employees to strive to imagine what's possible, challenge the status quo and put forward fresh, diverse thinking.

For our employees, this results in such fantastic perks as:

  • SALARY
  • A competitive salary package with annual performance reviews with the goal of taking care of and retaining the best talent.


BENEFITS
  • Amazing benefits such as free Healthcare and Life Insurance from leading providers and access to online training portals to help you gain any industry certificates that you might want and we even cover the examination costs if you pass


DEVELOPMENT
  • Due to our strong focus and dedication towards employee development, we have the aforementioned inhouse training plus our meticulous 'career framework', which helps map the next steps of your career and what you need to do to get to where you want to be.


OPPORTUNITIES
  • Having a large scale, globally respected IT organisation on your resume will do wonders for your prospects, and with a 7000 strong workforce, there are many longterm opportunities to progress within.


FLEXIBILITY
  • A supportive and flexible working environment in uptodate modern workplaces with a 37.5 hour working week and scope for remote or hybrid working.
Our Team

The Data and Analytics team are a progressive group of diverse and creative individuals with a deep love for all things data related.

They build platforms and solutions that are leading edge and at the forefront of the technology curve.

A close knit and fun team embedded within our rapidly growing Professional Services division, and part of the wider Datacom ecosystem.

About the Role
As a Principal Consultant, you will lead the technical delivery of large-scale data platform and BI solutions. You will be asked to design, implement and own the delivery of robust Data Platform solutions and end-to-end components.
This is a client facing role, so you'll need to be an excellent communicator and good with people.
The Principal Consultant works closely with practice leads, project managers, scrum masters, and client stakeholders and teams.

What You'll Do

  • Working with clients (businesses users) to gather, clarify requirements and business rules by running workshops with stakeholders.
  • Lead the technical architecture, design and delivery for a new Data platform.
  • Provide overall thought leadership to our clients regarding data profiling and integration recommendations.
  • Data modelling (relational and dimensional like star schema and Snowflake schema)
  • Managing development life cycle using various source code management tools.
  • Ability to perform performance tuning and optimisation on new and/or existing data warehouse solutions.
  • Provide detailed documentation, end user training and knowledgetransfer services to customers, and internal teams.
  • Mentor developers, acting as an SME in data warehouse architecture and data modelling
Skills and requirements

Skills:

  • Advanced data modelling skills (Star schema, Snowflake schema, data vault)
  • Proven trackrecord of building EDW's
  • Advanced ETL /ELT processes design and implementation.
  • Advanced skills in performance tuning, query plan, query plan analysis, indexing, table partitioning.
  • Strong skills in cloud platforms such as Azure, AWS & GCP
  • Strong skills in Azure Data Factory and data Flows and Azure SQL data platform.
  • Extensive knowledge of Databricks architecture and features.
  • Proven trackrecord in the design, development and implementation of data solutions using Databricks.
  • Extensive knowledge of Snowflake's architecture and features.
  • Proven trackrecord in the design, development and implementation of data solutions using Snowflake.
  • Experience in data ingestion tools such as Apache Kafka, Informatica, AWS Glue, Azure event hubs, Fivetran, Matillion, DBT and Coalesce.
  • Experience in Apache Airflow.
  • Strong consultation and clients' management skills
  • Strong understanding of Agile delivery methodology.
  • Excellent verbal and written communications.
Required Skills and Qualifications

  • Bachelor's degree in Computer Science or related discipline
  • Minimum 8+ years' experience in EDW design and implementation.
  • Minimum 8+ years' experience in ETL architecting and design.
  • Minimum 8+ years' experience in d


  • Wellington, Wellington, New Zealand Datacom Full time

    Job Description - Data & Analytics Principal Consultant Our Purpose Here at Datacom, we connect people and technology to solve challenges, create opportunities and discover new possibilities for the communities we live in whilst embodying a culture of trust and respect for employees and customers alike.The Nuts and Bolts We now have 7000 people across our...


  • Wellington, Wellington, New Zealand Datacom Full time

    Our PurposeHere at Datacom, we connect people and technology to solve challenges, create opportunities and discover new possibilities for the communities we live in whilst embodying a culture of trust and respect for employees and customers alike.The Nuts and BoltsWe now have 7000 people across our global offices and generate an annual revenue of over $1.4...


  • Wellington, Wellington, New Zealand Datacom Full time

    Our Purpose Here at Datacom, we connect people and technology to solve challenges, create opportunities and discover new possibilities for the communities we live in whilst embodying a culture of trust and respect for employees and customers alike.The Details We now have 7000 people across our global offices and generate an annual revenue of over $1.4...


  • Wellington, Wellington, New Zealand Datacom Full time

    Our PurposeHere at Datacom, we connect people and technology to solve challenges, create opportunities and discover new possibilities for the communities we live in whilst embodying a culture of trust and respect for employees and customers alike.The DetailsWe now have 7000 people across our global offices and generate an annual revenue of over $1.4 billion,...


  • 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 Data Analytics & Platform Lead for one of our clients in Wellington, New Zealand.Short...


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

    Are you a passionate data professional with a deep understanding of technical practices? Do you thrive in a challenging and dynamic environment and are motivated by the opportunity to work in a role with exposure throughout the public sector and with Parliament?The Office of the Auditor-General | Te Mana Arotake(the Office) aims to improve trust and...


  • 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....


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

    The Social Wellbeing Agency is getting ready to transition to the Social Investment Agency, a new stand-alone central agency, on 1 July 2024. The new agency will be leading change across the public, and in addition to our existing functions, we will have new functions so we can support Government to achieve better outcomes from social service expenditure....


  • Wellington, Wellington, New Zealand Datacom Full time

    Our purposeHere at Datacom we connect people and technology in order to solve challenges, create opportunities and discover new possibilities for the communities we live in.Our teamThe Data and Analytics team are a progressive group of diverse and creative individuals with a deep love for all things data related. They build platforms and solutions that are...


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

    Data and Analytics Programme Manager - 24 Month Fixed TermAre you an experienced programme management professional who is motivated by the opportunity to contribute to our digital transformation and support an evolving analytical capability.The Data and Analytics team is responsible for the development, advice and delivery of data and analytic capability and...


  • Wellington, Wellington, New Zealand Capgemini Full time

    Due to our growth within the NZ SharePoint space we are seeking an experienced Principal SharePoint Consultant with solid technical leadership and migration project experience to join our Wellington Capgemini office.Come and join a thriving company and become part of a diverse global collective of free-thinkers, entrepreneurs and industry experts who are all...


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

    Principal Advisor Data Quality and Monitoring/ Kaitohutohu MātāmuaThe TEC - Te Amorangi Mātauranga Matua is a small Crown agency with a big job to do - ensuring New Zealanders have the skills and the knowledge they need to ensure lifelong success to build a great country. We lead the Government's relationship with the tertiary education sector in New...


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

    Ko mātou tēnei | Who we areTe Komihana Tauhokohoko | The Commerce Commission is New Zealand's competition, fair trading, consumer credit and economic regulatory agency. Our mission is to make New Zealanders better off by ensuring our markets work well and consumers and businesses are confident participants in those markets.The Commission is going through...

  • Principal Consultant

    2 weeks ago


    Wellington, Wellington, New Zealand Recruit IT Full time

    Testing & Quality Assurance (Information & Communication Technology) Lead strategic QA and Test Automation advisory engagements.Working alongside our customers to mature their Quality Engineer and Test Automation practises.Maturing our Test Automation frameworks and best practisesLead strategic QA and Test Automation advisory engagements.Working alongside...

  • Principal Advisor

    2 weeks ago


    Wellington, Wellington, New Zealand Ministry Of Social Development Full time

    We are searching for an ambitious Principal Advisor to join our stellar team at Ministry of Social Development in Wellington.Growing your career as a Full Time Principal Advisor is an amazing opportunity to develop productive skills.If you are strong in cooperation, decision-making and have the right initiative for the job, then apply for the position of...

  • Data Analyst

    2 weeks ago


    Wellington, Wellington, New Zealand New Zealand Government Full time

    If you're passionate about making a difference to the lives of New Zealanders, working at the Office of the Auditor-General | Te Mana Arotake (the Office) could be your next career move.The Office aims to improve trust and confidence in the public sector. The Auditor-General is the statutory auditor of all public organisations and helps ensure that New...


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

    Mō te tūnga | About the roleWe need someone with the '4Ps' - passion, perseverance, persistence and patience, to contribute to making NZDF's Data and Information Vision a statement of fact.The NZDF has a vast and growing body of data and information unlike any other organisation in New Zealand and exploiting to maximum effect impacts on the safety and...


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

    Principal Advisor, Data and InformationPermanent, Full TimeWellington BasedTe Au Reka - Improving access to justice for all New ZealandersTe Au Reka represents the opportunity of a lifetime, making a profound difference to those who work in, and interact with, courts and tribunals. This new digital case management system will help modernise the...


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

    He angitūtanga - The opportunityThe Energy Efficiency and Conservation Authority (EECA) is a Crown Entity whose purpose is to mobilise New Zealanders to be world leaders in clean and clever energy use. Our strategic focus areas are based on influencing the energy decisions in the transport, business, and residential sectors.The Manager Data and Analytics is...


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

    Unique role, develop and implement a robust and consistent job architecture framework across Waka Kotahi 12month fixed term or secondment opportunity Wellington or Auckland based role with flexible working encouragedTe Whiwhinga mahi | The opportunity' The Principal Consultant Job Architecture is responsible for leading the design, development and...