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 (Senior Report Writer)
Location : Manila, Philippines
Description
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.
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 specification
Developing, maintaining, and enhancing Apex New Zealand’s modern data platform including:
o Creating reusable data models for financial reporting.
o Writing and maintaining reports and dashboards.
o Ensuring security and reliability of the data, creating automated tests and working with stakeholders to ensure data accuracy.
o 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, Power BI dashboards to visualize complex datasets, ensuring high performance and user-friendly interfaces.
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.
Effective time management, ability to manage various projects, stakeholders and pivot to priority incidents as required.
Skills Required:
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.
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.
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
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.
Top Skills
What We Do
We are a single-source financial solutions provider dedicated to driving positive change while supporting the growth and ambitions of asset managers, allocators, financial institutions, and family offices around the world.
Established in Bermuda in 2003, we have continually disrupted the industry through our investment in innovation and talent. Today, we set the pace in fund and 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.
As a pioneering data and fintech-enabled company, we are a disruptor driving digital tools into fund and asset servicing. However, our vision to drive positive change extends beyond the industry. The Apex Foundation, a not-for-profit entity, is our passionate commitment to empower sustainable change
