Lead Funds Data Architect

Citigroup Inc.; Belfast City District; On-site; GBP 110,000 - 150,000; Full time

Benefits offered by this job

Private medical insurance

Pension plan

Annual bonus

Learning and development resources

Job summary

Citigroup Inc. is seeking a Lead Funds Data Architect to bridge business needs with technical funds data solutions. You will design data strategies and architectures for Fund accounting, Fund Administration, ETFs, IBOR, and ABOR, ensuring governance and regulatory alignment.

You will lead data modeling, lineage, and metadata strategies, collaborate with engineering teams, and enable reporting for regulatory filings and client statements in a complex financial data environment.

Qualifications

• 12+ years of experience in data analysis, data architecture, or data warehousing roles.
• 5+ years in financial services, Funds domain expertise (asset management, ETFs, fund accounting).
• Proven experience with Fund accounting, Fund Administration, ETFs, IBOR, ABOR, and financial reporting.

Responsibilities

• Define and articulate data strategy and architectural vision for the Funds business.
• Apply deep knowledge of Fund accounting, Fund Administration, ETFs, IBOR, and ABOR to design efficient data models and flows.
• Architect robust, scalable data solutions including data warehouses, data lakes, and integration patterns.
• Champion data governance, ensuring data quality and regulatory compliance across Funds data.
• Establish and maintain data lineage and metadata management strategies for transparency and auditability.
• Lead data modeling efforts with conceptual, logical, and physical models focused on reusability.
• Conduct detailed data analysis and translate business requirements into technical specs.
• Provide architectural oversight during implementation and resolve data-related challenges.
• Design data structures for reporting, regulatory filings, and client statements.
• Evaluate new data technologies to enhance Funds data capabilities.

Skills

Data governance

Data lineage

Data modeling

Leadership

Stakeholder engagement

Analytical skills

Tools

ER/Studio

Erwin

SQL Server

Oracle

Snowflake

Databricks

Hadoop

Spark

Kafka

Job description

The Lead Funds Data Architect will be a pivotal member of our team, responsible for bridging the gap between business needs and technical solutions within the Funds domain.

This individual will lead the design, development, and implementation of data strategies and architectures that support Fund accounting, Fund Administration, ETFs, IBOR (Investment Book of Record), ABOR (Accounting Book of Record), and various regulatory and client reporting functions.

A profound understanding of data governance, data lineage, data modeling, and core data concepts specific to the investment and funds industry is paramount.

What you’ll do

• Data Strategy & Vision: Define and articulate the data strategy and architectural vision for the Funds business, ensuring alignment with enterprise data initiatives and regulatory requirements.
• Domain Expertise Application: Apply deep knowledge of Fund accounting, Fund Administration processes, ETF Operations, IBOR, and ABOR to design highly efficient and accurate data models and data flows.
• Data Architecture Design: Architect robust, scalable, and secure data solutions, including logical and physical data models, data warehousing, data lakes, and data integration patterns tailored for complex financial data.
• Data Governance & Quality: Champion and implement best practices for data governance, ensuring high data quality, integrity, and adherence to internal policies and external regulations across all Funds data.
• Data Lineage & Metadata Management: Establish and maintain comprehensive data lineage documentation and metadata management strategies to ensure transparency, auditability, and understanding of critical data assets within the Funds business.
• Data Modeling Leadership: Lead data modeling efforts, developing conceptual, logical, and physical data models that support current and future business needs, with a strong focus on reusability and extensibility for Funds data.
• Analysis & Requirements Gathering: Conduct detailed data analysis, gather business requirements from stakeholders in Fund accounting, operations, and reporting, and translate them into precise technical specifications.
• Solution Implementation Support: Collaborate closely with development and engineering teams during the implementation phase, providing architectural oversight and resolving data-related technical challenges.
• Reporting & Analytics Enablement: Design data structures and access patterns that enable efficient and accurate generation of various internal and external reports, including regulatory filings and client statements.
• Technology Evaluation: Evaluate and recommend new data technologies, tools, and methodologies that enhance data capabilities and efficiency within the Funds business.

What we’ll need from you

Experience

• 12+ years of experience in data analysis, data architecture, or data warehousing roles.
• 5+ years of direct experience within the financial services industry, specifically with deep expertise in the Funds business (e.g., asset management, mutual funds, hedge funds).
• Proven experience with Fund accounting, Fund Administration, ETFs, IBOR, ABOR, and financial reporting.

Technical Skills

• Expertise in data modeling tools and techniques (e.g., ER/Studio, Erwin).
• Strong SQL and database proficiency (SQL Server, Oracle, Snowflake, Databricks).
• Experience with data integration (ETL/ELT, APIs).
• Familiarity with cloud data platforms (AWS, Azure, GCP) and big data (Hadoop, Spark, Kafka) is a plus.

Domain Knowledge

• Exceptional understanding of the Funds business lifecycle, financial instruments, market data, and investment operations.
• In-depth knowledge of regulatory reporting (SEC, FCA, UCITS) and data implications.
• Core Data Concepts: Demonstrated experience in Data Governance, Data Lineage, and Data Modeling (conceptual, logical, physical).
• Comprehensive understanding of Master Data Management, Reference Data, Transactional Data, and Metadata.

Soft Skills

• Outstanding analytical, problem-solving, and communication skills.
• Strong leadership, mentoring, and stakeholder engagement abilities.
• Proactive and adaptable in a dynamic environment.

What we can offer you

• Generous holiday allowance starting at 27 days plus bank holidays; increasing with tenure.
• A discretionary annual performance related bonus.
• Private medical insurance packages to suit your personal circumstances.
• Employee Assistance Program.
• Pension Plan.
• Paid Parental Leave.
• Special discounts for employees, family, and friends.
• Access to an array of learning and development resources.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.