NWS Lead Database Engineer
General Dynamics Mission Systems
Pittsfield, MA, United States14h ago
Key details
- Salary
- $110K–$122K/yr
- Location
- Pittsfield, MA, United States
- Work style
- Hybrid
- Level
- Senior
- Experience
- 5–8 yrs
- Function
- Software engineering
- Focus area
- Data engineering & Analytics
- Visa sponsorship
- US citizens only
- Posted
- 14h ago
Skills
About the role
Basic Qualifications
Requires a Bachelor’s degree in Software Engineering, or a related Science, Engineering or Mathematics field. Also requires 5+ years of job-related experience, or a Master's degree plus 3 years of job-related experience. Agile experience preferred.
CLEARANCE REQUIREMENTS: Department of Defense Secret security clearance obtainable within reasonable time based on requirements. Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access to classified information. Due to the nature of work performed within our facilities, U.S. citizenship is required.
Responsibilities for this Position
ROLE AND POSITION OBJECTIVES:
As the NWS Lead Database Engineer for General Dynamics Mission Systems, you will provide technical leadership for backend, embedded data-management, and data-integration activities supporting a complex, distributed tactical system. You will work across software, systems, hardware, test, and configuration-management disciplines to mature the product, improve development practices, and deliver scalable capabilities.
This role requires an engineer who can lead technical execution while remaining hands-on with database architecture, data modeling, SQL development, ETL processes, implementation, reviews, planning, and mentoring. The selected candidate will help guide the team’s transition toward memory-safe and type-safe technologies, including Go for new development and JavaScript for existing applications.
Key Responsibilities
- Serve as the technical lead for a software team, providing technical direction, mentoring, code reviews, and implementation support.
- Lead the design and sustainment of database schemas, data models, SQL queries, data-access services, and data-integrity controls.
- Define and support ETL processes for extracting, transforming, validating, and loading embedded-system telemetry, event, diagnostic, configuration, test, and operational data.
- Coordinate ESD data interfaces, including data mapping, schema changes, interface compatibility, error handling, and end-to-end data validation.
- Break down features into well-defined, testable tasks aligned with product, subsystem, and data-interface boundaries.
- Partner with the Product Owner, Scrum Master, program leadership, Systems Engineering, and SC&I to plan work, manage priorities, and align with coding and development standards.
- Support Agile execution, including sprint planning, backlog refinement, technical estimation, retrospectives, and delivery tracking.
- Develop, review, and maintain technical artifacts, including database design documentation, data models, interface documentation, test plans, user manuals, administrator manuals, and software-development documentation.
- Support financial and program-planning activities, including COCOMO estimates, Basis of Estimate (BOE) inputs, and Software Bill of Materials (SW BOM) development.
- Conduct and oversee code reviews, ensuring changes meet quality, security, maintainability, testability, data-integrity, and Definition-of-Done expectations.
- Establish data-quality, error-handling, reconciliation, auditability, monitoring, backup/recovery, and retention practices for database and ETL workflows.
- Assess and improve team maturity, code maturity, codebase size and stabilization trends, development efficiency, and scalability across a distributed environment supporting 3,000+ endpoints.
- Help mature CI/CD and DevSecOps capabilities, including automated unit testing, code-quality analysis, configuration management, and repeatable production builds.
- Establish, maintain, or support test beds on SWFPAC.
- Identify technical risks, dependencies, data-interface concerns, and architectural issues early; communicate options, tradeoffs, and recommendations to leadership.
- Mentor existing technical leadership and individual contributors, helping build sustainable team capability and knowledge transfer.
Database Lead Focus Areas
The Backend Lead will additionally support:
- Backend architecture, database design, data modeling, schema management, SQL development, and database performance optimization.
- ETL and data-pipeline development for embedded-system telemetry, event logs, diagnostics, configuration, test, and operational data.
- ESD integration, including data mapping, interface definition, schema/version compatibility, error handling, and end-to-end data validation.
- Data ownership, access control, retention, auditability, backup/recovery, and configuration-management practices for system and support data.
- Middleware and Data Distribution Service (DDS) integration, including evaluation of Rust compatibility with RTI DDS.
- Embedded software and firmware-adjacent development, including FreeRTOS and TCP/IP interfaces, as applicable.
- Containerization, virtualization, CI/CD pipelines, and deployment architecture.
- Migration and adoption of memory-safe/type-safe technologies, particularly Go and Rust where appropriate.
- Build and release management, including Git-based merge, build, and configuration-management workflows.
Preferred Skills and Experience
We encourage you to apply if you have experience with:
- Leading, or serving as the deputy/backup lead for, delivery of a mature tactical, mission, or strategic software system.
- Software architecture, technical planning, feature decomposition, and system-level design.
- Frontend and/or backend development in distributed, multi-component systems.
- Go, Rust, JavaScript/TypeScript, C#, Java, C/C++, or other memory-safe/type-safe programming languages.
- Database architecture, relational database design, data modeling, schema management, SQL, and backend-service development.
- Strong SQL experience, including query development, performance tuning, indexing, transactions, stored procedures, and database troubleshooting.
- ETL or data-pipeline experience, including data extraction, transformation, validation, reconciliation, error handling, and monitoring.
- Experience integrating embedded telemetry, event logs, diagnostics, configuration, test, or operational data with backend databases and services.
- Experience supporting ESD interfaces, including data mappings, interface contracts, and schema compatibility.
- Experience with Oracle, PostgreSQL, SQL Server, MongoDB, or similar relational and NoSQL database technologies.
- Object-oriented software design and modern software-design principles.
- Data Distribution Service (DDS), middleware integration, and RTI DDS.
- Embedded software development, FreeRTOS, TCP/IP, and firmware-adjacent interfaces.
- Linux development or administration.
- Docker, Kubernetes, containerization, virtualization, and deployment automation.
- CI/CD, DevSecOps, automated testing, static analysis, production builds, and configuration management.
- Git, GitLab, source-control workflows, and merge/review practices.
- Software requirements decomposition; preliminary and critical design; implementation and unit testing; and requirements-based testing.
- Factory, hardware, or integration-test environments.
- Agile delivery, Product Owner responsibilities, or SAFe Agile Product Owner/Product Manager practices.
What Sets You Apart
- Strong technical judgment and the ability to guide engineers through complex or ambiguous database, data-flow, and system-integration decisions.
- Ability to translate embedded-system, operational, test, and diagnostic-data needs into scalable database models, SQL solutions, ETL workflows, and interface contracts.
- Demonstrated ability to balance hands-on engineering work with team leadership, mentoring, planning, and stakeholder communication.
- Experience improving engineering processes, data quality, workflows, code quality, and automation in an established product environment.
- Ability to identify data-quality, performance, timing, availability, security, and integration risks early and communicate practical mitigation options.
- Ability to communicate technical risks, tradeoffs, estimates, and recommendations clearly to both technical and program stakeholders.
- Commitment to high-quality, maintainable, secure, and scalable software and data solutions.
- Ability to lead a developing team, create clarity around expectations, and foster a collaborative and accountable engineering culture.
- Willingness to take reasonable, managed risks while maintaining disciplined engineering, testing, data-management, and configuration-management practices.
Workplace Options:
This position is primarily on-site, with opportunities for hybrid/flex work as allowable. While on-site, you will be part of the GDMS Pittsfield, Massachusetts Engineering Team.
#LI-Hybrid
Salary Note
This estimate represents the typical salary range for this position based on experience and other factors (geographic location, etc.). Actual pay may vary. This job posting will remain open until the position is filled.Combined Salary Range
USD $110,175.00 - USD $122,225.00 /Yr.Company Overview
General Dynamics Mission Systems (GDMS) engineers a diverse portfolio of high technology solutions, products and services that enable customers to successfully execute missions across all domains of operation. With a global team of 12,000+ top professionals, we partner with the best in industry to expand the bounds of innovation in the defense and scientific arenas. Given the nature of our work and who we are, we value trust, honesty, alignment and transparency. We offer highly competitive benefits and pride ourselves in being a great place to work with a shared sense of purpose. You will also enjoy a flexible work environment where contributions are recognized and rewarded. If who we are and what we do resonates with you, we invite you to join our high-performance team!
Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.