Data Architect (SQL Server/Snowflake) - Remote - UST España & Latam
6 days ago
Tarragona
🚀 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. 🔎 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., 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) 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.
60 Carrer del Lleó, 43004, Tarragona
