Data Architect

About the role

The Data Architect will lead the design, development, and maintenance of the holistic data architecture in support of the replatform of our core ERP/MRP platform. 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.

Responsibilities

• 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.
• 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.
• 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.

Requirements

• 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 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.

Qualifications

• Strong verbal and written communication skills and able to communicate to both technical and business audiences.
• Able 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.

Skills

• Knowledge of 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.

Benefits

• 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.

Pay

• Level 1 - $36.06/hr - $52.88/hr
• Level 2 - $100,000 - $135,000
• Level 3 - $130,000 - $170,000
• Level 4 - $155,000 - $200,000
• Bonus and Restricted Stock Unit (RSU) eligible.