The Data Architect is responsible for the delivery of a robust scalable data architecture that meets the business goals of the organization. The Data Architect develops the logical data models and documents the models in Entity-Relationship Diagrams (ERD). The Data Architect will typically work with the Business Analysts, Data Integration Developers, and the Solution Architect to translate the business requirements into a logical model. The logical model is captured in the ERD, which then feeds the work of the Database Administrator who designs and implements the physical database.
This role involves developing the overall Data Warehouse logical architecture. The physical implementation of the architecture is the responsibility of the Database Administrator.
Responsibilities
- Understands Data Flow- Has a complete understanding of the data that resides in various Data Sources and how it flows through various applications.
- Controls Data Model Changes- Reviews and analyzes the impact of changes to data structures in logical data models prior to allowing DBAs or Data Modelers to make physical changes.
- Develops Data Standards- Creates and ensures the use of data standards regarding access, masking, sub-setting, and archiving are developed and communicated to project teams.
- Applies/Integrates Data Governance Policies-Works with any Data Governance bodies within the organization to ensure architecture designs accommodate any applicable policies.
- Establishes Data Model-Works with data modelers to create a robust data model for data sources, operational data stores, enterprise data warehouses, and data marts.
- Maintains Logical Data Object Model- Determines the data elements and defines the process that will reside in the virtual layer. Assumes responsibility for maintaining logical data object models and logical data objects that reside and relate to each other.
- Reviews Application Metadata- Owns and consolidates critical application metadata for the purpose of metadata and operational statistics reporting needs. Utilizes metadata tools and applies related best practices.
- Assists Development Teams- Provides inputs on data flows and desired lineage for projects.
- Maintains Data Quality Metrics- Sets target quality thresholds required for data elements and creates scorecards for monitoring.
- Plans Data Architectures-Plans architecture and infrastructure to support data management processes and procedures.
Qualifications/Certifications
- Experience with the definition and implementation of Enterprise Data Strategy and Data Management Principles.
- Expertise with data discovery and access, data analysis, data modeling and data virtualization.
- Extensive experience with various integration areas such as data integration, application integration and business process integration.
- Strong understanding of and experience with various capabilities like Data Governance, Data Content Management (reference data, master data, metadata, data life cycle, and data quality management), technologies and tools in data modeling, virtualization, profiling, quality management, performance and delivery.
- Strong business analysis and problem-solving skills.
- Understanding of multiple data architectures that can support a Data Warehouse.
- Industry vertical experience is essential
- Project Solution experience is desired
- Has experience with at least one RDBMS
- Ability to translate functional requirements into technical design specifications.
- Experience in optimizing data loads and data transformations.
- Interpersonal and leadership skills including collaboration, facilitation and negotiation.
- Excellent written, verbal, and virtual communication skills.