Data Architect

Primary Responsibilities

• Provides leadership in coordinating and reviewing the business process analyses, needs assessment, and preliminary cost/benefit analyses to align information technology solutions with the enterprise business initiatives.
• Collaborates with technical leads in the System Architect team on container orchestration, cloud solutions and services in a hybrid cloud environment.
• Create and maintain high performance, scalable, and stable data architectures for OIS.
• Lead the organization’s data management, security, and migration initiatives while providing direction for a team of data engineers and database administrators.
• Examine the organization’s current data management systems and identify opportunities to enhance performance and prepare for growth.
• Work with System Architect team and assist in development of policies for standardizing systems, development tools and security practices.
• Design and implement data warehouse and storage strategy.
• Design and implement the data extraction, data load, and database synchronization routines and functions ETL.
• Analyze and make recommendations for improvements to existing software regarding database performance, stability, usability and scalability.
• Define and implement database security, audit, and resource allocation policies and procedures.
• Design and implement viable database backup, recovery, and high availability strategies and mechanisms.
• Monitor and optimize database instance using database administration tools, SQL scripts, and database utilities.
• Provide guidance and support for data encryption at rest and in transit.
• Design, model, document, and guide the logical and conceptual relationship of data and database changes for complex applications.
• Identify requirements, research options, design and implement solutions at a leadership level for the OIS Next Generation application and database.
• Perform technical planning, system integration, verification and validation, cost and risk assessments.
• Identify, research, design, develop, and promote solutions that enhance the modern development environment.

Minimum Qualifications

• Must have DOD Top Secret level clearance to start (fully adjudicated T5 background check); Proof of U.S. Citizenship required only for Federal Clearance Requirement
• Certification Requirements: Directive 8570.1/8140 - IAT II:Baseline Certification: Security+ Computing Environment Certification: AWS Certified Cloud Practitioner, Data Engineer, Solutions Architect or similar equivalent Cloud environment certification (if not in hand, must be obtained within 3 months of on-boarding)
• BA/BS or equivalent experience and 8+ years of prior relevant experience (or master’s with 6+ years or prior relevant experience), at least 3 years of concentrated hands on experience as Data Engineer or Data Architect within similiar tech stack
• Expert level knowledge of all aspects of SQL
• Extensive experience in container orchestration
• Extensive experience in database design and development
• Extensive experience with data modeling, schema design, and database optimization
• Extensive experience in configuring and managing Oracle database
• Experience in migration from on-prem data center to public cloud (AWS, Azure)
• Experience in decomposition of Oracle PL/SQL stored procedures and triggers to migrate to Amazon Aurora DB, Postgres, or MySQL
• Experience with ETL/ELT pipeline design feeding data warehouse ingestion at scale
• Familiarity with data retention policies, TTL management, and tiered storage strategies
• Strong understanding of dimensional modeling, data partitioning strategies, and query optimization for high-volume analytical workloads
• Experience designing and managing large-scale analytical data warehouses, preferably using ClickHouse or comparable columnar/OLAP databases (e.g., Redshift, BigQuery, Snowflake)
• Excellent communication and written skills
• Must be a self-starter, strong leader, and have the ability to work independently with little supervision.

Desired Qualifications

• 12-15 Years of experience in database design and development
• Familiarity with ClickHouse integrations (Kafka engine, S3-backed storage, or federated queries via external dictionaries/tables)
• Experience operating ClickHouse in a cloud or containerized environment (Kubernetes, ClickHouse Cloud, or Altinity)
• Understanding of ClickHouse's eventual consistency model and how it differs from traditional RDBMS transaction semantics
• Demonstrated experience in network and cyber security design, engineering and operations with emphasis on Navy capabilities