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

The role plays a crucial role in developing, maintaining, and modernizing our data pipelines and reporting capabilities. The Senior Report Writer will work extensively with SQL, cloud data platform technologies and reporting tools to deliver accurate, timely, and performant data solutions.

Job responsibilities

The roles duties and responsibilities will include but not limited to the following:   

• 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.
• Ability to break down complex deliverables into stages of work and provide estimates to internal and external stakeholders.
• Utilize SQL & dbt to build, test, and deploy data transformation models that maintain data quality and consistency.
• 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 contribute to team planning.
• Promoting best practice standards, conducting code peer reviews and ensuring effective knowledge sharing.
• Mentor data engineers and lead code reviews to uplift engineering standards, strengthen technical capability, and promote consistent, high-quality delivery across the team.
• Effective time management, ability to manage various projects, stakeholders and pivot to priority incidents as required.
• Provide end-to-end ownership of the enterprise data platform, with accountability for the reliability, performance, and continuous improvement of scheduled jobs, data pipelines, and reporting services.
• Lead the response to production data processing failures and priority incidents, restoring critical services, driving root cause resolution, and strengthening platform resilience through preventative improvements.

Required Skills:

The ideal candidate will bring strong knowledge and demonstrable experience in modern data platform engineering including:

• Strong proficiency in SQL, ability to perform root cause analysis to identify and resolve data processing and reporting issues.
• Design, build, and optimize robust and reusable datasets in Snowflake, dbt.
• Deep knowledge and demonstrated expertise across an enterprise data platform, including data ingestion, transformation, orchestration, monitoring, governance, and production support.
• Experience managing an enterprise cloud data platform, including user administration, security controls, role-based access control (RBAC), and governance across production environments.
• Experience creating reports and dashboards with tools like SSRS and PowerBI.
• CI/CD and Git experience.
• Excellent written and verbal communication skills to liaise with internal and external stakeholders.
• An analytical mind with strong problem-solving skills.
• Great relationship management and service delivery mindset.

Beneficial Skills:

• Azure Ecosystem, Azure DevOps, Azure Data Factory
• Data modelling, data processing & data migration, ETL/ELT techniques e.g. Fivetran,
• Exposure to data-sharing, and governance controls i.e. data masking, RBAC policies.
• Investment or Financial industry experience

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.