Enterprise Data Architect

The Enterprise Data Architect provides senior-level logical and physical data modeling support to SSA's Data Strategy and Enablement (DSAE) Data Administration team under Work Order 0.55-212. The role is dedicated to the EDA Modeling Support work activity, providing logical and physical modeling and related modeling activities for projects across various business domains. The Enterprise Data Architect partners with Government leads, project teams, business stakeholders, and database engineers to deliver high-quality data models that align with enterprise data standards, reference data architecture, and SSA's broader data architecture direction.

Design Tasks:

· Provide logical and physical data modeling support and related modeling activities for projects across various business domains within SSA's Data Administration scope.

· Develop and maintain logical and physical data models using Erwin (V12.5.2 and later) and Hackolade in alignment with enterprise data standards.

· Partner with project teams, government leads, business stakeholders, and database engineers to elicit modeling requirements and translate them into accurate, complete, and reusable data models.

· Review existing data models, schemas, and documentation; recommend improvements to alignment with enterprise standards, reference data architecture, and modeling best practices.

· Support implementation of Reference Data Architecture, Global Reference Table (GRT) data, and related development changes throughout the lifecycle.

· Design and review database schemas across PostgreSQL, SQL Server, DB2, and Oracle in alignment with enterprise data standards and modeling guidelines.

· Document logical and physical models, model decisions, naming conventions, and modeling patterns to support reuse, traceability, and onboarding of project teams.

· Support data analysis and profiling activities to inform model design and identify quality, consistency, and structural issues across enterprise datasets.

· Provide modeling input to data integration, data exchange, and metadata initiatives, including recommendations on Open File Formats (JSON, XML, Avro, Kafka, MongoDB) and code metadata schemas where relevant to model design.

· Conduct requirements elicitation and analysis to ensure data models accurately represent business needs and integrate with downstream systems.

· Provide modeling guidance and consultation to database engineers, developers, and architects in support of consistent, standards-aligned data solutions.

· Communicate and collaborate with stakeholders across SSA components, providing modeling expertise across analysis, design, and review discussions.

· Develop technical documents, modeling artifacts, presentations, and weekly status reports to fulfill work order objectives.

Do you have experience in Visio?, Do you have a Associate's degree?, · Bachelor's degree in Computer Science, Information Systems, Data Management, or related technical field; Associate's degree with 7+ years of relevant experience may substitute for the bachelor's degree requirement.

· Minimum 7+ years of relevant experience in logical and physical data modeling, enterprise data architecture, or database design in complex enterprise or federal environments.

· Strong, hands-on experience performing logical and physical data modeling using Erwin (V12.5.2 and later) and Hackolade.

· Demonstrated experience delivering data modeling support across multiple business domains and projects concurrently.

· Strong experience with database schema design across PostgreSQL, SQL Server, DB2, and Oracle in alignment with enterprise data standards and modeling guidelines.

· Experience supporting Reference Data Architecture, Global Reference Tables (GRTs), and enterprise data standards.

· Strong understanding of modeling best practices including normalization, denormalization, naming conventions, lineage, and traceability.

· Experience eliciting requirements from business and technical stakeholders and translating them into accurate logical and physical data models.

· Familiarity with Open File Formats including JSON, XML, Avro, Kafka, and MongoDB, and with code metadata schemas as they relate to modeling.

· Experience reviewing existing data models, schemas, and documentation and recommending improvements aligned with enterprise standards.

· Strong technical writing, problem-solving, and analytical skills with the ability to translate business needs into clear, well-documented data models.

· Experience using Microsoft Office Suite, Visio, Confluence, and SharePoint.

· Strong interpersonal and communication skills with the ability to collaborate across business, technical, and architectural teams.

· Familiarity with federal IT environments preferred.

Must be able to obtain and maintain a Public Trust.