Intermediate Data Architect

General Accountability: This role is an Intermediate Data Architect reporting to the Data Architect / Lead Data Architect , with ownership of data architecture within assigned domains or initiatives . While the role has a strong hands-on focus on data modeling and data design , it is also accountable for architecture outcomes , ensuring that data solutions are consistent, governed, scalable, and aligned with enterprise strategy .

The Associate Data Architect is expected to operate with a degree of autonomy , contribute to architecture governance , and influence key data design decisions , while aligning with the broader direction set by senior data architect. Owns the end-to-end data architecture for assigned domains or initiatives , ensuring alignment with enterprise data architecture standards Designs and maintains conceptual, logical, and physical data models , ensuring they are scalable, reusable, and fit-for-purpose Translates business requirements into architecture-aligned data designs , balancing immediate needs with long-term sustainability Defines and governs data flows, integration patterns, and data structures supporting applications and analytics platforms Ensures adherence to enterprise data architecture standards, naming conventions, and modeling practices Acts as a data architecture steward within assigned scope, ensuring consistency across systems and projects Participates in and contributes to architecture review boards and model governance processes Reviews and approves data models and designs produced by other team members or project teams Contributes to the evolution of data architecture strategy , particularly in data modeling, integration, and domain design Identifies opportunities to improve data structures, reduce redundancy, and enhance data usability across platforms Provides input into target-state architecture and roadmap planning , based on domain insights Supports alignment with enterprise initiatives such as OCDM and enterprise data architecture frameworks Handles complex and ambiguous data requirements , making informed design decisions within defined architectural guardrails Conducts impact analysis and trade-off assessments for changes in data models and data flows Resolves data design conflicts and inconsistencies across systems and stakeholders Works closely with: Business stakeholders Product owners Data engineers Application teams Ensures that data requirements are accurately translated into models and implementations Provides guidance and mentorship to junior team members or project contributors on data modeling best practices Supports cross-team alignment to ensure data architecture consistency across domains Owns and maintains: Data models (ERDs, LDMs, PDMs) Data dictionaries and metadata Integration and Mapping Artifacts (DFD, S2TM, Data Lineage Architecture documentation and design decisions Ensures documentation supports governance, reuse, and transparency Domain-Specific Requirements: Knowledge and experience with the following are essential: Strong expertise in: Conceptual, logical, and physical data modeling ERDs, normalization/denormalization Proven ability to design and own data models for medium to large-scale systems Solid understanding of: Data integration patterns and data flow design Relational databases and exposure to NoSQL concepts Working knowledge of enterprise data architecture principles and governance practices Familiarity with regulatory and compliance requirements influencing data design (e.g., GDPR, BCBS 239) Practical experience with modern data platforms, preferably Azure: Azure Data Factory Azure Databricks Azure Data Lake / Storage (Parquet) Azure Synapse Power BI Knowledge/Skills/Competencies/Education: Education 4–6+ years of experience in data modeling, data architecture, or closely related roles Demonstrated ownership of data design and architecture deliverables in real-world projects Experience working across multiple systems or domains, not just is