Data Architect (SQL Server/Snowflake) - Remote

We are seeking a highly skilled Data Architect with strong expertise in the Wealth / Asset Management domain, specializing in SQL Server and Snowflake-based data platforms. The role involves designing, modernizing, and governing enterprise data architectures that support front-to-back wealth management processes, including client onboarding, portfolio management, regulatory reporting, and analytics., Data Architecture & Design

• Define and implement enterprise data architecture for wealth management platforms

Design scalable, secure, and high-performance data models for transactional and analytical workloads.

• Lead cloud data platform architecture using Snowflake and hybrid/on-premise SQL Server environments.

Data Engineering & Platform Modernization

• Architect and oversee migration from legacy data platforms to Snowflake.

• Drive data integration strategies across CRM, portfolio systems, market data providers, and regulatory systems.

• Wealth Management Domain Alignment

Align data models with key domain concepts:

• Client onboarding (KYC/AML)

• Portfolio and asset management

• Trading and execution data

• Regulatory reporting (e.g., MiFID II, CRS, FATCA)

Support business use cases such as:

• Client reporting and analytics

• Risk and performance analysis

• Pricing and valuation

• Compliance monitoring

Governance, Security & Compliance

• Define and enforce data governance, lineage, and cataloging frameworks.

• Ensure compliance with financial regulations and data privacy requirements.

• Implement data quality controls, auditing, and reconciliation mechanisms.

Do you have experience in Tableau?, * SQL Server (T-SQL, performance tuning, SSIS/SSAS/SSRS)

• Snowflake (data modeling, Snowpipe, streams, tasks)

Solid expertise in:

• Data warehousing (Kimball, Data Vault, etc.)

• ETL/ELT pipelines and data orchestration tools

• Cloud platforms (Azure, AWS, or GCP)

Experience with:

• Data integration (APIs, messaging, batch/real-time pipelines)

• BI/reporting tools (e.g., Power BI, Tableau)

Knowledge of:

• Data governance frameworks and metadata management tools

• Domain Expertise

• Proven experience in Wealth Management / Asset Management / Private Banking.

Understanding of:

• Investment lifecycle and portfolio structures

• Financial instruments (equities, fixed income, derivatives)

• Regulatory and compliance reporting

Soft Skills

• Strong analytical and problem-solving capabilities

• Excellent communication with both technical and business stakeholders

• Ability to lead architecture discussions and influence decisions

• Structured, detail-oriented, and proactive mindset, data architecture,sql,snowflake,wealth management

• `Retribución Flexible´ Program: (Meals, Kinder Garden, Transport, online English lessons, Heath Care Plan…)

• Free access to several training platforms

• Professional stability and career plans

• UST also, compensates referrals from which you could benefit when you refer professionals.

• The option to pick between 12 or 14 payments along the year.

• Real Work Life Balance measures (flexibility, WFH or remote work policy, compacted hours during summertime…)

• UST Club Platform discounts and gym Access discounts

If you would like to know more, do not hesitate to apply and we'll get in touch to fill you in details. UST is waiting for you!

In UST we are committed to equal opportunities in our selection processes and do not discriminate based on race, gender, disability, age, religion, sexual orientation or nationality. We have a special commitment to Disability & Inclusion, so we are interested in hiring people with disability certificate.

We are still looking for the very Top Talent…and we would be delighted if you were to join our team! More in details, UST is a multinational company based in North America, certified as a Top Employer and Great Place to Work company with over 35.000 employees all over the world and presence in more than 35 countries. We are leaders on digital technology services, and we provide large-scale technologic solutions to big companies., UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact-touching billions of lives in the process.