Data Architect at Entarian

Job description

Entarian is looking for a Data Architect for the Naval Supply Systems Command (NAVSUP) Ordnance Information System (OIS) to provide technical expertise on a mission-critical program whose purpose is to develop, modernize, enhance, operate, and maintain services for OIS mission critical systems. The Data Architect plays a key role in the System Architect team. This person is responsible for the project management, strategic direction, and resource management necessary for the maintenance and ongoing development of the Database systems within NAVSUP OIS. The Data Architect will be responsible for database design, data analytics, data retention processes, data compliance, security, and automating related processes for products used in support of OIS. REMOTE: Possibility of up to 10% Travel required - Client meetings in Mechanicsburg, PA, and/or Yorktown, VA Primary Responsibilities: • This role 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. • Coordinate with technical leads in the System Architect team with 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 Salary Range: $150.000 - $180,000 • 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 • Understanding of data warehouse monitoring — query performance tracking, storage growth, and resource utilization • 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. • 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 Formed through the strategic union of Sev1Tech and ERT, Entarian is a premier provider of mission-critical engineering and technology solutions. Founded on a legacy of excellence dating back to 1993, Entarian is a product of an evolved and fully diversified engineering and federal technology leader. From deep space to defense and civilian missions, Entarian delivers secure, mission-aligned digital solutions that drive national resilience and operational effectiveness. We don't just support modernization; we define it. Join the Mission and Start your Career Journey: Apply Directly via our Careers Portal Connect, Referrals & Inquiries? Email the team: careers@entarian.com Entarian is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. We can recommend jobs specifically for you! Click here to get started.

Requirements

Must-haves

The Data Architect will be responsible for database design, data analytics, data retention processes, data compliance, security, and automating related processes for products used in support of OIS.
REMOTE: Possibility of up to 10% Travel required - Client meetings in Mechanicsburg, PA, and/or Yorktown, VA
Coordinate with technical leads in the System Architect team with 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
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+
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.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlrestawsazurepostgreskubernetes

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Vision