Data Engineer / Data Architect III

Oceaneering; Suitland (MD); On-site; USD 118,600 - 177,800; Full time

Job summary

Oceaneering is looking for a Lead Data Engineer / Data Architect in Suitland, Maryland to lead the development of the Analytics Core in a classified environment. This role involves 60% hands-on data engineering and 40% data architecture, requiring extensive experience with data management and strong skills in Python and SQL.

You will design data models, build ETL pipelines, and ensure data integrity while collaborating with cross-functional teams. Candidates need an active DoD Security Clearance and a Bachelor's in a related field.

Qualifications

• 5-9 years of real-world experience in data management.
• Advanced proficiency in Python and SQL.
• Proven experience in building ETL/ELT pipelines.
• Experience with on-premises infrastructure.

Responsibilities

• Design data models for complex, multi-modal data.
• Resolve attribution issues with historical data.
• Lead integration of geospatial data with the new Analytics Core.
• Establish standards for feature engineering.

Skills

Python

SQL

ETL/ELT pipelines

Data governance

Geospatial integration

Education

Bachelor’s Degree in Computer Science, Engineering, or Information Systems

Tools

ESRI portal

Job description

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.

Responsibilities

• 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 afterhours and weekends.

Required Qualifications

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

Desired Qualifications

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

Salary

$118,600 – $177,800

About Us

Oceaneering is a global provider of engineered services and products, primarily to the offshore energy industry. We develop products and services for use throughout the lifecycle of an offshore oilfield, from drilling to decommissioning. We operate the world's premier fleet of work‑class ROVs. Additionally, we are a leader in offshore oilfield maintenance services, umbilicals, subsea hardware, and tooling. We also use applied technology expertise to serve the defense, material handling, aerospace, science, and renewable energy industries.

Equal Opportunity Employer

All qualified candidates will receive consideration for all positions without regard to race, color, age, religion, sex (including pregnancy), sexual orientation, gender identity, national origin, veteran status, disability, genetic information, or other non‑merit factor.

About The Team

Oceaneering Aerospace and Defense Technologies (AdTech) delivers solutions that enable humans to work safely and effectively in harsh environments – from underwater to the outer reaches of space. Our innovative solutions support the development and application of practical, cost‑effective systems that meet our customers’ challenges – from routine to extreme. Our experience and expertise across multiple industries uniquely position us as a leader in the government, space, and maritime services markets. Our products and services meet the rigorous demands of the complex environments in which they operate, delivering results without compromising safety or reliability.