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.
What we can offer you
We work hard to have a positive financial and social impact on the communities we serve. In turn, we put our employees first and provide the best-in-class benefits they need to be well, live well and save well.
By joining Citi Belfast, you will not only be part of a business casual workplace with a hybrid working model (up to 2 days working at home per week), but also receive a competitive base salary (which is annually reviewed), and enjoy a whole host of additional benefits such as:
Generous holiday allowance starting at 27 days plus bank holidays; increasing with tenure
A discretional 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
Alongside these benefits Citi is committed to ensuring our workplace is where everyone feels comfortable coming to work as their whole self every day. We want the best talent around the world to be energized to join us, motivated to stay, and empowered to thrive.
Sounds like Citi has everything you need? Then apply to discover the true extent of your capabilities.
------------------------------------------------------
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.
Skills Required
- 12+ years of experience in data analysis, data architecture, or data warehousing roles
- 5+ years of direct experience within the financial services industry with deep expertise in the Funds business (asset management, mutual funds, hedge funds)
- Proven experience with Fund accounting, Fund Administration, ETFs, IBOR, ABOR, and financial reporting
- 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 technologies (Hadoop, Spark, Kafka)
- In-depth knowledge of regulatory reporting (SEC, FCA, UCITS) and related data implications
- 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
- Outstanding analytical, problem-solving, communication, leadership, mentoring, and stakeholder engagement skills
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
