Retail Data Architect

Retail Data Architect Data Architect II

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 create a boundless impact that transforms your career-and the lives of people across the world.

Visit us at

The Retail Data Architect will lead the modernization of legacy transactional database systems, guiding their upgrade, migration, and eventual decommissioning. This role focuses on designing resilient, secure, and scalable architectures that support high-volume transactional workloads while ensuring compliance with organizational standards and governance policies.

• Plan and guide the upgrade, migration, and decommissioning of legacy transactional databases.
• Ensure alignment with organizational policies for data retention, archiving, and compliance.
• Create comprehensive documentation of database architecture, data models, and operational processes.
• Define and promote best practices for database development, maintenance, and operations.
• Design and oversee integration of transactional databases with enterprise systems and applications.
• Define real-time data ingestion and consumption patterns to ensure seamless and consistent data flow.
• Establish and enforce governance policies for transactional data, including quality, retention, and archiving.
• Implement robust security measures including access controls, encryption, and auditing.
• Identify and resolve performance bottlenecks in transactional systems.
• Develop strategies for scaling databases using techniques such as sharding, clustering, and connection pooling.
• Evaluate and select appropriate relational database technologies (e.g., MySQL, Oracle, Postgre
  
  SQL) based on application needs.
• Design resilient architectures with high availability, disaster recovery, and data replication capabilities.
• Design conceptual, logical, and physical data models for transactional systems, ensuring normalization and referential integrity.
• Optimize schema design for performance, including indexing strategies, data types, and selective denormalization for read-heavy workloads.

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

• 10+ years of experience
• Proven experience in legacy system modernization and transactional database architecture.
• Deep understanding of ACID principles and relational database technologies.
• Strong knowledge of performance tuning, scalability strategies, and secure data practices.
• Experience with real-time data integration and enterprise system interoperability.
• Excellent documentation and communication skills.

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.

Role

Location:

Washington

Compensation Range: $161,000-$242,000

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), 10 paid holidays, and are eligible for paid bereavement leave and jury duty. They are eligible to participate in 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 the following Company-paid Employee Only benefits: basic life insurance, accidental death and disability insurance, and short- and long-term disability benefits.

Regular employees may purchase…