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 innovate and grow. About the Role (Your Why) 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.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.Our offices are based in Auckland and Wellington though we are open to having people work from anywhere in the North Island as long as they are able to travel to clients when needed. We like to bring people together in person when we can, but we are mindful of the benefits of working from home for work/life balance. We therefore leave it to you and the team you join to figure out what works best!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 We are a pretty agile company and are keen to respond to customer, technology and internal stakeholders' changing requirements and this can mean we evolve in our roles to meet those needs. What You'll BringSkills 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 Databricks architecture and features. Proven track-record in the design, development and implementation of data solutions using Databricks. 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. 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 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 Databricks. Wherescape RED, 3D experience is preferred. 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.
#J-18808-Ljbffr