Data Architect
Systel 12 reviews - Seattle, WA

This job posting is no longer available on Systel. Find similar jobs:Data Architect jobs - Systel jobs

Description of position:
The Data Architect will join the Database Development Team, which is responsible for the design and overall quality of Costcos Enterprise and Application Data Models. While meeting the database needs of current projects, this team is also responsible for supporting the development and execution of a long term strategy to modernize the transactional and analytical databases underlying Costcos legacy systems.
The Data Architect will be actively involved in the evaluation and review of data models across the organization in order to ensure that a high level of database design is reached and maintained. This person will collaborate with Enterprise Architects and Solution Architects to drive data design within the database systems in support of Costcos Information Systems. The Data Architect will be assigned to projects across multiple domains, including OLTP, OLAP and MDM projects, as a resource responsible for the database design need. While providing the database expertise needed for the success of the assigned projects this individual will also be required to follow database modeling policies and standards. This position will require an individual who can work with minimal supervision on a wide range of projects interfacing with development teams, business analysts, I.S. management and members of the business community while constantly ensuring that their work is aligned with the Database Development Teams strategic direction.

Daily tasks and responsibilities:
Apply Enterprise and Solution Architecture decisions to Data Architecture frameworks and models
Apply data modeling techniques and standards to I.S. solutions
Collaborate with Data Modelers for internal data model reviews, data model management and version control
Conduct data model reviews with project team members
Participate in information meta-data strategy definition
Collaborate with Data Management Team - Data Analysts to establish data quality baseline snapshots
Collaborate with Data Management Team - Data Stewards for data quality issues
Create data source catalogue
Perform data source gap analysis
Define data migration specification
Design Conceptual data model
Design Logical data model
Design Physical data model
Design Canonical data model
Design database transaction structures
Design data warehouse & data mart structures
Identify data requirements and related KPIs, Metrics
Collaborate with application and services teams to design databases which fully meet business and technical requirements
Maintain expertise and proficiency in the various application areas
Develop a thorough knowledge and understanding of cross system interactions and relationships in order to develop an enterprise view of Costcos data needs
Maintain current knowledge of industry trends and standards

Overall Skills, Knowledge and Experience:
Thorough knowledge of multi-platform database commands
Knowledge and/or experience with data modeling and design is essential (5 years minimum)
Logical data modeling, knowledge of entity relationships
Knowledge of development lifecycle
Ability to communicate at all levels within the organization
Analytical skills
Advise on Database Performance/Tuning/Measurement
Advise on User Access & Manipulation

Project Portfolio:
The Data Architect should have a working knowledge of, and documented experience in, most of the following areas (in order of importance):
SAP Applications, including CRM, FI and HCM modules
Master Data Management
Data Warehousing, including Enterprise Data Warehouses and Operational Data Stores
Legacy Application upgrades
Others as needed, including COTS and new in-house applications

About this company
12 reviews
The company was founded in 1988 as an engineering consulting company, Systel has emerged as a leader in ruggedized designs and system...