Senior Data Engineer

Amivero is hiring a Senior Data Engineer to support a serverless, AWS-based web application and its PostgreSQL data layer. The role focuses on data modeling, migrations, vector search and generative AI retrieval pipelines, and collaboration with application engineers to improve the computing environment.

Responsibilities

• 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

Skills

• US Citizenship required to obtain DHS Public Trust
• Bachelor's degree +3 years of relevant experience
• Python and AWS RDS experience
• 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)

Company Overview