Senior Backend Software Engineer (supporting NOAA)

7 days ago

Silver Spring, MD, USASenior / Staff+

Responsibilities

Design, develop, and maintain Java-based ETL workflows for extracting, transforming, validating, and loading data.
Implement data cleansing, deduplication, reconciliation, incremental loading, batching, retry, and recovery processes.
Build ORM-based data access layers using JPA/Hibernate, including entity mappings, relationships, and transaction management.
Develop and optimize JPQL and SQL queries, analyze execution plans, and resolve database performance bottlenecks.
Design and maintain relational schemas, constraints, indexes, and versioned database migrations.
Implement and optimize OpenSearch or Elasticsearch queries, filters, aggregations, and source-data synchronization.
Monitor pipeline reliability, data quality, throughput, and query response times while troubleshooting production issues.
Create automated tests for transformation logic, database interactions, data integrity, and recovery behavior.
Develop and optimize GraphQL APIs and resolvers for backend data retrieval and integration.
Integrate Amazon Aurora within Amazon RDS on AWS, including connection management, migrations, ETL workflows, and performance tuning.
Collaborate with engineers and stakeholders on requirements, data mappings, and pipeline and database designs.

Strong Java development experience building and supporting production backend applications.
Demonstrated experience designing, developing, and maintaining ETL pipelines and data integration workflows.
Hands-on experience with Spring ORM and persistence frameworks such as JPA/Hibernate.
Experience writing and optimizing JPQL and SQL, including troubleshooting ORM-generated SQL.
Strong SQL proficiency with complex joins, common table expressions, window functions, aggregations, and set-based processing.
Experience analyzing database execution plans and improving query performance through indexing and query changes.
Experience with relational data modeling, schema migrations, entity relationships, and transaction management.
Understanding of database isolation levels, locking, and concurrency.
Experience implementing data validation, incremental processing, error handling, and recoverable data workflows.
Experience with version control, code review, automated testing, and software deployment practices.
Ability to explain production performance improvements using measured results.
BS/BA degree or equivalent plus 8–10 years of related experience.
Preferred experience with workflow orchestration, job scheduling, change data capture, pipeline monitoring, ORM performance diagnosis, and large-dataset processing.
Familiarity with Apache Spark for ETL and distributed data processing.

Remote, full-time position.
Health care, dental, vision, and life insurance may be offered.
401(k) may be offered.
Education assistance may be offered.
Paid time off, holidays, and other legally required paid leave may be offered.
Competitive pay and benefits packages are available; compensation depends on experience, skills, education, location, internal equity, business needs, and other permitted factors.

11-50 employees