Description
The Data Architect will report directly to the Manager, DevOps, Data & IT PMO. The role will ensure organizational data is organized, managed, and stored in a manner that facilitates business enablement and intelligence. The Data Architect will develop programmatic solutions in response to technical needs such that they meet requirements and design specifications This role will be responsible for transforming data and data products into solutions that can be leveraged by those who seek insight from our enterprise data.
- Serve as an expert resource on matters of data architecture to business and IT staff in all phases of data, data warehouse and data mart development, implementation and support.
- Define data architecture vision, strategy, principles and standards; gets buy-in from stake-holders, management, business partners, and propagate throughout the organization based on guidelines and procedures.
- Provide framework, stewardship, governance and decision making for management of data for project development teams, business users and other stake-holder; services for both analytics products and innovation teams.
- Ensures data quality and provides guidance to best practices.
- Designs and builds relational databases for data storage or processing.
- Develops strategies for warehouse implementation, data acquisition, and archive recovery. Cleans and maintains the database by removing and deleting
- Evaluate new data sources for adherence to the organization’s quality standards and ease of integration.
- Contribute to an architecture roadmap covering transactional, operational and business intelligence. Ensure architectural adherence through blueprint and design reviews.
- Incorporate into the enterprise data management methodology and standards for data modeling and data architecture.
- Create appropriate standards, processes and tools to promote and facilitate mapping of data sources and documenting interfaces and data movement
- Design the movement of data through the enterprise using integrative views of data especially for analytic purposes
- Put in place governance processes around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of meta-data.
- Participate in developing consistent definitions for common reference data.
- Establish measures to chart progress related to completeness and quality of meta-data for enterprise information, to support reduction of data redundancy and fragmentation, elimination of unnecessary movement of data, and improvement of data quality.
- Provide input on large-scale projects and road maps for compatibility with the vision.
- Drive selection of data management tools, and the development of standards, usage guidelines and procedures for those tools.
- Define the process to resolve cross-organizational data management issues.
- Provide consulting support for the roll-out of meta-data management processes and tools.
- Research and document information architecture standards and best practices.
- Define meta-data checklists and requirements to be met at the project level and to be included in project plans.
- Provide support on use of common enterprise information models and promote their use and enhancement by new projects.
Requirements
- Bachelor’s degree or combination of education, certification and significant relevant experience is required
- Working knowledge of modeling tools (e.g., ERWIN Model Manager, IBM Rational Suite, Rational (RSA & RDA), etc.)
- Strong access modeling/SQL Query skills leaning towards the physical data modeling practice.
- Experienced in creating and maintaining end to end data architectures
- Hands-on technical experience using data warehouse, business intelligence and analytics products
- 5 or more years of experience in:
- logical, access, and physical, data modeling
- normalized and dimensional data modeling techniques
- data analysis and mapping
- creation and usage of metadata
- Excellent communication and facilitation skills
- Team oriented with excellent collaboration skills
- Attention to detail, and a commitment to quality work
- Exhibits leadership qualities
