Principal Consultant - Data Analytics
Datacom, New Zealand
Job Description
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 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.
The Nitty Gritty
We have over 6,200 people across our global offices, and generate an annual revenue of over $1.2 billion, this makes us one of Australasia’s largest professional IT services companies. We have extensive expertise in operating data centres, 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 clients. Datacom is committed to hiring, developing and promoting the best talent from a diverse range of backgrounds. We are local at heart, yet world-class in capability.
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.
- Mentor developers, acting as an SME in data warehouse architecture and data modelling
- Advanced data modelling skills (Star schema, Snowflake schema, data vault)
- Excellent verbal and written communications.
- Bachelor's degree in Computer Science or related discipline
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.
Skills and requirements
Skills
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 amp; GCP
Strong skills in Azure Data Factory and data Flows, Azure Databricks, and Azure SQL data platform.
Strong consultation and clients’ management skills
Strong understanding of Agile delivery methodology.
Required Skills and Qualifications
Minimum 10+ years’ experience in EDW design and implementation.
Minimum 10+ years’ experience in ETL architecting and design.
Minimum 10+ years’ experience in data modelling (Star schema amp; Snowflake schema)
Minimum 8+ years’ experience in semantic layer development.
Minimum 8+ years’ experience in reporting and visualization tools.
Advanced skills in Microsoft BI stack.
Minimum 10+ years’ experience in various Microsoft SQL server technologies including SSIS, SSRS, SSAS
Minimum 3+ years’ experience in Power BI