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.

• 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.

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