Full Job Description
We are seeking a Data Solutions Designer to join our Data, Analytics & AI (DNA) team in shaping data-driven solutions that enable investment insights, operational efficiency, and client reporting across our asset management business.
In this role, you will help design and guide the implementation of end-to-end data flows—from source systems through to final consumption by business intelligence platforms, data science models, and third-party consumers. This includes contributing to platform architecture, data modeling, and solution review across a modern stack. You’ll collaborate with data engineers, analysts, quants, and business stakeholders to ensure that data solutions are well-architected, secure, scalable, and aligned with the needs of a fast-paced, regulated industry.
This role follows our in‑office work model and requires employees to be onsite four days per week to support collaboration and business needs.
Design End-to-End Data Solutions
• Design robust data solutions supporting business intelligence, data processes, analytics and AI/ML initiatives.
• Develop technical flowcharts, data flow diagrams (DFDs), and system interaction models to visualize and validate proposed data solution designs.
• Define data flows from ingestion through transformation, storage, and delivery—including real-time and batch patterns.
• Ensure solutions support both operational and analytical use cases (e.g. dashboards, APIs, external data delivery).
Collaborate Across Teams
• Partner with data engineering, analytics, and AI teams to evaluate and enhance solution designs.
• Provide guidance on architectural decisions, platform capabilities, and technology choices within our AWS and Snowflake-based ecosystem.
Modeling & Metadata
• Design logical and physical data models to support various levels of reporting and analysis.
• Partner with Data Governance to help promote standards for metadata, documentation, and lineage tracking using tools like Alation, DBT and Tableau Data Catalogs.
Platform & Governance Alignment
• Ensure all designs align with platform standards, data governance policies, and regulatory requirements relevant to asset management.
• Contribute to improving data product delivery patterns, reusability, and performance optimization.
Review & Influence
• Review proposed solution designs and challenge approaches to ensure strategic alignment, maintainability, and fit-for-purpose outcomes.
• Act as a thought partner in refining how we deliver data, analytics, and AI capabilities to the business.
Education
• Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, or a related field (required).
• Master’s degree in Data Analytics, Information Systems, or Financial Engineering (preferred).
• Relevant certifications (e.g. Snowflake, AWS, dbt, TOGAF) are a plus.
Experience
• 8+ years of experience in data architecture, data solution design, or data engineering—preferably within financial services or asset management.
• Strong understanding of data platforms and architecture, including experience with:
• Snowflake for cloud data warehousing
• AWS for cloud services and data pipelines
• dbt for transformation and documentation
• Demonstrated experience designing data flows and models to support BI, reporting, and/or AI/ML use cases.
Skills
• End-to-End Solution Design Thinking - The ability to see the full lifecycle of a solution—from data ingestion, processing, and modeling to delivery and consumption—while aligning it to business goals.
• Ability to work cross-functionally and communicate clearly with both technical and business stakeholders.
• Solid understanding of data governance, quality, privacy, and regulatory considerations in financial environments.
Desirable experience and skills
• Familiarity with investment data domains such as holdings, transactions, benchmarks, risk, or client reporting.
• Experience with data sharing, APIs, or delivering data to external consumers or partners.
• Experience with building DevOps pipelines for Data and/or AI/ML