Job Information
UST Global Inc Retail Data Architect in Bellevue, Washington
Role description Retail Data Architect Data Architect II 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. 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: 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. The opportunity: * 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, PostgreSQL) 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. What you need: * 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 Benefits Full-time, regular empl