Database Architect Senior

Integral•, DC

About The Position

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. This role involves identifying, acquiring, and curating relevant commercial S&T data sets, engaging with analysts to answer strategic questions, automate reports, and configure dashboards. A robust data quality program, including profiling, cleansing, enrichment, and stewardship, is essential. The position requires maintaining metadata, data lineage, and data dictionaries, as well as developing and deploying advanced analytics, dashboards, and AI/ML models. Onboarding, training, and support for analytics platforms are also key responsibilities. The role includes establishing and supporting a Data Governance Board, designing and operating data and applications within a secure cloud environment (FedRAMP High, DoD IL5), and ensuring the system’s Authority to Operate (ATO). Architecture design for scalability, implementation of secure data access mechanisms (APIs, UIs, Bulk Data Download), and management of access under a formal data governance framework are critical. Development and deployment of ML/AI models, including NLP, and integration of AI/ML platforms are expected. Automation of infrastructure and workflows using IaC, CI/CD pipeline management, and development of streaming data pipelines are also part of the role.

Requirements

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

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.
Establish a robust data quality program encompassing data profiling, cleansing, enrichment, and stewardship.
Maintain metadata, data lineage, and data dictionaries using enterprise-grade tools.
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.
Design, deploy, and operate all data and applications within a cloud environment authorized at the FedRAMP High baseline and DoD Impact Level 5 (IL5).
Maintain the system’s Authority to Operate (ATO) at all times to 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.
Develop streaming data pipelines (e.g., using Apache Kafka or AWS Kinesis) for real-time data processing.