Senior Backend Software Engineer

New
A
ASRC FederalGovernment contracting
Source API remote eligibility restrictions: United StatesFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page

Job Details

Experience
8-10 years experience in related field
Required Skills
AWSGraphQLSQLETLJava

Requirements

  • 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 Java Spring ORM and persistence frameworks such as JPA/Hibernate.
  • Experience writing and optimizing JPQL and SQL queries, including troubleshooting ORM-generated SQL.
  • Strong SQL proficiency, including 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 experience in a related field.

Responsibilities

  • Design, develop, and maintain Java-based ETL workflows that extract, transform, validate, and load data from databases, APIs, files, and other source systems.
  • Implement data cleansing, transformation, deduplication, reconciliation, incremental loading, batching, retry, and recovery processes.
  • Build and maintain ORM-based data access layers using Java persistence frameworks such as JPA/Hibernate.
  • Develop and optimize SQL queries, inspect ORM-generated SQL, and analyze database execution plans to identify performance bottlenecks.
  • Improve database performance through indexing, query restructuring, batching, pagination, and relationship-loading strategies.
  • Design and maintain relational schemas, constraints, indexes, and versioned database migrations.
  • Implement and optimize OpenSearch or Elasticsearch queries, filters, and aggregations, and maintain consistency between source data and search indexes.
  • Monitor pipeline reliability, data quality, processing throughput, and query response times; troubleshoot production issues.
  • Create automated tests for transformation logic, database interactions, data integrity, and recovery behavior.
  • Develop GraphQL APIs and resolvers and optimize database integrations using Amazon Aurora within Amazon RDS in AWS.
View Full Description & ApplyYou'll be redirected to the employer's site
View details
Apply Now