Data Modeller – Consultant / Senior Consultant at Deloitte New Zealand in Auckland

Job description

A week in the life of a Data Modeller might look like: Analysing complex business challenges and conducting structured investigations to identify data, information and reporting needs. Engaging with business stakeholders, clients, data engineers, architects and technical specialists to elicit, clarify and document requirements. Translating business processes and real-world scenarios into well-defined data entities, attributes, relationships and information flows. Designing, developing and reviewing conceptual, logical and physical data models that support analytics, reporting, AI and business transformation initiatives. Creating clear and accurate data models, diagrams, mappings, definitions and technical artefacts to communicate data structures and design decisions. Performing data analysis, profiling and discovery activities to identify opportunities, risks, data quality issues and improvement initiatives. Supporting data architecture, data governance and information management practices to improve data quality, consistency, accessibility and usability. Collaborating with Data Engineers, Data Scientists, Solution Architects and business stakeholders to deliver scalable end-to-end data and AI solutions. Contributing to the design and implementation of modern data platforms, analytics capabilities and information management solutions. Facilitating workshops, stakeholder engagement sessions and requirements gathering activities to drive alignment and outcomes. Advising stakeholders on best practices in data modelling, data management, analytics and emerging data technologies. Supporting proposal development, demonstrations and business development activities where required. Staying current with emerging trends, tools and practices across data, analytics, AI and information management. Enough about us - let's talk about you. You are someone with: 3+ years' experience in consulting, professional services, technology, or data-focused roles. Strong experience developing conceptual, logical and physical data models. Excellent analytical, problem-solving and investigative skills. Experience translating business requirements into structured data entities, relationships and models. Strong stakeholder engagement and communication skills, with the ability to work across business and technical teams. Proficiency with data modelling and diagramming tools such as Sparx Enterprise Architect, Lucidchart, Mermaid, Protégé or similar. Experience using SQL and/or Python for data analysis, validation and investigation. Understanding of data warehousing, dimensional modelling, data governance and modern data architecture principles. Strong documentation skills and attention to detail. An interest in emerging technologies, including AI and their application to data and analytics. A passion for continuous learning and professional development. Nice to have: Experience with enterprise platforms such as SAP, Oracle or Salesforce. Exposure to cloud data platforms such as Snowflake, Databricks, Azure, AWS or GCP. Experience with Power BI, Tableau, Qlik or similar analytics tools. Familiarity with Jira, Confluence or other delivery and collaboration tools. Exposure to semantic modelling, knowledge graphs, ontologies, RAG, or graph-based solutions. So, who is Deloitte in Aotearoa?   We are driven to create an impact that matters at every opportunity. Supported by a strong leadership team and member firms from over 150 countries across the globe, Deloitte in Aotearoa is in the business of solving complex problems. Over our 175-year history, we have built a reputation for impactful delivery across all areas of our business.  Deloitte in Aotearoa recognises the uniqueness of our country identified in our founding document, Te Tiriti o Waitangi.  We uphold our responsibility(s) to the founding document and acknowledge Māori as the Tangata Whenua/Indigenous people.   Our shared values are at the heart of everyt