Data Engineer​/Data Architect III

Job Description

The Lead Data Engineer / Data Architect will spearhead the creation of our next‑generation “Analytics Core” within a closed, classified, on‑premises environment. This mission‑critical project will unify our 30‑year legacy archive of diverse data—including reports, sensor data, imagery, and heavily geospatial intelligence—into a single, query‑able, and AI‑ready ecosystem.

Because our historical data is highly complex with deep attribution challenges, this is a “roll‑up‑your‑sleeves” role. We expect a balance of approximately 60% hands‑on data engineering (ETL pipeline construction, data cleaning, and mapping) and 40% data architecture (strategic design and governance).

As our management team upskills our dedicated in‑house staff to execute the broader data migration, this role will act as the technical anchor. The Lead Data Engineer / Data Architect will build strong relationships, set clear technical standards, and seamlessly interface with transitioning staff to ensure the project’s success.

• Data Architecture & Modeling: design the foundational multidimensional data models for complex, multi‑modal data.
• Untangle 30 years of complex historical data to resolve attribution issues and establish a clean, authoritative data model.
• Foundational Engineering: act as the hands‑on technical lead to build initial ETL/ELT pipelines using Python, SQL, and on‑premises infrastructure; develop programmatic solutions to clean, parse, and ingest legacy unstructured and structured data.
• Geospatial Integration: lead the integration between our on‑premises ESRI portal and the new Analytics Core; ensure spatial data seamlessly aligns with the multidimensional model.
• AI/ML Data Preparation: establish standards for feature engineering, ensuring the database architecture is optimized for future AI and ML applications within a classified environment.
• Governance & Compliance: enforce data governance, metadata tagging, and access control protocols in strict alignment with the DoD Data Strategy and classified network handling requirements.
• Cross‑Functional Collaboration & Integration:
  • Software Engineers: interface with engineers transitioning into data engineering.
  • GIS Specialist: collaborate closely to integrate programmatic GIS outputs into the broader AI‑ready database.
  • Junior Data Manager: partner to operationalize data governance, define data rules, and enforce quality control.
• Additional duties as assigned.
• Support occasional travel as required.
• Scheduled weekly hours: 40; day shift with occasional after hours and weekends.

• Bachelor’s Degree in Computer Science, Engineering, Information Systems, or a related technical field (equivalent work experience may be considered).
• 5‑9 years of real‑world experience in data management, preferably in support of federal government programs.
• Advanced proficiency in Python and SQL.
• Proven hands‑on experience building ETL/ELT pipelines and designing databases to clean and structure complex, messy legacy data.
• Experience with on‑premises infrastructure is required.
• Solid working knowledge of GIS data structures.
• Demonstrated understanding of the DoD Data Strategy.
• Ability to act as a technical anchor and establish standards for adjacent staff.
• Active DoD Security Clearance required; must obtain and maintain Security+ Certification.
• Must be a U.S. Citizen.

• Active TS/SCI security clearance is strongly preferred.
• Hands‑on experience with geospatial data (coordinates, spatial querying) and integration with ESRI portals.
• Experience architecting and engineering data solutions on classified systems (SIPR/JWICS).

$118,600 – $177,800

Oceaneering is a global provider of engineered services and products, primarily to the…