Data & Analytics Principal Consultant - Microsoft Fabric

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

Security Requirements: NZ Citizens and Residents Only

Full Time, Permanent Position.

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 innovate and grow.

About the Role (Your Why)

As a Principal Consultant, you will not only lead technical delivery but also play a key role in shaping client solutions that drive business outcomes and support pre-sales engagements

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 focused role, so you'll need to be an excellent communicator and good with people. The Principal Consultant works closely with practice leads, project managers, and client stakeholders and teams.

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.

What You'll Do

• Collaborate with sales and account teams to shape proposals and solution designs during pre-sales engagements.
• Lead client presentations and solution walkthroughs to articulate value and differentiation.
• Identify opportunities for upselling and expanding service offerings within existing accounts.
• Facilitate stakeholder workshops to gather and clarify business requirements
• Lead the technical architecture, design and delivery for new Modern Data Platform solutions.
• Provide overall thought leadership to our clients regarding data profiling and integration recommendations.
• Provide thought leadership around the effective us of AI in the data platform landscape.
• Data modelling (relational and dimensional and Snowflake schema)
• Perform performance tuning/optimisation, and feature auditson data platform solutions.
• Provide detailed documentation, end user training and knowledge-transfer services to clients, and internal teams.
• Mentor developers, acting as an SME in data platform/warehouse architectures and data modelling

What You'll Bring

• Proven ability to engage with senior stakeholders and influence buying decisions.
• Experience in pre-sales solutioning, proposal development, and client presentations.
• Commercial acumen and ability to align technical solutions with business value.
• Strong consultation and client management skills.
• Advanced skills and a proven track-record of building data solutions in cloud platforms such as Azure, AWS & GCP
• Advanced skills in one or more data platforms such Azure, Fabric, Snowflake and Databricks
• Advanced ETL/ELT process design and implementation with tools such as Synapse Analytics, Azure/Fabric Data Factory, Snowflake, Coalesce, Fivetran, Matillion, dbt and AWS Glue
• Advanced data modelling skills (Star schema, Snowflake schema, data vault)
• Advanced skills in performance tuning, query plan, query plan analysis, indexing, table partitioning.
• Experience using Informatica IDMC or on-prem solutions

Experience 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 8+ years' experience in various Microsoft SQL server technologies including SSIS, SSRS, SQL Server Analysis Services
• Minimum 5+ years' experience in semantic layer development.
• Minimum 3+ years' experience in Power BI

Why Join Us Here at Datacom?

Datacom is one of Australia and New Zealand's largest suppliers of Information Technology professional services. We have managed to maintain a dynamic, agile, small business feel that is often diluted in larger organisations of our size. It's our people that give Datacom its unique culture and energy that you can feel from the moment you meet with us.

We care about our people and provide a range of perks such as social events, chill-out spaces, remote working, flexi-hours and professional development courses to name a few. You'll have the opportunity to learn, develop your career, connect and bring your true self to work. You will be recognised and valued for your contributions and be able to do your work in a collegial, flat-structured environment.

We operate at the forefront of technology to help Australia and New Zealand's largest enterprise organisations explore possibilities and solve their greatest challenges, so you will never run out of interesting new challenges and opportunities.

We want Datacom to be an inclusive and welcoming workplace for everyone and take pride in the steps we have taken and continue to take to make our environment fun and friendly, and our people feel supported.