Senior Data Engineer

Amivero

Idaho

On-site

USD 110,000 - 170,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Amivero in Idaho seeks a Senior Data Engineer to help modernize government IT systems with a serverless AWS-based data platform. You will design the Postgres data model on AWS RDS, implement migrations with SQLAlchemy and Alembic, and support the retrieval pipeline behind generative AI features.

You will collaborate with application engineers, data scientists, and security teams to ensure scalable, secure data flows, maintain CI/CD pipelines in Jenkins and CloudBees, and optimize performance as

Qualifications

  • 3+ years industry experience in software development.
  • Expertise in Python.
  • Production experience with SQLAlchemy and Alembic migrations.
  • Advanced PostgreSQL knowledge, including indexing and performance tuning.
  • Experience with AWS serverless services and AWS RDS.
  • Hands-on with vector search and embeddings (PGVector/OpenSearch Serverless).
  • Experience building with AWS Bedrock or similar LLM APIs.
  • CI/CD pipelines with Jenkins/CloudBees and GitHub.
  • Experience with REST/JDBC APIs and data formats (JSON, XML, CSV).
  • Familiarity with AWS IAM RBAC.

Responsibilities

  • Design and maintain the application's Postgres data model on AWS RDS.
  • Write and review SQLAlchemy models and migrations.
  • Support vector search and similarity search for AI features.
  • Build ingestion and embedding pipelines with AWS Bedrock.
  • Support data flows for structured and unstructured data.
  • Contribute to CI/CD pipelines in Jenkins and CloudBees.
  • Work within GitHub repositories and code reviews.
  • Evaluate data models and optimize as usage grows.
  • Operate within AWS GovCloud IAM RBAC constraints.
  • Collaborate with application engineers and IT teams.

Skills

Python
PostgreSQL
SQLAlchemy
Alembic
Vector search
APIs
CI/CD
GitHub

Education

Bachelor's degree or higher

Tools

AWS Lambda
AWS API Gateway
AWS Step Functions
AWS S3
AWS RDS
PGVector
OpenSearch Serverless
Bedrock
Jenkins
CloudBees
GitHub

Job description

Description

The Amivero TeamAmivero’steam of ITprofessionalsdelivers digital services that elevate the federal government, whether national security or improved government services. Our human-centered, data-driven approach is focused ontruly understandingthe environment and the challenge, and reimagining with our customer how outcomes can be achieved.Our team of technologistsleveragemodern, agile methods to design and developequitable, accessible, and innovative data and software services thatimpacthundreds of millions of people.As a member of theAmiveroteam you will use your empathy for a customer’s situation, your passion for service, your energy for solutioning, and your bias towards action to bring modernization tovery important, mission-critical, and public service government IT systems.Special Requirements

  • US Citizenship required to obtain DHS Public Trust
  • Bachelor's degree +3 years of relevant experience
  • Python and AWS RDS experience

The Gist...

Our Senior Data Engineer will work as part of a team supporting a serverless, AWS-based web application the Postgres data layer it runs on, the migrations that evolve it, and the retrieval pipeline behind its generative AI features. You will use your passion for data, background in problem solving, and customer engagement to advance the build of this platform and its associated environment.
What Your Day Might Include…
  • Working with the team to design and maintain the application's Postgres data model on AWS RDS, including schema design, indexing strategy, and query optimization.
  • Writing and reviewing SQLAlchemy models and queries, and developing Alembic migrations that run cleanly across environments.
  • Supporting the vector search and similarity search capabilities behind the application's generative AI features.
  • Helping build and maintain ingestion and embedding pipelines that integrate with AWS Bedrock, with inline verification and validation.
  • Supporting data flows for both structured relational data and unstructured document content.
  • Contributing to CI/CD pipelines in Jenkins and CloudBees.
  • Working within GitHub repositories and the team's code review process.
  • Evaluating data models and making optimization recommendations as usage and data volume grow.
  • Working within AWS GovCloud constraints, including IAM security and Role Based Access Control (RBAC).
  • Partnering closely with application engineers and other IT units to improve the overall computing environment.
Qualifications
  • 3+ years industry experience with software development projects and a passion for solving complex problems.
  • Expertise in Python.
  • Production experience with SQLAlchemy and Alembic, including writing and troubleshooting migrations against live databases.
  • Advanced working SQL knowledge with PostgreSQL specifically — query authoring, execution plan analysis, indexing, and performance tuning.
  • Experience with AWS serverless services (Lambda, API Gateway, Step Functions, S3) and AWS RDS.
  • Hands-on experience with vector search and embeddings — PGVector, OpenSearch Serverless, or a comparable vector store.
  • Experience integrating with AWS Bedrock or comparable LLM and embedding APIs.
  • Experience building and maintaining CI/CD pipelines, ideally with Jenkins and CloudBees, and working in GitHub-hosted repositories.
  • Experience with APIs (REST, JDBC) and data formats (JSON, XML, CSV).
  • Familiarity with AWS IAM security and Role Based Access Control (RBAC).

EOE/M/F/VET/DISABLED

All qualified applicants will receive consideration without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteranin accordance withapplicable federal,stateand local laws.Amiverocomplies withapplicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

API Engineer
API Engineer

Amivero • United States

On-site
USD 130,000 - 180,000
API Engineer
API Engineer

Amivero • Idaho

On-site
USD 120,000 - 160,000
Intel Analyst
Intel Analyst

Amivero • Idaho

On-site
USD 85,000 - 115,000
Senior Data Engineer
Senior Data Engineer

Valiant Technologies LLC • Sunnyvale (CA)

On-site
USD 150,000 - 190,000
Senior Data Engineer
Senior Data Engineer

Robotics Technologies • Sunnyvale (CA)

On-site
USD 140,000 - 200,000
Senior Data Engineer
Senior Data Engineer

Quantum Technologies LLC • Sunnyvale (CA)

On-site
USD 140,000 - 200,000
Senior Data Engineer
Senior Data Engineer

Ethereum Technologies LLC • Sunnyvale (CA)

On-site
USD 160,000 - 210,000
Senior Data Engineer
Senior Data Engineer

Ryde Technologies, LLC • Virginia (MN)

Hybrid
USD 150,000 - 230,000
Data Engineer
Data Engineer

Ryde Technologies, LLC • Virginia (MN)

Hybrid
USD 120,000 - 150,000
Senior Data Engineer
Senior Data Engineer

ANAUTICS INC • Oklahoma City (OK)

On-site
USD 90,000 - 120,000