
Data & Analytics Senior Consultant
- Wellington
- Permanent
- Full-time
- 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 new modern data platforms using innovative ideas and your proven experience in data warehousing.
- Provide overall thought leadership to our clients regarding data warehousing and source system integration recommendations.
- Design data models (relational and dimensional modelling) across different data domains and industries.
- Ability to perform performance tuning and optimisation on new or existing data platform solutions.
- Managing development life cycle using various source code management tools including our AI modernisation techniques and products.
- Ability to design and develop customised self-service solutions using Power BI, with an in-depth knowledge of the different deployment options.
- Provide detailed documentation, end user training and knowledge-transfer services to customers, and internal teams.
- Excellent consultation and stakeholder management skills.
- Excellent verbal and written communication skills.
- Proven track-record of designing and building modern data platforms including Enterprise Data Warehouse migration experience.
- Advanced and practical skills in Azure, Fabric, and Snowflake (dataflows, pipelines, notebooks) with experience in tools such as Azure/Fabric Data Factory, Coalesce, Matillion, dbt, and Fivetran.
- Advanced and practical skills using Python
- Strong skills in cloud platforms including 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, Power Query, SQL and DAX semantic data modelling.
- Advanced and practical skills using DevOps and knowledge of CI/CD pipelines, Git integration, and deployment automation
- 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 Power BI