Job Summary:
Costco Wholesale is the third largest retailer in the world, known for its employee-centric atmosphere and commitment to community service. The Data Architect will lead the design and implementation of data architecture strategies to support the replatforming of core ERP/MRP systems, ensuring data quality and governance across the organization.
Responsibilities:
• 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.).
• Develops the enterprise data strategy and architectural standards for maintaining the performance, quality, data security and compliance of certified data sets.
• Builds, optimizes and maintains conceptual and logical database models and are responsible for partnering with the Data Platform 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.
• Develops 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.
• 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.
• 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.).
• Participates in production delivery of operational business performance monitoring capabilities.
Qualifications:
Required:
• 5+ 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 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.
• 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.
• Experience in logical and physical data architecture, design, and development.
• Experience in a data architect role on a variety of large-scale projects.
• 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 multiplatform database commands.
• Knowledge of database performance/tuning/measurement, as well as user access and data manipulation.
Preferred:
• Experience in information privacy, data compliance, and risk management.
• CDMP (Certified Data Management Professional) - Associate.
• Excellent verbal and written communication skills.
• Proficient in Google Workspace applications, including Sheets, Docs, Slides, and Gmail.
Company:
Costco Wholesale is a multibillion dollar global retailer with warehouse club operations in 14 countries. Founded in 1983, the company is headquartered in Issaquah, USA, with a team of 10001+ employees. The company is currently Late Stage.