Overview
The Data Modeler will be responsible for designing, governing, and optimizing the Enterprise Data Warehouse (EDW) architecture to support strategic data initiatives. The role ensures efficient reuse of data across the organization by establishing common taxonomy, data integrity, lineage, and compliance across multiple domains (Product Master, Performance & Attribution, Security & Reference Data). It requires a hands‑on approach with strong engagement across business and engineering teams. Client: Our client is a leading global investment company undergoing a major transformation to modernize its technology landscape. They are currently replacing a large portion of their legacy systems and building an advanced data marketplace to aggregate and analyze diverse datasets from multiple sources, including stock exchanges, news feeds, broker data, and internal quantitative models. Project Overview:
- Define and maintain logical and physical data models for the EDW.
- Establish data standards, taxonomy, and governance aligned with Group Data Architecture principles.
- Drive integration of strategic data sources (e.g., State Street ADP) into the EDW to provide trusted, curated data.
- Implement data governance and compliance through lineage and metadata management tools.
- Collaborate with Data Solutions, Engineering, and Business teams in an Agile environment.
- Facilitate workshops with stakeholders to validate requirements and promote EDW adoption.
- Continuously optimize EDW design for performance, scalability, and resilience.
- Advanced skills in data modeling (conceptual, logical, physical).
- Expertise in entity‑relationship modeling, dimensional modeling, and data‑warehousing principles including denormalization.
- Strong proficiency in SQL.
- Knowledge of ETL/ELT design principles.
- Understanding of financial instruments, fund structures, product/account management, and performance attribution.
- Ability to contribute data solutions across asset management areas including risk analytics, valuations, and liquidity reporting.
- Strong stakeholder management and communication skills.
- Ability to operate effectively within a matrix organization while managing multiple priorities.
- Analytical mindset with strong attention to detail and problem‑solving capabilities.
- Familiarity with regulatory data requirements such as Solvency II, EMIR, and ESG reporting.
- Familiarity with cloud/hybrid architectures; Snowflake migration experience.
- Experience with ER/Studio for data modeling and engineering.
- Familiarity with Solidatus for lineage and metadata automation.
- Knowledge of Jira and Confluence for release management and documentation.
- Exposure to State Street / Charles River systems (ADP, CRIMS).
- Degree in Computer Science, Data Science, or a related discipline.
- Professional certifications in Data Management or Architecture (e.g., CDMP, TOGAF).
✨ Our intelligent job search engine discovered this job and republished it for your convenience.
Please be aware that the job information may be incorrect or incomplete. The job announcement remains the property of its original publisher. To view the original job and its full details, please visit the job's URL on the owner’s page.
Please clearly mention that you have heard of this job opportunity on https://ijob.am.
