> Markdown version of [/jobs/ext/3767157-senior-data-architect](https://www.wearedevelopers.com/jobs/ext/3767157-senior-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Architect - **Company:** XPECT Solutions Inc. - **Location:** Washington, DC, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Amazon S3, Applicant Tracking Systems, Databases, Data as a Services, Data Architecture, Data Governance, Extract Transform Load (ETL), Data Mart, Data Virtualization, Data Warehousing, Entity Relationship Models, Network Interface Controllers, Information Model, Python (Programming Language), PostgreSQL, Logical Data Models, Meta-Data Management, Metadata Repositories, Standard Sql, Data Streaming, Workflow Management Systems, Data Strategy, Build Management, Microsoft Fabric, Gitlab-ci, Information Technology, WebFOCUS, Non-relational Database, Tools for Reporting, Functional Programming, Terraform, TIBCO (Software), Amazon Redshift - **Published:** October 16, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9245550/senior-data-architect ## About the Role * Active Top Secret clearance * Bachelor's degree in Physics, Mathematics, Information Technology, Computer Science, Business, or a related discipline * Minimum of 8 years of relevant professional experience in data architecture or related technology disciplines * Demonstrated experience leading enterprise data architecture, conceptual and logical data modeling, and metadata management on high-impact assignments * Experience designing and building relational and non-relational databases and data warehouse structures (e.g., star schemas, data marts) * Experience producing data architecture documentation such as ERDs, data models, and ETL design artifacts * Excellent oral and written communication skills, with the ability to present solution recommendations to technical and business stakeholders * Ability to work full-time onsite at client's facility in the National Capital Region, Monday-Friday. Preferred Additional Skills and Qualifications: * Experience with AWS data services, including Amazon Redshift, Aurora PostgreSQL, S3, and Lambda. * ETL design and workflow orchestration experience (e.g., Apache Airflow), with strong SQL and Python skills. * Experience building data catalogs and supporting data governance, data virtualization, or data fabric initiatives. * Experience developing canonical information models and Interface Control Documents (ICDs). * Familiarity with BI and reporting platforms (Tibco WebFOCUS a plus) and federal financial or accounting data. * Familiarity with infrastructure as code (Terraform) and GitLab CI/CD pipelines. ## Description * Lead the development of enterprise data architectures, strategies, and solution recommendations in support of ATS business strategies. * Lead the design of high-level conceptual and logical data models that provide a cross-system, cross-functional view of data requirements; translate business needs into long-term architecture solutions. * Design and develop solutions for complex data sets; design and build relational and non-relational databases, including star schemas and data marts. * Create and maintain data model documentation, including the Canonical Information Model (CIM), Entity Relationship Diagrams (ERDs), Interface Control Documents (ICDs), and ETL diagrams; prepare Data Warehouse Design Documents for Government review. * Compile and maintain a Data Catalog for BI-supported systems (databases, tables, fields, and data descriptions) to feed the ATS Data Strategy; support implementation of a virtualized data fabric for centralized search and query. * Establish processes governing the identification, collection, and use of metadata; ensure metadata accuracy, validity, and quality; execute assigned data governance tasks. * Review object and data models and the metadata repository to structure data for better management and quicker access. * Analyze existing data warehouse capabilities and recommend and implement process and system improvement strategies; collaborate with ATS system teams on new data source ingestion and data feed integrity. * Provide technical leadership to system and local work groups, and advise stakeholders on software, hardware, and database management solutions.