Senior Data Engineer: AWS & AI-Powered Data Platform

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

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