Data Architect (Sql Server/Snowflake) - Remote
Role details
Job location
Tech stack
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