Data Architect

ABOUT US
tms unites technology, marketing, and sourcing to drive transformational change for the world's leading brands. With 1,200+ employees across 26 countries, we offer an impressive range of solutions - from inspiration and innovation to category management and delivery.
Operating as a creative agency, a strategic consultancy, a sourcing business, and a technology provider, we engage with over 110 million customers every single day for our clients, including Starbucks, T-Mobile, O2, McDonald's, and adidas.
Most importantly, we're a place where you can achieve great things, and be recognized as the best.
WHAT MATTERS THE MOST
Breakthrough, business-driving ideas come from extraordinary people with the freedom to be their most authentic selves at work. Authenticity and diversity are critical elements of our business. They can only be realized when we create access and equity for all. We foster a culture of inclusion and belonging and aspire to be ever-evolving.
tms is a place where brilliant people are better together. If you want your ideas to be heard and to contribute to a culture of inclusion and authenticity, bring us your voice! Visit us at tmsw.com.
WHY WE THINK YOU WILL LOVE THIS ROLE
As a Data Architect, you will play a pivotal role in shaping the future of our data architecture and infrastructure. You will have the opportunity to design and implement scalable data solutions that drive business insights and decision-making. With hands-on experience in data warehouse design, cloud technologies, and database management, this role provides an exciting environment for you to grow and lead. You'll collaborate with cross-functional teams, tackle complex data challenges, and enhance data systems to ensure performance, availability, and security. If you're passionate about building innovative data solutions and working with cutting-edge technologies, this is the role for you!
WHAT YOU WILL BRING TO THE ORGANIZATION
You bring a strategic mindset and strong technical expertise to architect and optimize complex data systems. Your experience in designing scalable data warehouses, building ETL processes, and integrating cloud services will ensure seamless data flow and enhanced analytics capabilities. Your problem-solving skills and ability to troubleshoot and optimize databases will be essential in maintaining high-performing systems. Your expertise in Oracle ERP integrations and cloud platforms like Azure ensures that data architecture aligns with organizational goals and operational needs. You also have excellent communication skills, enabling you to collaborate effectively with analysts, developers, and other stakeholders across teams.
You bring deep expertise in database design, performance tuning, and optimization across SQL Server and Oracle. Your proficiency with Azure cloud services and modern data platforms, such as Snowflake and Databricks, will drive innovation in our data infrastructure. You are highly skilled in developing and maintaining ETL processes and OLAP cubes, enabling efficient data movement and reporting. Your solid experience with Oracle ERP integrations will ensure seamless data flow across systems. Additionally, your scripting and automation skills in Python, PowerShell, or PL/SQL will enable the efficient operation and management of data processes. You're a problem-solver who thrives on challenges and takes ownership of complex technical tasks.
SKILLS AND EXPERIENCE WE WOULD LIKE YOU TO HAVE

• Requires 5 or more years of experience in data warehouse design, implementation, and maintenance.
• Strong proficiency in SQL Server and Oracle databases, including query writing, performance tuning, and indexing.
• Experience with Oracle ERP databases, including data extraction, integration, and troubleshooting.
• Expertise with ETL tools such as SSIS, Informatica, or Azure Data Factory.
• Proficiency in scripting languages such as Python, PowerShell, or PL/SQL for automation and database administration.
• Hands-on experience with Azure cloud services, including Azure SQL, Synapse Analytics, Data Lake Storage, and Databricks.
• Familiarity with OLAP cube design and tools such as SSAS or Oracle OLAP.
• Strong analytical and problem-solving skills with the ability to work independently.

Starting salary between $135,000-$150,000
TOTAL REWARDS
Our total rewards philosophy integrates programs for compensation, benefits, recognition, learning and development, corporate culture, corporate citizenship and work-life balance. While individual program components may differ by country, some things remain constant:

• Our commitment to rewarding results
• Opportunities to work with talented and driven individuals at every level of our company who respect each other, treat each other fairly and hold one another accountable for our customers'-and our company's-success

There's more ...
Generous medical, dental, vision and other great benefits
Paid parental and medical leave programs
401(k) with a company match component and profit sharing
15 days of paid time off plus company holidays
Hybrid work model
Tuition reimbursement and student loan repayment assistance
Inclusive employee resource groups
EQUAL OPPORTUNITY EMPLOYER
We are an equal opportunity employer, and we value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
RECRUITING AGENCIES
tms does not accept agency resumes submitted by third-party vendors unless a valid agreement has been signed and the tms Talent Acquisition Team has granted authorization for submissions for a specified position. Please do not submit or forward resumes to our site, tms employees, or any other company location. tms is not responsible for any fees related to unsolicited resumes.
#LI-Hybrid
Nearest Major Market: Seattle