Snowflake & Aladdin Data Architect

Job Responsibilities/Objectives

You will be responsible for re-designing their Snowflake architecture for Aladdin to date. This ask covers some core non-Aladdin datasets they are bringing in and how these could be onboarded / modelled / mapped into this architecture.

In essence it involves the design of a new import database into the bronze layer of their medallion architecture for a new fund launch. Holdings/reference data differs in structure to Aladdin so need to determine how to land and join it to core Aladdin datasets.

They are more interested in data architecture and asset management data domain experience vs. Aladdin although any experience working with Aladdin data would be a bonus.

Key Tasks & Skills

• Bronze Layer Design & Build: Design the schema and ingestion approach for the Import Database in the Bronze layer, in full alignment with existing design principles. Ensure all data is landed in Bronze in its raw, source-aligned form, with no business transformations, enrichment, or remodelling. Each source must have a clearly defined ingestion contract covering transport mechanism, delivery cadence, schema, versioning, and change indicators. Select the appropriate standard ingestion pattern (database-sourced, API-sourced, file-based, or stream/event-based) that best matches the PMOF data source's transport characteristics and implement a Source Data Contract that conforms to the rules of that pattern.
• XREF & Silver Integration Design: Design the cross-referencing strategy to enable Import Database datasets to be joined to existing Silver layer datasets (e.g., Security, Portfolio, Benchmark). Define and document how entities (holdings, reference data) will be matched and linked to ADC/Aladdin entities, including match rules, confidence scores, and conflict resolution.
• Architectural Diagrams & Documentation: Produce clear, maintainable architectural diagrams showing: Schema diagrams for the new import database, XREF integration patterns and entity relationship mappings, Lineage diagrams showing traceability back to source, Documentation for Technical Architecture Board submissions.

Application Instructions

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer: Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies. Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally.