Senior Data Engineer in Worcester

At our client, we provide talented and dynamic individuals with the opportunity to build a rewarding career. We’re an ambitious company, committed to building long-term partnerships with our clients and delivering operational excellence at every stage of their fund’s lifecycle. Our culture is what makes us a standout place to work. Our people are at the heart of our business: putting clients first; delivering service excellence; working as one team; building lasting connections and embodying our values and purpose. Join our journey and discover what makes us the bright alternative.

About the role:

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 Our client and client platforms. It ensures solutions are scalable, controlled, auditable, and aligned to Our client’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:

• Reporting & Data Architecture Ownership
  • 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.
• Full Delivery Lifecycle Oversight (Dev → SIT → UAT → Prod)
  • Provide technical oversight of the full reporting development lifecycle, including design, build, validation and controlled promotion through: Development → SIT → UAT → Production (PrD).
  • 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.
• eFront Invest Data Model Authority
  • Serve as subject-matter expert in eFront Invest backend data structures, including fund/entity hierarchies, capital activity, allocations, valuation and performance.
  • Define structured approaches to accessing and modelling eFront data for reporting, downstream datasets, and client consumption.
  • Provide technical guidance during new client onboarding, complex fund launches, and major reporting changes where data integrity is critical.
  • Influence platform configuration decisions where they materially impact reporting outcomes, data integrity, or auditability.
• Two-Way Client Data Exchanges & Integration Design
  • Define technical patterns for two-way integrations between Our client and client platforms, including: Outbound reporting/data delivery (e.g., scheduled extracts, datasets, dashboards) Inbound client data ingestion (e.g., client reference data, portfolio data, enrichment datasets).
  • Support secure data exchange approaches via: SFTP feeds and scheduled extracts/uploads API-based delivery and ingestion where applicable DDS / data platform outputs for structured client consumption.
  • Establish reconciliation, completeness checks, validation controls, and exception handling standards for both inbound and outbound data flows.
  • Work closely with Integration Engineers to ensure interfaces are resilient, monitored, and aligned to enterprise integration standards.
• 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 Our client’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.