Database Architect Senior

Integral Federal, Inc.

McLean (VA)

On-site

USD 100,000 - 130,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, Dental & Vision Insurance

Flexible Spending Accounts

Short-Term and Long-Term Disability Insurance

Life Insurance

Paid Time Off & Holidays

Earned Bonuses & Awards

Professional Training Reimbursement

Employee Assistance Program

Job summary

Integral Federal, Inc. is seeking a Senior Database Architect to provide data and technical expertise to support the Office of Naval Research. This role involves data architecture design, including establishing data governance and ensuring data quality.

The successful candidate will need a Bachelor's in Computer Science and 7 years of relevant experience. Integral offers a comprehensive benefits package along with paid parental leave and flexible spending accounts.

Qualifications

7 years of experience in data architecture design focusing on enterprise architecture and ETL.
Experience in data modeling, creating logical and physical designs.
Experience working in an S&T mission-focused organization.

Responsibilities

Identify and curate relevant commercial S&T data sets with ONR analysts.
Establish a robust data quality program including data profiling and stewardship.
Design and operate all data and applications within a cloud environment.

Skills

Data architecture design

ETL experience

Data modeling

OLTP and OLAP design

Cloud-based solutions

Machine learning & AI

Infrastructure as Code (IaC)

Data governance

Education

Bachelor’s Degree in Computer Science or IT

Tools

AWS

Azure

Terraform

Apache Kafka

Job description

Overview

The Database Architect Senior provides the data and technical expertise to support the Office of Naval Research (ONR) Comptroller’s Office Data and Analytics (D&A) Division architecture.

Responsibilities

Identify, acquire, and curate relevant commercial S&T data sets, such as S&T publications, grants, patents, startup investment activities, company details, and informal S&T literature. directly engage with ONR’s expert analysts to answer strategic questions, automate reports, and configure dashboards to provide real-time insight into global research trends.
Directly engage with ONR’s expert analysts to answer strategic questions, automate reports, and configure dashboards to provide real-time insight into global research trends.
Establish a robust data quality program encompassing data profiling, cleansing, enrichment, and stewardship. maintain metadata, data lineage, and data dictionaries using enterprise-grade tools and shall develop and deploy advanced analytics, dashboards, and AI/ML models in collaboration with ONR stakeholders.
Provide onboarding, training, and ongoing support for analytics platforms, fostering a data-literate workforce.
Establish and support a Data Governance Board to oversee data policies, standards, and compliance are required, as is the maintenance of continuous feedback loops with end-users and leadership for iterative improvement.
Design, deploy, and operate all data and applications within a cloud environment authorized at the FedRAMP High baseline and DoD Impact Level 5 (IL5), and maintain the system’s Authority to Operate (ATO) at all times lo include configuration management, security patching, system monitoring, and help desk support.
Design the architecture for scalability to accommodate future growth in data volume and user load.
Implement and sustain secure data access mechanisms, including Application Programming Interfaces (APIs) and user interfaces for data exploration, as well as a secure Bulk Data Download capability for authorized users.
Manage all access mechanisms under a formal data governance framework, including metadata management and data cataloging. develop and deploy machine learning (ML) and artificial intelligence (AI) models, including Natural Language Processing (NLP) to analyze unstructured text and the integration of AI/ML platforms (e.g., AWS SageMaker, Azure Machine Learning)
Automate infrastructure and workflows using Infrastructure as Code (IaC) tools (e.g., Terraform, Ansible), build and manage CI/CD pipelines for secure software deployment, and develop streaming data pipelines (e.g., using Apache Kafka or AWS Kinesis) for real-time data processing.

Qualifications

Required:

Bachelor’s Degree in computer science or IT related degree with 7 years experience
Seven (7) years of data architecture design experience with a focus on enterprise architecture and ETL
Seven (7) years of data modeling experience, creating both logical and physical designs.
Seven (7) years of experience conducting data architecture and ETL in or for an S&T mission focused organization.
Seven (7) years of experience conducting data architecture and ETL in or for the DoW or Federal Agency.
Experience designing Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), and various reporting systems.
Experience providing architecture and designs for Database, Business Intelligence, Data Integration, and Master Data Management, including integrated Cloud-based solutions.
Demonstrate expertise in technical thought leadership on high level architecture and design, data strategy & adoption for ingestion and analytics applications.
Secret Clearance

Company Overview

Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure.

Integral is headquartered in McLean, VA and serves clients throughout the country.

We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal!

Our package also includes: