Database Architect Senior in Washington, District of Columbia at Integral Consulting Services

Position Title: Database Architect Senior

Location: US-DC-Washington
Job ID: 5362

# of Openings: 1

Category: Information Technology

Clearance: Secret

Clearance Status: Active

Type: Regular Full-Time
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:

· 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

Equal Opportunity Employer/Protected Veteran/Disability