Senior Data Engineer – Analytics & Reporting

The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers. Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.

Your career with us should reflect your energy and passion. That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience. Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities. For our business, for clients, and for you

Senior Data Engineer – Analytics & Reporting

Location: Auckland

This role is responsible for developing, maintaining, and modernising our data pipelines, enterprise data platform, and reporting capabilities, while also providing technical leadership, people mentorship, and work management support within the team. It helps set technical direction, guide delivery priorities, support developer growth, and ensure team outcomes are delivered effectively. This role works with the Cloud Data Platform (CDP) within the Apex Investment Administration New Zealand business, which provides fund administration, wealth administration, unit pricing, and custody services to investment managers who collectively have over $140 billion of assets.

Job responsibilities

• Developing, maintaining, and enhancing Apex New Zealand’s modern data platform including:
  • Creating reusable data models for financial reporting.
  • Writing and maintaining reports and dashboards.
  • Ensuring security and reliability of the data, creating automated tests and working with stakeholders to ensure data accuracy.
  • Creating and maintaining technical documentation.
• Break down complex deliverables into manageable stages of work, provide estimates to internal and external stakeholders, and support prioritisation, planning, and allocation of team activities.
• Design and develop advanced SSRS reports to visualize complex datasets, ensuring high performance and user-friendly interfaces.
• Own the delivery and governance of data egress to clients through Snowflake data sharing, SSRS, and client-facing Power BI reporting, ensuring secure, accurate, and timely distribution of data products.
• Delivering Quality – instilling and maintaining a focus on how quickly the team are learning and how we can improve the overall data platform.
• Participate in agile ceremonies and actively contribute to team planning, work sequencing, delivery tracking, and continuous improvement of team ways of working.
• Manage, mentor, and support direct reports through regular coaching, work allocation, performance guidance, code peer reviews, technical direction, knowledge sharing, and development support to build capability across the team.
• Demonstrate strong work management capability, balancing team priorities, multiple projects, stakeholder expectations, production support, and priority incidents as required.
• Provide end-to-end ownership and senior technical leadership across the enterprise data platform and reporting capability, setting technical direction and ensuring reliability, performance, governance, and continuous improvement of scheduled jobs, data pipelines, and reporting services.
• Lead production support for data processing failures and priority incidents, restoring critical services, resolving root causes, and strengthening platform resilience through preventative improvements.

Required Skills:

• Advanced SQL skills are essential, including the ability to perform root cause analysis to identify and resolve data processing and reporting issues.
• Experience creating reports and dashboards with tools like SSRS and PowerBI.
• Strong experience designing, building, loading, maintaining, and optimising robust and reusable datasets in SQL Server, Snowflake and dbt.
• Proven experience within enterprise data platform environments, including data ingestion, transformation, orchestration, monitoring, governance, infrastructure support, production support, and data platform maintenance.
• Experience managing enterprise cloud data platforms, including user administration, security controls, role-based access control, and cost/performance optimisation across production environments.
• Demonstrated ability to mentor developers, provide technical direction, manage team workload, and support delivery planning in a senior technical role.
• Excellent written and verbal communication skills, with the ability to ask the right questions, liaise with internal and external stakeholders, identify issues, and challenge constructively where required.

Beneficial Skills:

• Cloud platform exposure is highly preferred, particularly Snowflake, Azure Ecosystem, Azure DevOps, and Azure Data Factory.
• Data modelling, data processing & data migration, ETL/ELT techniques e.g. Fivetran, dbt.
• Investment or Financial industry experience

What you will get in return:

• A genuinely unique opportunity to be part of an expanding large global business;
• Competitive remuneration commensurate with skills and experience;
• Training and development opportunities

Additional information:

We are an equal opportunity employer and ensure that no applicant is subject to less favourable treatment on the grounds of gender, gender identity, marital status, race, colour, nationality, ethnicity, age, sexual orientation, socio-economic, responsibilities for dependants, physical or mental disability. Any hiring decision are made on the basis of skills, qualifications and experiences.

We measure our success as a business, not only by delivering great products and services and continually increasing our assets under administration and market share, but also by how we positively impact people, society and the planet. For more information on our commitment to Corporate Social Responsibility (CSR) please https://www.apexgroup.com/corporate-social-responsibility/

“Personal data provided by job applicant(s) will be used for recruitment purposes only and will be treated strictly confidential. Such personal data can be accessed by different Apex stakeholders within and out of country for the consideration of the job application hereunder. Application made by the job applicant(s) constitutes the irrevocable consent of the job applicant for her/his personal data to be used by Apex stakeholders within or outside country for the purpose of this recruitment.”

Disclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.

About Apex Group

We are dedicated to driving positive change in financial services while fuelling the growth and ambitions of asset managers, allocators, financial institutions, and family offices. Established in Bermuda in 2003, the Group has continually disrupted the asset serving industry through our investment in innovation and talent. Today, we set the pace in asset servicing and stand out for our unique single-source solution and unified cross asset-class platform which supports the entire value chain, harnesses leading innovative technology, and benefits from cross-jurisdictional expertise delivered by a long-standing management team and over 13,000 highly integrated professionals.

We’re a people-powered business, and our people are full of ambition. Together, we’re inspired to lead the new era of data and tech enabled service. Bringing new products and services to market. Sharpening our client focus. Disrupting the market to exceed expectations. Innovating across a range of specialisms. With our focus on making a difference to our people, our planet and our society, you’ll experience more here than you would at most other companies. Prepare to accelerate.

We’re a people-powered business with a vision to inspire a new era of service-led FinTech. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster.

Positive change starts with you. We’re a people-powered business with a vision to inspire a new era of service-led FinTech. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster.

The journey is yours to own. When you stretch yourself, you grow. We want you to explore ways of working that will see you thrive as part of something bigger. We’ll help you with a solid structure, challenging projects, vibrant networks, supportive colleagues and approachable leaders. All the things you need to own your unique journey.

Find out more about us