Senior Data Architect

Xpect Solutions

Washington (District of Columbia)

On-site

USD 140,000 - 190,000

Full time

2 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental, Vision

Retirement Savings Plan

Life Insurance

AD&D Insurance

Disability Insurance

PTO

Holiday PTO

Performance Awards

Referral Bonuses

Education Reimbursement

Job summary

XPECT Solutions, LLC is seeking a Senior Data Architect to support our federal client’s Finance and Facilities Division (FFD), Accounting & Technology Section (ATS) BI Suite operations. The BI Suite supports financial reporting and data warehousing on an AWS cloud platform.

The Senior Data Architect leads the program’s enterprise data architecture: designing conceptual and logical data models, maintaining data warehouse design documentation, building a data catalog for BI-supported systems, and

Qualifications

Bachelor’s degree in a related field.
8+ years of data architecture experience.
Active Top Secret clearance.
Experience with enterprise data modeling and metadata management.
Proven ability to design relational and non-relational data warehouses.
Strong communication and stakeholder engagement skills.

Responsibilities

Lead enterprise data architectures and define data strategies.
Design conceptual and logical data models across systems.
Develop and maintain data warehouse documentation and CIM/ERD artifacts.
Create a Data Catalog and support virtualized data fabric initiatives.
Collaborate with ATS teams on data ingestion and governance.
Provide technical leadership to project teams and stakeholders.

Skills

Enterprise data architecture

AWS data services

ETL design

Data cataloging

Data governance

Python

SQL

Airflow

Terraform

GitLab CI/CD

Education

Bachelor’s degree

Tools

Amazon Redshift

Aurora PostgreSQL

Lambda

Tibco WebFOCUS

Airflow

Terraform

GitLab CI/CD

Job description

Company Overview

XPECT Solutions, LLC. has built a strong reputation by supporting our clients in meeting their strategic goals and mission objectives. We provide high quality resources for a wide range of IT and security solutions at best-value pricing. Our success is built on a solid foundation of well-vetted, highly technical personnel, a disciplined project management approach, and an overarching commitment to customer service. We develop, test, deploy, and support exceptional solutions that enhance system functionality, while maximizing reliability and availability, and ensure the tightest security.

Job Overview:

XpectSolutions is seeking a Senior Data Architect to support our federal client'sFinance and Facilities Division (FFD), Accounting & Technology Section (ATS) Business Intelligence (BI) Suite Operations & Maintenance program. The BI Suite supports financial reporting and data warehousing on an AWS cloud platform. The Senior Data Architect leads the program’s enterprise data architecture: designing conceptual and logical data models, maintaining data warehouse design documentation, building a data catalog for BI-supported systems, and supporting the ATS Data Strategy’s virtualized data fabric. This is a full-time, onsite position at our client's facilities in the National Capital Region and requires an active Top Secret clearance.

Core Responsibilities

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.

Requirements:

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.

Benefits

Xpect Solutions, LLC is a one-of-a-kind employer with a talented team that is cleared at various levels and is certified in dozens of industry-recognized certifications. Our talented staff are the key to our success. They bring the knowledge, experience and technical skills to deliver the best solutions to our customers.

We support our team by providing open communication, win-win partnerships with clients and vendors, a team-oriented culture that supports employee focus on professional development and growth for a long-lasting and happy career.

We offer a benefits package that is designed to keep our most important assets – our employees – healthy, happy, energized and moving forward. Our philosophy is simple – empower our employees with the benefits, resources and the financial incentives they need to be successful.

Benefits and Perks: