Data & Analytics Specialist

You’re good at what you do. And because of that you’ve got plenty of choices about who you work for and what you do. Rather than filling the next page with corporate platitudes and fluff, we’ll cut to the chase... What's on offer? We are supporting a great organisation with an exciting opportunity for Data & Analytics specialists with a passion for visualisation and modern platforms to work alongside their valued clients throughout New Zealand and Australia. The specialist will work as part of an agile team and be responsible for understanding data needs and creating, interpreting, and supporting analytical data driven solutions for clients with a focus on data modernisation and visualisation. This role is well suited to someone who thrives on connecting with clients and partners, building trusted relationships, and taking the lead in your specialist area. You can expect to: Participate in scoping, designing and implementation of Data & analytics solutions to clients across various technologies. Support Customer development and opportunities. Analyse and understand clients’ data, their business and data requirements. Develop and support client requirements and solutions in various Data technologies including Power BI, Microsoft Azure, Microsoft SQL Server, Microsoft Fabric and Snowflake. Support requirement analysis and participate in client facing discovery workshops. Supporting and interpreting existing SQL stored procedures. Creating data products using objects such as stored procedures, tables and views. What you'll bring: 3+ years’ experience in the IT industry 2+ Years’ experience in Data & Analytics technologies such as PowerBI, Microsoft Fabric, Databricks or Snowflake. A strong understanding of SQL query development, optimise SQL queries and advise on performance enhancements. A strong understanding of Data Warehousing and/or Lakehouse concepts, data modelling and metadata management. A strong understanding of visualisation techniques, PowerBI and knowledge of DAX. Experience modelling and implementation of roles, databases, and schemas. Knowledge of data ingestion using ETL and ELT design techniques. Some nice-to-haves: Microsoft Certification in Business Intelligence or Data Analysis. Microsoft Azure familiarisation and certification Experience in designing and building Azure Data Factory processes Experience in using and configuring Fabric and/or Snowflake Data Lakes. Knowledge and/or experience coding in Python Experience in DBT and/or Coalesce Haven't heard about Optic Digital? We’re good people who are well connected into great clients. We know what we’re doing, and we’ll back you 100% to get the role you’re after. We’ll get to know you, and what you like, so we can have your next role ready when you are. We’ll pay you as much as we can and as your skills and experiences grow, we’ll go into bat for you and help you recognise that growing value too. The small print Applications close 29.07.2026 and can only be submitted via Seek. Please note, only applicants that are eligible to work in New Zealand and can make themselves available for interviews in New Zealand will be considered. For any questions regarding the role, please get in touch with Emma at emm•••••••••••@opticdigital.com. #J-18808-Ljbffr