Job Opportunities API

About this role | Mō tēnei tūranga mahi Theta is seeking an experienced Lead Data Consultant to join the Data and Insights Practice, based in our Wellington or Auckland office. This is a priority hire within a team that values delivery excellence and a sustainable pace of work. The role has a strong data engineering focus, with accountability for leading the end-to-end build of modern data solutions. You’ll work closely with client stakeholders, solution architects, and delivery teams to design and deliver reliable, production-grade data platforms and pipelines that enable measurable business outcomes. While Microsoft Fabric is a key part of our delivery, we welcome candidates with strong delivery experience across modern platforms such as Fabric, Databricks, and Snowflake (and related Azure services), with the ability to apply good engineering fundamentals regardless of tooling. What the role delivers Lead the design, build, and optimisation of data pipelines across Lakehouse and warehouse patterns, with a focus on reliability, performance, and supportability Deliver robust data transformations that enable reporting, analytics, and AI use cases Shape and implement modern architecture patterns (e.g., medallion/bronze-silver-gold, curated layers, reusable data products) Produce clean, maintainable Python and SQL aligned to agreed engineering standards Implement automated testing, monitoring, data validation, and performance tuning to support stable operations Lead technical discovery and solution walkthroughs, translating business requirements into clear engineering scope and deliverables Partner with architects and delivery teams to shape solution design, estimates, sequencing, and delivery plans Provide clear communication on progress, risks, dependencies, and technical blockers to client stakeholders and delivery leadership Conduct peer reviews and promote consistent patterns across coding, documentation, and deployment practices Mentor team members, supporting capability uplift and delivery confidence Contribute to Theta delivery assets including templates, reusable components, documentation, and continuous improvement initiatives Please note: A cover letter accompanying your application is requested  Skills and experience | Ngā pūkenga me ngā wheako At least eight years of data engineering experience delivering enterprise-scale data platforms and/or Enterprise Data Warehouses, including complex integration and production support requirements Strong experience delivering on one or more modern platforms such as: a. Microsoft Fabric (e.g., Azure Data Factory/dataflows, Lakehouse/warehouse, OneLake, notebooks, Delta tables, workspace organisation) b. Databricks (e.g., notebooks, workflows, Unity Catalog, Delta Lake, orchestration) c. Snowflake (e.g., data modelling, performance patterns, secure sharing, orchestration/integration) d. Azure Synapse analytics (Azure Data Factory, Azure Data Lake Storage, Power BI) Advanced SQL capability (performance-aware transformation and modelling) Strong Python capability (including PySpark where relevant) Strong experience with modern Lakehouse/warehouse concepts and scalable solution design Strong understanding of Delta / table formats, medallion architecture concepts, and pragmatic data modelling patterns for analytics workloads Strong Git, CI/CD, DevOps and DataOps experience Experience implementing regression testing and data-quality frameworks Strong stakeholder engagement and communication skills across technical and non-technical audiences Experience mentoring team members or providing technical leadership Experience using AI coding assistants (e.g., GitHub Copilot or similar) with appropriate governance Relevant certifications (Microsoft/Databrick