Data Architect (Sql Server/Snowflake) - Remote

UST España
Marín, Spain
12 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Data Analysis Microsoft Azure Cloud Computing Data Architecture Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Vault Modeling Data Warehousing
+16 more
Digital Technology Internetworking Meta-Data Management Microsoft SQL Server Performance Tuning Power BI SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Tableau (Software) Transact-SQL Cloud Platform System Snowflake Data Management Tools for Reporting Data Pipelines

Job description

We are still looking for the very Top Talent…and we would be delighted if you were to join our team!Inscríbase ahora, lea los detalles del trabajo desplazándose hacia abajo. Verifique que posee las habilidades necesarias antes de enviar una solicitud.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 ** 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.What we look for?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.Key Responsibilities:Data Architecture & DesignDefine and implement enterprise data architecture for wealth management platformsDesign 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 ModernizationArchitect 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 AlignmentAlign data models with key domain concepts:Client onboarding (KYC/AML)Portfolio and asset managementTrading and execution dataRegulatory reporting (e.g., MiFID II, CRS, FATCA)Support business use cases such as:Client reporting and analyticsRisk and performance analysisPricing and valuationCompliance monitoringGovernance, Security & ComplianceDefine 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 toolsCloud 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 toolsDomain ExpertiseProven experience in Wealth Management / Asset Management / Private Banking.Understanding of:Investment lifecycle and portfolio structuresFinancial instruments (equities, fixed income, derivatives)Regulatory and compliance reportingSoft SkillsStrong analytical and problem-solving capabilitiesExcellent communication with both technical and business stakeholdersAbility to lead architecture discussions and influence decisionsStructured, detail-oriented, and proactive mindset¿What can we offer?23 days of Annual Leave plus the 24th and 31st of December as discretionary days!Numerous benefits (Heath Care Plan, Internet Connectivity, Life and Accident Insurances).`Retribución Flexible ? Program: (Meals, Kinder Garden, Transport, online English lessons, Heath Care Plan…)Free access to several training platformsProfessional stability and career plansUST 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 discountsIf 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. xbhjioeHay opciones de teletrabajo/trabajo desde casa disponibles para este puesto.

Requirements

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

Benefits & conditions

23 days of Annual Leave plus the 24th and 31st of December as discretionary days! Numerous benefits (Heath Care Plan, Internet Connectivity, Life and Accident Insurances). `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. xbhjioe Hay opciones de teletrabajo/trabajo desde casa disponibles para este puesto.

About the company

Marín, Pontevedra, España

We are still looking for the very Top Talent…and we would be delighted if you were to join our team! Inscríbase ahora, lea los detalles del trabajo desplazándose hacia abajo. Verifique que posee las habilidades necesarias antes de enviar una solicitud. 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 ** 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. What we look for?

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.buscojobs.com.es

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · WWC Europe 2026

3:14 min

Structuring career paths and localized data architectures

Ulrich Wurstbauer +1 · LIVE

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · WWC Europe 2026

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

Videos

See all

Related articles

See all