Data Architect

Chantilly, VA

Full Time

Data and Knowledge Management

Experienced

20260501-4275-01

Active Top Secret Clearance with Poly Required

(salary is commensurate with education and experience)

Job Summary

We require Data Engineering support to evaluate, optimize, and implement robust data infrastructure that enables reliable, accessible, and scalable data delivery across the organization. The Contractor will work collaboratively with data consumers, technical teams, leadership, and stakeholders to assess current data pipelines, identify gaps in data accessibility and reliability, and architect solutions that establish trusted data foundations. Work involves applying engineering best practices to implement proper data modeling and integration patterns, ensuring data quality and observability throughout pipelines, and creating maintainable infrastructure that supports analytics, reporting, and operational use cases.

The data landscape includes enterprise operational systems such as ServiceNow, network management platforms (NetlM), and network modeling tools (Forward Networks). The Data Engineering support must be adept at extracting data from these systems via AP!s (application Programming Interface), exports, and vendor-specific interfaces, often with limited documentation or non-standard data structures, and transforming this operational data into accessible, integrated datasets.

Please Note:

This job requires an existing Top Secret Clearance and Polygraph.

Responsibilities and Duties

Conduct comprehensive assessments of existing data pipelines, infrastructure, and data flows including integrations with operational systems like ServiceNow, network management platforms, and business applications to identify technical debt, bottlenecks, and reliability issues.
Evaluate current data architecture against industry best practices and organizational needs; develop technical recommendations and roadmaps for data infrastructure improvements.
Design, build, and maintain production-grade data pipelines using orchestration tools such as Airflow or Prefect.
Develop robust ETL(Extract-Load Transform) processes from diverse sources: SAAS platforms, network management systems, databases, AP!s, files, and streams.
Build AP! integrations handling authentication (OAuth, API keys, and Single Sign-On (SSO), rate limiting, pagination, retry logic, and error handling.
Extract data from systems not designed for export; reverse-engineer undocumented data structures and relationships.
Handle semi-structured data (JSON and XML); and transform into structured datasets with consistent schemas.
Design dimensional models, data warehouses, and data marts following industry methodologies.
Create conceptual, logical, and physical data models optimized for query performance and storage efficiency.
Implement slowly changing dimensions and other data warehousing patterns.
Establish naming conventions, data standards, and modeling best practices.
Implement comprehensive data quality checks, validation rules, and automated monitoring with alerting.
Build error handling, failme recovery, logging, and observability into all processes.
Optimize pipelines for performance, cost, and resource utilization.
Develop reusable components and frameworks; refactor legacy pipelines for reliability.
Build and maintain data infrastructure on cloud platforms (Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP) using infrastructure-as-code using Terraform and CloudFormation.
Implement CI/CD pipelines, version control (Git), and automated testing frameworks.
Manage database performance tuning, indexing, partitioning, and capacity planning.
Establish backup, recovery, security controls, access controls, and compliance measures.
Partner with analysts, software developers, and business stakeholders to translate requirements into technical solutions.
Create comprehensive documentation for systems, processes, and integrations.
Provide technical guidance on data availability and proper usage; enable self-service access.
Troubleshoot pipeline failures, performance issues, and data discrepancies; perform root cause analysis.
Experience Needed:
Citizenship: Must Be a US Citizen
Existing Clearance Required: Active Top Secret SCI with Poly
Demonstrated experience with ServiceNow AP!s, data models, and integration patterns.
Demonstrated experience with network management or IT operations systems data extraction.
Demonstrated experience with Forward Networks, Net!M, SolarWinds, or similar network management platforms.
Demonstrated experience and knowledge of ITSM (Information Technology Service Management), !TOM (Information Technology Operations Management), and CMDB (Configuration Management Database) data structures and relationships.
Demonstrated experience with AP! gateway platforms and AP! management tools.
Demonstrated experience with Apache Spark, particularly PySpark, for distributed data processing.
Demonstrated experience with DBT (data build tool) for transformation workflows.
Demonstrated experience with infrastructure-as-code tools such as Terraform or CloudFomation.
Demonstrated experience implementing CI/CD (Continuous Integration / Continuous Delivery) pipelines for data engineering code.
Demonstrated experience and knowledge of streaming data technologies such as Kafka, Kinesis, or similar platforms.
Demonstrated experience with data quality platforms such as Great Expectations, Soda, or Monte Carlo.
Demonstrated experience implementing data observability and monitoring solutions.
Demonstrated experience and knowledge of Data Vault or other advanced modeling methodologies.
Demonstrated experience with containerization (Docker) and orchestration (Kubernetes) for data workloads.
Demonstrated experience with reverse ETL and operational analytics patterns.
Demonstrated experience with data governance platforms and metadata management tools.
Demonstrated experience with multiple cloud platforms and multi-cloud architectures.
Demonstrated experience mentoring or leading data engineering initiatives.
Benefits
Our comprehensive benefits package includes Medical, Dental, Vision, Health Savings Account, Paid Time Off, Holidays, Social Events, Employee Assistance Program, Team Building Activities, 401K, Tuition Assistance, and more.
Contact Us: Main Number: 1-888-663-2690 | [email protected] | www.dezign-concepts.com

Dezign Concepts provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Apply for this position

Required*

First Name*

Last Name*

Email Address*

Phone*

Address*

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Desired salary*

Which of the following best describes your work authorization status in the United States?*

Are you currently, or will you in the future, require sponsorship for employment Visa status?*

Do you have a security clearance?

Please select your current security clearance level:*

If you have a clearance, what agency is it affiliated with?

By "Affiliated", we want to know which agency initiated and processed your clearance.

Please select the agency from the list below...*

Have you worked for the agency you selected above in the past 2 years?*

Requested Salary*

Human Check*

Submit Application

Thanks for visiting our Career Page. Please review our open positions and apply to the positions that match your qualifications.