Data Architect

UST is searching for a Data Architect who will design and govern enterprise data architecture spanning the operational SQL Server core, cloud-native data stores on AWS, and modern analytics platforms including Databricks.

The opportunity:

• Define the data platform strategy that supports the evolution from client installed deployments to a centralized, multi-tenant SaaS model including data isolation, partitioning, and residency patterns for regulated insurance data.

• Architect data ingestion pipelines that consolidate data from diverse client environments (SQL Server, COBOL flat files, network-share repositories) into unified analytics-ready stores

• Own data quality frameworks: define validation rules, lineage tracking, and observability tooling for all data pipelines

• Expert knowledge of schema design, medallion architecture (Bronze/Silver/Gold), and data contract standards for central data lakes and analytical platform

• Professional experience building AI data platforms ensuring training datasets, feature stores, and inference pipelines are governed, reproducible, and audit-ready

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What you need:

• 12-16 years of experience

• Operational Data Stack

• SQL Server / T-SQL COBOL Flat Files Dapper / ORM C / .NET 8 ASP.NET Core APIs

• Cloud & Analytics Platform

• AWS (S3, Glue, Athena, RDS) Databricks / Apache Spark Amazon Bedrock Delta Lake AWS IAM / Lake Formation

• Data Engineering & Governance

• ETL / ELT Pipeline Design Medallion Architecture Data Catalog & Lineage Data Governance Frameworks BI / Semantic Layers

Do you have experience in T-SQL?

3.73.7 out of 5 stars Ontario, CA Remote $139,000 - $174,000 a year, Pulled from the full job description

• AD&D insurance
• Health insurance
• Paid sick time
• Paid jury duty
• Bereavement leave
• Life insurance
• Paid holidays, Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below., Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), paid holidays, and are eligible for paid bereavement leave and jury duty. They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year). They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Part-time regular and temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All Canadian employees who work in a province, territory or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws., Compensation range: $139,000.00 to $174,000.00 per year

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live. With us, you'll create a boundless impact that transforms your career-and the lives of people across the world., We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions., UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact-touching billions of lives in the process.