Data Architect (Sql Server/Snowflake) - Remote

UST España
Ares, 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
Ares, 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
Standard Sql
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

pstrong We are still looking for the very Top Talent...and we would be delighted if you were to join our team!/strong /pp 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./p pstrong What we look for?/strong /pp We are seeking a highly skilled strong Data Architect with strong expertise in the Wealth / Asset Management domain, /strong specializing in strong SQL Server and Snowflake /strong-based data platforms./p p 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./p p? strong Key Responsibilities: /strong /ppstrong Data Architecture Design /strong /pulli Define and implement enterprise data architecture for wealth management platforms /lili Design scalable, secure, and high-performance data models for transactional and analytical workloads./lili Lead cloud data platform architecture using Snowflake and hybrid/on-premise SQL Server environments./li /ulpstrong Data Engineering Platform Modernization /strong /pulli Architect and oversee migration from legacy data platforms to Snowflake./lili Drive data integration strategies across CRM, portfolio systems, market data providers, and regulatory systems./lili Wealth Management Domain Alignment /li /ulpstrong Align data models with key domain concepts: /strong /pulli Client onboarding (KYC/AML) /lili Portfolio and asset management /lili Trading and execution data /lili Regulatory reporting (e.g., MiFID II, CRS, FATCA) /li /ulpstrong Support business use cases such as: /strong /pulli Client reporting and analytics /lili Risk and performance analysis /lili Pricing and valuation /lili Compliance monitoring /li /ulpstrong Governance, Security Compliance /strong /pulli Define and enforce data governance, lineage, and cataloging frameworks./lili Ensure compliance with financial regulations and data privacy requirements./lili Implement data quality controls, auditing, and reconciliation mechanisms./li /ul p strong Mandatory requirements: /strong /ppstrong Strong experience in: /strong /pulli SQL Server (T-SQL, performance tuning, SSIS/SSAS/SSRS) /lili Snowflake (data modeling, Snowpipe, streams, tasks) /li /ulpstrong Solid expertise in: /strong /pulli Data warehousing (Kimball, Data Vault, etc.) /lili ETL/ELT pipelines and data orchestration tools /lili Cloud platforms (Azure, AWS, or GCP) /li /ulpstrong Experience with: /strong /pulli Data integration (APIs, messaging, batch/real-time pipelines) /lili BI/reporting tools (e.g., Power BI, Tableau) /li /ulpstrong Knowledge of: /strong /pulli Data governance frameworks and metadata management tools /lili Domain Expertise /lili Proven experience in Wealth Management / Asset Management / Private Banking./li /ulpstrong Understanding of: /strong /pulli Investment lifecycle and portfolio structures /lili Financial instruments (equities, fixed income, derivatives) /lili Regulatory and compliance reporting /li /ulpstrong Soft Skills /strong /pulli Strong analytical and problem-solving capabilities /lili Excellent communication with both technical and business stakeholders /lili Ability to lead architecture discussions and influence decisions /lili Structured, detail-oriented, and proactive mindset /li /ul p strong¿What can we offer?/strong /pp-?? 23 days of Annual Leave plus the 24th and 31st of December as discretionary days!/pp-?? Numerous benefits (Heath Care Plan, Internet Connectivity, Life and Accident Insurances)./pp- `Retribución Flexible ´ Program: (Meals, Kinder Garden, Transport, online English lessons, Heath Care Plan...) /pp- Free access to several training platforms /pp- Professional stability and career plans /pp- UST also, compensates referrals from which you could benefit when you refer professionals./pp- The option to pick between 12 or 14 payments along the year./pp- Real Work Life Balance measures (flexibility, WFH or remote work policy, compacted hours during summertime...) /pp- UST Club Platform discounts and gym Access discounts /p pstrong 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!/strong /ppstrong 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./strong /p

Requirements

li /ul p strong Mandatory requirements: /strong /ppstrong Strong experience in: /strong /pulli SQL Server (T-SQL, performance tuning, SSIS/SSAS/SSRS) /lili Snowflake (data modeling, Snowpipe, streams, tasks) /li /ulpstrong Solid expertise in: /strong /pulli Data warehousing (Kimball, Data Vault, etc.) /lili ETL/ELT pipelines and data orchestration tools /lili Cloud platforms (Azure, AWS, or GCP) /li /ulpstrong Experience with: /strong /pulli Data integration (APIs, messaging, batch/real-time pipelines) /lili BI/reporting tools (e.g., Power BI, Tableau) /li /ulpstrong Knowledge of: /strong /pulli Data governance frameworks and metadata management tools /lili Domain Expertise /lili Proven experience in Wealth Management / Asset Management / Private Banking. /li /ulpstrong Understanding of: /strong /pulli Investment lifecycle and portfolio structures /lili Financial instruments (equities, fixed income, derivatives) /lili Regulatory and compliance reporting /li /ulpstrong Soft Skills /strong /pulli Strong analytical and problem-solving capabilities /lili Excellent communication with both technical and business stakeholders /lili Ability to lead architecture discussions and influence decisions /lili Structured, detail-oriented, and proactive mindset /li /ul p strong¿What can we offer?

Benefits & conditions

strong /pp-?? 23 days of Annual Leave plus the 24th and 31st of December as discretionary days! /pp-?? Numerous benefits (Heath Care Plan, Internet Connectivity, Life and Accident Insurances). /pp- `Retribución Flexible ´ Program: (Meals, Kinder Garden, Transport, online English lessons, Heath Care Plan...) /pp- Free access to several training platforms /pp- Professional stability and career plans /pp- UST also, compensates referrals from which you could benefit when you refer professionals. /pp- The option to pick between 12 or 14 payments along the year. /pp- Real Work Life Balance measures (flexibility, WFH or remote work policy, compacted hours during summertime...) /pp- UST Club Platform discounts and gym Access discounts /p pstrong 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! /strong /ppstrong 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. /strong /p

About the company

Ares, La Coruña, España pstrong We are still looking for the very Top Talent...and we would be delighted if you were to join our team! /strong /pp 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. /p pstrong What we look for?

Apply for this position