Retail Data Architect

UST; Issaquah (WA); On-site; USD 140,000 - 210,000; Full time

Benefits offered by this job

10 days of paid vacation

12 paid holidays

401(k) retirement plan with employer matching

Health, dental, and vision insurance

Company-paid life insurance

Job summary

UST is seeking an experienced Retail Data Architect in Washington to advance enterprise data architecture and build modern solutions in the retail space. The ideal candidate will utilize their expertise in OLTP and OLAP models to optimize and create scalable web application data models.

This role offers a compensation range of $140,000-$210,000 along with significant benefits including health insurance and a 401(k) retirement plan.

Qualifications

• Strong hands-on experience with Erwin Data Modeling tools.
• Expertise in designing OLTP and OLAP data models.
• Strong understanding of data governance and metadata management.

Responsibilities

• Design and develop enterprise data models using Erwin for OLTP and OLAP.
• Lead data modeling efforts for modernization initiatives.
• Define and implement data governance and management best practices.

Skills

cloud data architecture

web application data modeling

data governance

metadata management

Erwin Data Modeling tools

GCP database technologies

retail domain knowledge

Tools

DB2

Cloud SQL

AlloyDB

BigQuery

Job description

Who We Are

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.

Role Description

Retail Data Architect

Data Architect I

Overview

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.

Visit us at UST.com.

You Are

We are looking for an experienced Retail Data Architect with strong expertise in modern data architecture, retail domain knowledge, and cloud-native database technologies. The ideal candidate will play a key role in rearchitecting and modernizing enterprise business applications and data models for scalable, high-performance platforms on GCP.

The Opportunity

• Design and develop enterprise data models using Erwin for both OLTP and OLAP environments, including support for JSON and mixed data types.
• Create and optimize modernized web application data models focused on scalability, performance, and efficient application processing.
• Reverse engineer existing data models and transform them into future-state architectures aligned with business and technical requirements.
• Lead data modeling efforts for modernization and re-architecture initiatives across enterprise applications.
• Define and implement data governance and data management best practices.
• Evaluate and recommend appropriate database technologies on GCP for structured and unstructured datasets.
• Work across multiple database technologies including DB2, Cloud SQL, AlloyDB, BigQuery, and related platforms.

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

• Strong hands-on experience with Erwin Data Modeling tools.
• Expertise in designing OLTP and OLAP data models, including JSON-based and complex data structures.
• Experience building high-performance data models for modern web applications.
• Strong understanding of data governance, metadata management, and data management principles.
• Experience with GCP database selection strategies and cloud-native architecture.
• Hands-on experience with technologies such as DB2, Cloud SQL, AlloyDB, BigQuery, and other modern database platforms.
• Strong retail domain experience with understanding of retail workflows, business processes, and data dependencies.
• Proven experience in rearchitecting legacy application data models for modern technology stacks.
• Ability to reverse engineer and modernize complex enterprise data models.
• Strong communication and leadership skills with experience working in onsite-offshore delivery models.
• Self-driven, adaptable, and capable of navigating ambiguity and changing priorities.
• Solid understanding of Domain Driven Design patterns and principles.
• Preferred Qualifications:
  • Experience with enterprise modernization and digital transformation initiatives.
  • Prior experience leading data architecture discussions with business and technical stakeholders.
  • Exposure to cloud-native application architectures and distributed systems.

Compensation and Location

Role Location: Washington

Compensation Range: $140,000-$210,000

Benefits

Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, 6 days of paid sick leave per year (pro-rated for new hires), 10 paid holidays, and are eligible for paid bereavement leave and jury duty. They are eligible for the Company’s 401(k) Retirement Plan with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance, as well as Company-paid life insurance, accidental death and disability insurance, and short- and long-term disability benefits. Additional voluntary benefits and health accounts (HSA/FSAs) may be available. Benefits offerings vary in Puerto Rico. Part-time and full-time temporary employees have varying leave and 401(k) eligibility, with some variations by role and location. All US employees receive regard to applicable state or local sick leave laws where more generous.

What We Believe

We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity to foster a people-first, human-centric culture that prioritizes sustainable solutions and keeps our people and clients at the forefront of all decisions.

Equal Employment Opportunity Statement

UST is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other applicable characteristics protected by law. We will consider qualified applicants with arrest or conviction records in accordance with state and local laws and “fair chance” ordinances. UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

#UST

#CB

Skills

cloud data architecture, web application data modeling, data governance, metadata management