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.
ROLE- 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.
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.
Recommended- 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.
Required Documents• Cover Letter
• Resume
Pay Ranges:
Level 1 - $36.06 - $52.88
Level 2 - $100,000 - $135,000
Level 3 - $130,000 - $170,000
Level 4 - $155,000 - $200,000
We 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.
