Senior Data Architect

Xpect Solutions•Washington, DC

4d•Onsite

About The Position

XPECT Solutions, LLC is seeking a Senior Data Architect to support a federal client's Finance 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 enterprise data architecture, including conceptual and logical data modeling, data warehouse design documentation, a data catalog for BI-supported systems, and support for the ATS Data Strategy's virtualized data fabric. This is a full-time, onsite position at the client's facilities in the National Capital Region, Monday through Friday, and requires an active Top Secret clearance.

Requirements

Active Top Secret clearance.
Bachelor's degree in Physics, Mathematics, Information Technology, Computer Science, Business, or a related discipline.
At least 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, such as star schemas and data marts.
Experience producing data architecture documentation such as ERDs, data models, and ETL design artifacts.
Excellent oral and written communication skills, including the ability to present solution recommendations to technical and business stakeholders.
Ability to work full-time onsite at the client's facility in the National Capital Region, Monday through Friday.

Nice To Haves

Experience with AWS data services, including Amazon Redshift, Aurora PostgreSQL, S3, and Lambda.
ETL design and workflow orchestration experience, such as 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 is a plus.
Familiarity with federal financial or accounting data.
Familiarity with infrastructure as code (Terraform) and GitLab CI/CD pipelines.

Responsibilities

Lead development of enterprise data architectures, strategies, and solution recommendations supporting ATS business strategies.
Lead the design of high-level conceptual and logical data models that provide cross-system and cross-functional views of data requirements, translating business needs into long-term architecture solutions.
Design and develop solutions for complex data sets, including relational and non-relational databases, 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, including 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; and 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 improvements; 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.