Lead Funds Data Architect

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) 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.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Architecture

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

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.