Lead Funds Data Architect

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