Data & Analytics Principal Consultant - Snowflake

6 months ago

Wellington City, 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
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 in-house 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 long-term opportunities to progress within.
- FLEXIBILITY - A supportive and flexible working environment in up-to-date 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 knowledge-transfer 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 track-record 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 Snowflake’s architecture and features.
- Proven track-record 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.
- 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 data modelling (Star schema & Snowflake schema)
- Minimum 5+ years’ experience in semantic layer development.
- Minimum 5+ years’ experience in reporting and visualization tools.
- Advanced skills in Mi

  • Data and Analytics Principal Consultant

    8 months ago

    Auckland City, New Zealand Datacom Full time

    Our purpose Here 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 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...

  • Data & Analytics Principal Consultant

    6 months ago

    Wellington City, 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...

  • Data & Analytics Principal Consultant - Microsoft Fabric

    4 weeks ago

    Wellington, New Zealand Datacom Full time

    Position: Principal Consultant Data & Analytics - Microsoft FabricDatacom Location:Auckland Preferred, Wellington Ok, or else anywhere in the North Island if willing and able to travelOur WhyDatacom works with organisations and communities across Australia and New Zealand to make a difference in people's lives and help them to use the power of tech to...

  • Data & Analytics Principal Consultant - Microsoft Fabric

    4 weeks ago

    Wellington, New Zealand Datacom Full time

    Position: Principal Consultant Data & Analytics - Microsoft Fabric Datacom Location: Auckland Preferred, Wellington Ok, or else anywhere in the North Island if willing and able to travel Our Why Datacom works with organisations and communities across Australia and New Zealand to make a difference in people’s lives and help them to use the power of tech to...

  • Data & Analytics Principal Consultant - Microsoft Fabric

    4 weeks ago

    Wellington, New Zealand Datacom Full time

    Position: Principal Consultant Data & Analytics - Microsoft FabricDatacom Location:Auckland Preferred, Wellington Ok, or else anywhere in the North Island if willing and able to travelOur Why Datacom works with organisations and communities across Australia and New Zealand to make a difference in people's lives and help them to use the power of tech to...

  • Data & Analytics Principal Consultant - Databricks

    6 months ago

    Wellington City, 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 Why You Want to Join Us - Our Team and Culture,Benefits, Career Growth and Flexibility We are local...

  • Data & Analytics Principal Consultant - Microsoft Fabric

    4 weeks ago

    Wellington, New Zealand Datacom Full time

    Position: Principal Consultant Data & Analytics - Microsoft Fabric Datacom Location: Auckland Preferred, Wellington Ok, or else anywhere in the North Island if willing and able to travel Our Why Datacom works with organisations and communities across Australia and New Zealand to make a difference in people’s lives and help them to use the power of tech...

  • Data Senior Consultants

    6 months ago

    Auckland City, New Zealand Datacom Full time

    Our Why Datacom works with organisations and communities across Australia and New Zealand to make a difference in people’s lives and help organisations use the power of tech to innovate and grow. Our team The Data and Analytics team is a progressive group of diverse and creative individuals with a deep love for all things data-related. They build platforms...

  • Sales Engineer

    2 months ago

    Auckland City, New Zealand Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. There is only one AI Data Cloud. Snowflake’s founders started from scratch and designed a data platform built for the cloud that is effective, affordable, and accessible to all data users. But it didn’t stop there. They engineered Snowflake to power the AI Data Cloud, where thousands of...

  • Commercial Account Executive

    2 months ago

    Auckland City, New Zealand Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. Our Commercial Account Executives are responsible for the full sales lifecycle with mid market customers. To be successful in this exciting role you will have a proven track record selling solutions in the data and/or analytics arena or at least in Cloud. You know that sales is the career you...

  • Associate Sales Engineer

    3 weeks ago

    Auckland City, New Zealand Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. Snowflake’s pre-sales organization is actively seeking an **Associate Sales Engineer **to join the Sales Engineering training program ”Snowmaker”. Snowmaker’s purpose is to develop aspiring technical talent through a combination of education and mentorship. **After the successful...

  • Commercial Account Executive

    3 weeks ago

    Auckland City, New Zealand Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. Our Commercial Account Executives are responsible for the full sales lifecycle with mid market customers. To be successful in this exciting role you will have a proven track record selling solutions in the data and/or analytics arena or at least in Cloud. You know that sales is the career you...

  • Senior Data

    6 months ago

    Auckland City, New Zealand Dentsu Aegis Network Full time

    The purpose of this role is to partner with a client on up to two clients to help achieve the vision and strategic business goals, through designing and implementing consultancy projects that will transfom the business. Job Title: Senior Data & Analytics Consultant (12m Fixed Term) **Job Description**: Merkle Aotearoa | Auckland | 12-month fixed term |...

  • Enterprise Account Executive

    3 weeks ago

    Auckland City, New Zealand Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. Snowflake started with a clear vision: develop a cloud data platform that is effective, affordable, and accessible to all data users. Snowflake developed an innovative new product with a built-for-the-cloud architecture that combines the power of data warehousing, the flexibility of big data...

  • Principal Data and Analytics Specialist

    3 months ago

    Wellington City, New Zealand New Zealand Government Full time

    There's a good chance you've heard of the New Zealand Infrastructure Commission, Te Waihanga. We're small (but mighty) and haven't been around long by government standards. But our job is as big as it gets, helping New Zealand get the right infrastructure, whether it's transport connections that get us from A to B, water and power connections needed to...

  • Data & Analytics Engineer

    1 month ago

    Auckland City, New Zealand ASB Group Full time

    **Kia ora, Talofa lava, Kia Orana, Malo e lelei, Fakalofa lahi atu, Bula Vinaka and Namaste!** Join ASB's Data & Analytics Engineering community. A fantastic career opportunity for someone with 5+ years of data engineering experience. Albany/CBD hybrid location, competitive salary, income protection & life insurance, plenty of banking benefits & flexible...

  • Enterprise Account Executive

    1 month ago

    Auckland City, New Zealand Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. Your role will encompass prospecting, developing, and closing business in a timely manner while focusing on solving the prospect's business pain points and key challenges and delivering on agreed-upon business value-driven use cases. This role is a unique opportunity to enable our customers to...

  • Data And Analytics Senior Reporting Consultant

    1 month ago

    Wellington, New Zealand Fusion5 Full time

    Fusion5 is seeking a talented and highly engaged Senior Reporting Consultant to join our exceptional Fusion5 family in either Auckland, Wellington or Brisbane. In return for your skills, you’ll join a team like no other!Fusion5 is a Microsoft Solutions Partner for Data and AI and holds the Analytics on Microsoft Azure Specialization. We’ve been a member...

  • Nz

    6 months ago

    Auckland City, New Zealand AMP Full time

    **JOB DESCRIPTION**: **About the role** We are seeking a passionate and driven Māori law graduate to join AMP for a 2-year fixed-term opportunity to support the wider Legal & Governance team with the implementation of initiatives which drive business strategy. The successful Graduate Lawyer can expect to be supported with their professional legal studies...

  • Data & Analytics Engineer

    3 months ago

    Auckland City, New Zealand ASB Group Full time

    **Join ASB's Data & Analytics Engineering community. A fantastic career opportunity for someone with 5+ years of data/systems/engineering experience**: - ** Advance your SQL and ETL/ELT skillset**: - ** Albany/CBD hybrid location, competitive salary, income protection & life insurance, plenty of banking benefits & flexy ways of working** The Data &...