Data & Analytics Senior Consultant
Auckland Auckland
$140,000 - 180,000 per year
Category IT Jobs
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. About the Role As a Senior 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.
The Senior Consultant works closely with principal consultants, practice leads, project managers, and client stakeholders and teams. This is a client facing role, so you'll need to be an excellent communicator and good with people. What Youll Do Working with clients (businesses users) to gather, clarify requirements and business rules by running workshops with stakeholders.
Contribute to the technical architecture, design and delivery for a new data platforms. Provide overall thought leadership to our clients regarding data profiling and integration recommendations. Data modelling (relational and dimensional modelling) 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 Excellent consultation and stakeholder management skills.
Excellent verbal and written communication skills. Proven track-record of designing and building modern data platforms Advanced skills in Azure, Fabric, and Snowflake pipelines, with experience in tools such as Azure Data Factory, Coalesce, Matillion, dbt, and Fivetran. Advanced ETL/ELT process design and implementation.
Advanced skills in SQL performance tuning, query plan, query plan analysis, indexing, table partitioning. Strong skills in cloud platforms such as Azure and AWS. Strong skills in data platform implementation, configuration, performance and cost management tuning (i.
e. Azure, Fabric, Snowflake) Strong skills in Power BI and semantic data modelling. Required Skills and Qualifications Bachelor's degree in Computer Science or related discipline Snowpro and Coalesce certified or Microsoft Azure/Fabric certified data engineer Minimum 7 years experience in EDW design and implementation.
Minimum 7 years experience in ETL architecting and design. Minimum 7 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.
Minimum 5 years experienc.
...