Data Architect (Sql Server/Snowflake) - Remote

UST España
Ribamontán al Mar, Spain
2 days ago

Role details

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

Job location

Remote
Ribamontán al Mar, Spain

Tech stack

API
Amazon Web Services (AWS)
Data analysis
Azure
Cloud Computing
Data Architecture
Information Engineering
Data Governance
Data Integration
ETL
Data Vault Modeling
Data Warehousing
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
T-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!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 & 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., Mi FID 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) 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 ¿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 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.

Requirements

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) 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 ¿What can we offer?

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.

About the company

Ribamontán al Mar, Cantabria, España 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 ****** 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