Principal Reporting and Data Engineer

The Senior Manager – Principal Reporting & Data Engineer is the senior technical authority for complex client reporting and structured data architecture derived from eFront Invest. This role defines the standards, patterns, and technical approach for extracting, modelling, and delivering high-complexity reporting outputs and two-way client data exchanges between Aztec and client platforms. It ensures solutions are scalable, controlled, auditable, and aligned to Aztec’s data governance and ISAE control environment. Operating on the technical career track, the role provides domain technical leadership without direct line management responsibility, influencing delivery quality through design oversight, standards, lifecycle governance, and mentoring.

Key Responsibilities:

• Define and maintain design standards and architectural principles for complex reporting and structured data extraction from eFront Invest.
• Act as design authority for high-complexity and high-risk reporting requirements, ensuring solutions are robust, performant, and reusable.
• Establish reusable reporting frameworks, extraction patterns, and transformation approaches to reduce bespoke build and improve scalability.
• Drive performance optimisation of queries and reporting pipelines, ensuring predictable and efficient execution in production.
• Provide technical oversight of the full reporting development lifecycle, including design, build, validation and controlled promotion through:

• Define test strategies, test data requirements, and evidence standards for SIT/UAT cycles, ensuring audit-ready documentation is retained.
• Coordinate with operational stakeholders to ensure release readiness, cutover plans, and controlled deployment/rollback procedures where applicable.

Two-Way Client Data Exchanges & Integration Design

• Define technical patterns for two-way integrations between Aztec and client platforms, including:

• Outbound reporting/data delivery (e.g., scheduled extracts, datasets, dashboards)
• SFTP feeds and scheduled extracts/uploads
• API-based delivery and ingestion where applicable
• DDS / data platform outputs for structured client consumption

Stakeholder & Client Collaboration

• Work in close partnership with Client Facing Teams (CFT) to define reporting requirements, prioritise deliverables, and support client-facing commitments.
• Engage directly with key clients (as required) to validate requirements, explain data structures, confirm mapping decisions, and ensure mutual understanding of deliverables.
• Collaborate across MTS with solution architects, application SMEs/platform owners (eFront and adjacent systems), data engineers, and reporting teams to ensure end-to-end alignment.

Governance, Controls & Audit Readiness

• Ensure reporting designs and outputs comply with Aztec’s ISAE 3402 controls, change governance, and documentation standards.
• Define and enforce version control, peer review, testing evidence, and approval practices for complex reporting logic and data interfaces.
• Act as technical escalation point during audits or control reviews relating to reporting outputs, data extracts, reconciliations, and client exchanges.
• Contribute to control design and remediation where reporting logic, data sourcing, or interfaces present operational risk.

Technical Leadership & Capability Uplift

• Set technical standards for SQL development, naming conventions, and data transformation approaches across the reporting community.
• Mentor and coach reporting engineers and analysts through technical design reviews and best-practice guidance.
• Reduce key-person dependency by improving documentation, reusable components, and repeatable delivery approaches.
• Identify opportunities to standardise recurring client reporting requirements into scalable templates and assets.

Skills, Knowledge & Expertise:

• Deep expertise in eFront Invest data structures, reporting logic, and private markets data semantics.
• Advanced SQL and structured data modelling capability, including performance tuning and scalable query design.
• Strong understanding of private markets fund accounting concepts (capital activity, allocations, valuation/performance, investor reporting).
• Experience designing and supporting two-way client data exchanges and controlled reporting pipelines.
• Strong documentation discipline and ability to operate effectively within audit-controlled environments.
• Strong stakeholder engagement capability, including working with CFTs and directly with clients.

Qualifications & Experience:

• Typically 7–10+ years’ experience in reporting, data engineering, or financial systems roles within private markets, fund administration, or financial services.
• Proven track record delivering complex client reporting and structured data outputs, including SIT/UAT/Prod release discipline.
• Degree in Finance, Data, Information Systems, Engineering, Mathematics, or equivalent professional experience.

This role is a key technical leadership position within Markets Technology Services. It offers progression into broader platform architecture or technology leadership pathways, with scope to expand technical ownership across additional data domains and enterprise client delivery services as Aztec scales its reporting automation and data-as-a-service capabilities. Aztec will provide the training, both in-house for relevant technical knowledge and also professional qualifications to enhance your professional development. You will need to be quick to learn new systems and great with people, as close working relationships between our colleagues and clients is at the heart of what we do.