Data & Analytics Principal Consultant - Snowflake - Hiring Fast

We are looking for an organized Data & Analytics Principal Consultant - Snowflake to join our innovative team at Datacom in Wellington, Wellington, New Zealand.
Growing your career as a on_site Data & Analytics Principal Consultant - Snowflake is a great opportunity to develop beneficial skills.
If you are strong in strategic planning, persuasion and have the right experience for the job, then apply for the position of Data & Analytics Principal Consultant - Snowflake at Datacom today!

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 billion, making us one of Australasia’s largest professional IT service companies. We have renowned expertise in operating data centres and in providing IT services, software engineering and application management, as well as payroll and customer service design and operations. With this comes a long list of significant and notable clients so to meet their needs, and in turn our employees’, Datacom understands the value of hiring, developing and promotion of the very best available talent. At Datacom, nobody is just a cog in a wheel, with everyone’s contribution recognised and lauded whilst their training and development is specifically tailored to suit their own unique needs!

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.

** We are accepting applications from anywhere in NZ and around the World! So if interested and outside of Auckland then do please still apply! **

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 Microsoft BI stack.

· Minimum 8+ years’ experience in various Microsoft SQL server technologies including SSIS, SSRS, SSAS

· Minimum 4+ years’ experience in design, development and implementation of data solutions using Snowflake.

· Wherescape RED, 3D experience is preferred.

· Minimum 3+ years’ experience in Power BI

What are you waiting for! If you are ready to make a difference in Australasia's largest homegrown technology company then apply within today!

Benefits of working as a Data & Analytics Principal Consultant - Snowflake in Wellington, Wellington, New Zealand:

● Career Growth Potential
● Professional Development Opportunities
● Attractive packageCompetitive Pay