Opens an external site
- Employment type
- Contract
- Experience level
- Senior · 5+ years
- Apply by
- Sep 26, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available
Job summary
Architect and build ETL pipelines for structured and unstructured data to support AI agents. Manage vector database infrastructure and implement real-time event-driven architectures for embedding updates.
Job details
You will architect ETL pipelines, manage vector databases, enforce governance, and build real-time data flows that continuously update embeddings and indexes. Your work ensures AI agents operate with fresh, trustworthy information. What You Will Do • Data Pipelines: Build ETL flows for structured/unstructured data, ensuring normalization, deduplication, and semantic consistency. • Vector Infrastructure: Manage pgvector, Azure AI Search, Redis vector indexing, and hybrid search layers. • Data Governance: Implement zero-trust access, privacy controls, and compliance within AI context pipelines. • Real-time Processing: Build event-driven architectures that continuously refresh embeddings and indexes. Required Qualifications • Deep experience with distributed data systems, SQL, and orchestration tools. • Experience tuning high-throughput database infrastructure. • Knowledge of Google’s GECX is a plus. • Familiarity with chunking strategies and embedding models. Skillset Requirements • ETL & Data Modeling: Designing pipelines for structured/unstructured data, normalization, deduplication, and semantic consistency. • Vector Databases: pgvector, Redis, Azure AI Search, hybrid search, and index optimization. • Distributed Data Systems: Kafka, Spark, Flink, or similar event-driven architectures. • Data Governance: Zero-trust access, privacy controls, compliance, and auditability. • Real-time Embedding Updates: Event-driven refresh pipelines for RAG and agent memory systems. • Chunking & Embeddings: Semantic chunking, metadata tagging, and embedding model selection. • Search Infrastructure: BM25, hybrid search, inverted indexes, and ranking algorithms. • Performance Tuning: High-throughput read/write optimization. • Data Quality & Lineage: Validation, schema enforcement, and lineage tracking (e.g., Great Expectations, OpenLineage).
What you’ll do
Architect and build ETL pipelines for structured and unstructured data to support AI agents. Manage vector database infrastructure and implement real-time event-driven architectures for embedding updates.
Requirements
Requires deep experience with distributed data systems, SQL, and orchestration tools. Candidates should be familiar with chunking strategies, embedding models, and high-throughput database tuning.
Listed skills
- Redis · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- ETL
- Data Modeling
- Pgvector
- Redis
- Azure AI Search
- Kafka
- Spark
- Flink
- Data Governance
- RAG
- Semantic Chunking
- Embedding Models
- BM25
- Hybrid Search
- Performance Tuning
- Data Lineage
Job areas
- Data & Analytics
- Technology
- Software
- Engineering
- Consulting
More jobs you can apply to directly
Similar opportunities posted by employers hiring on Jobs.ca, with no external application form.
Government of Ontario
Registered Nurse
SponsoredDirect employerEasy Apply- On-site
- Lindsay, ON
- Posted Sep 17, 2026
Bédard Ressources Humaines
ITAD Services Representative #1265
SponsoredDirect employerEasy Apply- On-site
- Mississauga, ON
- Posted Sep 16, 2026
BC Public Schools
Manager, Financial Planning and Analysis
SponsoredDirect employerEasy Apply- On-site
- Victoria, BC
- Posted Sep 18, 2026
