Data Architect (SQL Server/Snowflake) - Remote

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.

Mandatory requirements:

Strong experience in:

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

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

`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. Solicitar ahora Guardar trabajo Automatically Get Matched to Data Architect Jobs Let our AI agent search and match you to the best jobs from across the web Try it now

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.