Senior Data Engineer

Amivero; Northern (KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Amivero is seeking a Senior Data Engineer to join our team supporting a serverless, AWS-based web application. You will own the Postgres data layer, migrations, and the retrieval pipeline behind its generative AI features, collaborating with engineers to deliver reliable, scalable data services for mission-critical government IT systems.

Ideal candidates have 3+ years of software development experience, deep Python expertise, and hands-on work with SQLAlchemy, Alembic, PostgreSQL, and AWS

Qualifications

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

Responsibilities

• Design and maintain the application's Postgres data model on AWS RDS, including schema design, indexing, and query optimization.
• Write and review SQLAlchemy models and migrations (Alembic) across environments.
• Support vector search and similarity search for generative AI features.
• Build/maintain ingestion and embedding pipelines with AWS Bedrock, with verification.
• 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.
• Work within AWS GovCloud constraints (IAM, RBAC).
• Collaborate with application engineers to improve the computing environment.

Skills

Python

PostgreSQL

SQLAlchemy

Alembic migrations

AWS serverless

AWS RDS

Vector search

AWS Bedrock

CI/CD

GitHub

REST APIs

RBAC/IAM

JSON/XML/CSV

Tools

AWS Lambda

API Gateway

Step Functions

S3

Jenkins

CloudBees

PGVector/OpenSearch Serverless

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 RequirementsUS Citizenship required to obtain DHS Public TrustBachelor's degree +3 years of relevant experiencePython and AWS RDS experienceThe 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.