Software Engineer III, DBData Assurance

Description

We are seeking an experienced data engineer to join our team! OTECH produces and maintains unique underwater systems typically for US Navy and other US Government Department of War customers. Our projects are all one-of-a-kind. Projects range from quick burn to lifecycle management of fielded systems. As a data engineer at Oceaneering Technologies (OTECH) you will be responsible for developing maintaining and optimizing data storage systems.

The data engineer will support multiple stakeholders across the project including software developers systems engineers integrated logistics support team members project managers. The ideal candidate should process strong technical abilities to solve complex data problems a willingness to learn new technologies/tools and be comfortable articulating data concepts to stakeholders of varying levels of data proficiency.

This role is responsible for ensuring that database systems and the data flowing through them are accurate consistent secure traceable and reliable throughout the application lifecycle. The role combines database development with data-quality and verification responsibilities. Typical work includes designing and maintaining relational database schemas stored procedures queries data interfaces ETL/ELT processes and validation routines; verifying data integrity across system boundaries; identifying anomalous incomplete duplicated or inconsistent data; and developing automated checks that confirm data conforms to defined schemas business rules interface specifications and quality requirements. The developer should be proficient with DDS SQL and database technologies such as PostgreSQL MariaDB/MySQL SQL Server or Oracle along with scripting or development languages such as Python Java or C. Experience with data modeling schema/version management transaction processing indexing query optimization and structured data formats such as JSON XML or Avro is also valuable.

The assurance portion of the role requires strong knowledge of data verification validation provenance and configuration control. The developer should be able to establish measurable data-quality criteria implement automated integrity and regression tests reconcile data between producers and consumers and provide evidence that stored or transmitted data remains complete and correct. This includes supporting requirements traceability test automation logging/auditing cybersecurity controls backup and recovery and root-cause analysis of data-related a distributed or mission-oriented system the role may also involve validating data exchanged through messaging middleware APIs DDS/Kafka interfaces containers and other distributed services. The ideal candidate combines software-development discipline with a verification mindsetunderstanding not only how to store and transform data but how to demonstrate that the resulting data can be trusted.

Responsibilities

• Design build and maintain batch data pipelines and ingestion workflows.
• Develop optimize and maintain cloudenabled data infrastructure and storage solutions.
• Implement ETL/ELT processes to extract transform validate and load data from multiple sources.
• Automate data workflows for ingestion transformation aggregation and quality enforcement.
• Build maintain and deploy data products and analytics solutions on cloud platforms (e.g. Azure).
• Partner with crossfunctional teams to create dashboards and visualization tools.
• Ensure data accuracy consistency traceability and security across all systems and interfaces.
• Implement validation routines anomaly detection and automated integrity checks.
• Support data modeling schema design DDS topic development and database architecture.
• Monitor system performance and implement optimization strategies for reliability and efficiency.
• Develop and maintain data compression and storageoptimization strategies.
• Contribute to data management CDRL materials and documentation.
• Communicate effectively with technical and nontechnical team members.
• Support verification configuration control auditing and compliance requirements.
• Provide feedback on software and data design choices and integration approaches.

Qualifications

Essential Qualifications

• BS in Computer Science Computer/Electrical Engineering Mathematics Data Science or related field (or commensurate experience).
• 5 years of practical data engineering experience.
• Advanced SQL proficiency and experience with relational database design.
• Experience with data ingestion tools and building ETL/ELT pipelines.
• Working knowledge of cloud solutions and workflow/pipeline orchestration tools.
• Strong problemsolving communication and organizational skills.
• Ability to obtain and maintain a DoW security clearance.
• Must be a U.S. citizen.

Preferred Qualifications

• Experience with cloud data warehouses and largescale data systems.
• Experience with Linux and scripting languages.
• Proficiency in Python Java C C# or related languages.
• Experience with Jira Git or similar tools.
• Experience with NoSQL systems (e.g. MongoDB Cassandra Neo4j).
• Experience working with large datasets and distributed data environments.
• Experience with MBSE/Digital Twin tools (Cameo Syndeia PLM/ERP).
• Familiarity with DDS middleware and distributed messaging systems.
• Knowledge of data verification provenance configuration control and automated QA/QC.

Additional

Additional duties as assigned.

We offer a comprehensive and competitive benefits package. Employee benefits vary by role however may include Health and Wellness Mental Health Retirement Savings Life and Disability Paid Maternity and Parental Leave Paid Time Off Tuition Reimbursement and an Employee Assistance Program.

Compensation $118000.00 - $177800.00

Required Experience:

IC