Data Architect

Costco IT is responsible for thetechnical future of Costco Wholesale, the third largest retailer in the world with wholesale operations in fourteen countries. Despite our size and explosive international expansion, we continue to provide a family, employee centric atmosphere in which our employees thrive and succeed.This is an environment unlike anything in the high-tech world and the secret of Costco’s success is its culture. The value Costco puts on its employees is well documented in articles from a variety of publishers including Bloomberg and Forbes. Our employees and our members come FIRST. Costco is well known for its generosity and community service and has won many awards for its philanthropy. The company joins with its employees to take an active role in volunteering by sponsoring many opportunities to help others. Come join the Costco Wholesale IT family. Costco IT is a dynamic, fast-paced environment, working through exciting transformation efforts. We are building the next generation retail environment where you will be surrounded by dedicated and highly professional employees.Data Architects define standards and design the flow of data throughout both the enterprise and the external ecosystem (customers, channels, etc.). They work closely with users, systems designers, and developers on a delivery team. They have an end-to-end vision, to see how a logical design will translate into one or more databases, and recognize how data will flow through the successive stages involved. Data Architects address issues of data migration (including validation, clean-up and mapping), and understand the importance of data dictionaries.The IBMi Replatform program Data Architect will lead the design, development and maintenance of the holistic data architecture in support of the replatform of our core ERP/MRP (Enterprise/Manufacturing Resource Planning) platform, which support our core business functions such as Warehouse, Buying, Supply Chain, and Manufacturing. This person will also develop the strategy to implement the store of curated data, data pipelines, data quality, and data governance. This person will be responsible for cross-platform oversight and governance of the holistic data landscape, which will be developed iteratively through many phases of feature and architectural foundation development.A Data Architect is a knowledgeable leader and is passionate about using data to solve business problems. The right individual will have a vision for the overall data landscape with the ability to develop a technically viable data architecture.If you want to be a part of one of the worldwide BEST companies “to work for”, simply apply and let your career be reimagined.ROLEDevelops a thorough knowledge and understanding of cross ERP/MRP system data flows as well as an enterprise view of Costco’s data landscape.Designs the conceptual and logical data and architecture strategy in collaboration with enterprise and Solution Architects.Develops the enterprise data strategy and architectural standards for maintaining the performance, quality, data security, and compliance of certified data sets.Acts as the subject matter expert in Costco business data domains or subject areas (i.e. Sales, Inventory, Promotions, etc.).Defines certified datasets for data consumption (i.e. Reporting, Data Science, APIs, etc.).Assists in defining data integration, storage, replication, and transformation protocols for the data layer of technical solutions supported by enterprise architecture.Defines and implements data migration strategies and solutions.Builds, optimizes, and maintains logical (curated) data models.Partners with feature and architectural foundation development teams to translate data architectures into physical models and implementations.Works with Data Engineering and Data Platform teams to conduct ongoing performance optimizations in the data model.Maintains detailed documentation (i.e. data flow diagrams, source to target mappings, etc.).Builds, optimizes and maintains conceptual and logical database models and are responsible for partnering with the Data Platform and feature development teams for translating to the physical model.Develops integration documentation that records how data should flow from source systems to consumption layer (i.e. Source to Target Mappings).Supports Data Stewards in the Delivery Team(s) in capturing and documenting business metadata (i.e. definitions).Evaluates existing data architectures to improve data velocity.Brainstorms ideas with Database Developers, Data Engineers, Data Scientists, and Platform Engineers to generate new data products.Stays current on data industry trends for data related technologies, architectures, and methodologies.Documents and provides recommendations resulting from data quality analysis.Participates in production delivery of operational business performance monitoring capabilities.REQUIRED5+ years’ experience in implementing packaged or custom ERP/MRP solutions in the Retail industry, focusing on data architecture and migration.10+ years’ experience in data architecture design, implementation, and maintenance of complex datasets.Experience in a Data Architect role on a variety of large-scale projects, leading teams in developing data architectures. Experience working with data modeling tools (Erwin preferred).Experience architecting and delivering data engineering/integration pipelines.Experience designing and developing performance-optimized data models.Proficient in SQL and other data access languages.Experience in logical and physical data architecture, design, and development.Demonstrated experience leading architectural decisions that promote partnership between several disparate data teams.Demonstrated ability to communicate at all levels within the organization.Knowledge of relational and dimensional modeling structures.Knowledge and/or experience with service-oriented architecture entities and frameworks.Extensive experience with disciplined software development lifecycle.Experience overseeing work of less experienced data modelers. Thorough knowledge of multi-­platform database commands. Knowledge of database performance/tuning/measurement, as well as user access and data manipulation.Strong verbal and written communication skills and able to communicate to both technical and business audiences.Ability to work under pressure in crisis with a strong sense of urgency.Responsible, conscientious, organized, self-motivated, and able to work with limited supervision.Detail-oriented and possess strong problem-solving skills and ability to analyze potential future issues.Able to support off-hours work as required, including weekends, holidays, and 24/7 on-call responsibilities on a rotational basis.RecommendedExperience in information privacy, data compliance, and risk management.CDMP (Certified Data Management Professional) - AssociateExcellent verbal and written communication skills.Proficient in Google Workspace applications, including Sheets, Docs, Slides, and Gmail.Required Documents Cover Letter ResumeCalifornia applicants, please click here to review the Costco Applicant Privacy Notice.Pay Ranges: Level 1 - $36.06/hr - $52.88/hrLevel 2 - $100,000 - $135,000Level 3 - $130,000 - $170,000Level 4 - $155,000 - $200,000, Bonus and Restricted Stock Unit (RSU) eligibleWe offer a comprehensive package of benefits including paid time off, health benefits - medical/dental/vision/hearing aid/pharmacy/behavioral health/employee assistance, health care reimbursement account, dependent care assistance plan, short-term disability and long-term disability insurance, AD&D insurance, life insurance, 401(k), stock purchase plan to eligible employees.Costco is committed to a diverse and inclusive workplace. Costco is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or any other legally protected status. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to View email address on click.appcast.io hired, you will be required to provide proof of authorization to work in the United States. In some cases, applicants and employees for selected positions will not be sponsored for work authorization, including, but not limited to H1-B visas.