Lead BI Analyst Programmer

Description

Summary: This Lead BI Analyst Programmer role involves shaping BI strategy, building high-quality BI assets, and driving the optimisation and reusability of BI solutions to deliver essential services. Highlights: 1. Opportunity to shape BI strategy and data modelling frameworks. 2. Build and maintain high-quality BI assets with a focus on optimisation. 3. Collaborative team environment with career advancement opportunities. • Based in Albany. • Comprehensive Health Insurance. • Life & Disability Cover. • Generous KiwiSaver Contributions. • Enhanced Parental Leave. • Birthday Leave. • Long Service Rewards. • Career Advancement Opportunities. • Be a part of a Great Team. • Full-time, permanent contract with a minimum of 40 hours per week • Monday – Friday, 7.30 am - 4pm core office hours. About the Role Looking for your next big opportunity? We’ve got an exciting Lead BI Analyst Programmer role just for you! In this position, you’ll get to help keep our critical digital platforms running smoothly for the teams delivering essential services across Aotearoa, making a real impact. Provide advice, guidance and expertise in shaping BI strategy, semantic layer architecture and data modelling frameworks aligned to good governance and practice. Build and maintain high-quality BI assets using SQL, DAX and Power Query, with a strong focus on optimisation, reusability and performance. Own reusable semantic models and datasets, improving scalability and consistency of definitions and reporting outcomes across teams. Drive testing/debugging of BI solutions against technical specifications, ensuring accuracy, reliability and fit-for-purpose delivery. Create and maintain strong documentation (data definitions, lineage, models, requirements, operational procedures and end-user guidance). Identify improvement opportunities — reducing manual processes and duplicated datasets — and help the business lift data quality and ownership. Work collaboratively as part of a team, while also taking ownership and progressing tasks without constant supervision. Qualifications and Skills We’re looking for someone who blends strong technical depth with a pragmatic, team-first mindset - someone who can deliver with minimal guidance and bring others along on the journey. 5+ years’ experience in Business Intelligence or Analytics. Advanced Power BI expertise, including data modelling, performance optimisation, and reusable semantic models. Strong SQL, DAX and Power Query capability, delivering clean, scalable transformation logic. Proven experience with Microsoft Fabric or similar modern data platforms, with solid understanding of lakehouse/warehouse/pipeline concepts. Strong grasp of Medallion architecture and its application to governed, reusable analytics foundations. Deep knowledge of BI and data management principles: governance, standardised metrics, validation rules, lineage and data quality. Demonstrated ownership and accountability — able to prioritise, deliver independently, and keep stakeholders informed. Effective collaborator across business teams, technical specialists, vendors and application SMEs. Excellent documentation skills, producing clear specifications, models, definitions and operational artefacts. Who are we? Omexom is part of a global family of energy infrastructure services providers operating under the VINCI group which is a world leader in concessions, energy, and construction, operating in more than 120 countries worldwide. The brand network is a multi-disciplinary network, able to offer customized multi-technical, multi-site, or multi-country services. With our 1,000+ employees in 29 locations nationwide and $390M in revenue, Omexom has long-standing partnerships with Vector, Transpower, Auckland Transport, and Firstgas, while servicing our newer clients Watercare, Auckland District Health Board, Wellington Electricity, and City Rail Link Limited. In Aotearoa, Omexom is well positioned through this international network with shared values and vast resources, and a continued commitment to safety, excellence, and sustainable solutions. At Omexom, we are committed to creating a safe and inclusive environment that values and respects diverse styles, backgrounds, experiences, and perspectives. We welcome and encourage women, and people from diverse backgrounds to apply. How to apply If you like the sound of what we’re offering and think you are the right person for the job, we’d love to hear from you.  Hit the 'apply' button below.  Applications close on Thursday, 25 June 2026. Please note, that only candidates with the right to live and work in New Zealand will be considered for this role. According to the Harvard Business Review, men typically apply for jobs when they meet only 60% of the qualifications, whereas women and individuals from underrepresented groups usually apply only if they meet all the criteria. We're not just about checking boxes, so if you believe you have the skills but don't meet every requirement listed, please reach out if you would like to find out more, we'd love to talk with you. Come join our amazing team and be a part of the pioneers in energy transition.