Design and implement a secure data engine to transform complex relational databases into an agent-ready data layer using MCP. Build ETL pipelines, knowledge graphs, and RAG infrastructure to enable AI models to consume data safely.
Ciklum is looking for a Senior Data Engineer to join our team full-time in India.
We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.
About the role:
As a Senior Data Engineer, become a part of a cross-functional development team engineering experiences of tomorrow. You will be responsible for transforming the client’s complex relational core databases into an "agent-ready" data layer. You will build the ETL pipelines and materialized views that allow agents to consume data safely via the Model Context Protocol (MCP), ensuring that AI models never query raw databases directly to prevent hallucinations and security risks.
Responsibilities:
- The Data Engine (ETL/ELT): Design and implement the "Data Engine" responsible for extracting, cleaning, and materializing proprietary Real Estate data into secure, structured views for agent consumption
- Multi-Layered Data Architecture: Provision and optimize a sophisticated data stack, including PostgreSQL (relational/OLTP), ChromaDB or PGVector (Vector Stores for embeddings), and GraphDB (Neo4j) for relational knowledge mapping
- Agent-Data Interfacing: Develop and maintain Model Context Protocol (MCP) adapters and secure SDK endpoints, ensuring agents interact with data through governed interfaces rather than direct database access
- Knowledge Graph Engineering: Build the initial Knowledge Graph using proprietary client data to model complex relationships between leases, entities, and CAM charges
- RAG Infrastructure: Configure and maintain the Retrieval-Augmented Generation (RAG) knowledge base, including document ingestion pipelines and metadata management for lease abstracts and historical records
- Data Isolation & Security: Implement strict logical data isolation models to ensure multi-tenant security, preventing data leakage between different client tenants within the shared platform foundation
Requirements:
- Data Engineering Mastery: Deep expertise in building production-grade ETL/ELT pipelines using Python and SQL; experience with dbt is highly valued
- AI Data Stores: Hands-on experience with Vector Databases (Chroma, PGVector) and Graph Databases (Neo4j or Cognee) for AI-native applications
- Cloud Infrastructure: Proven track record of managing data services within the AWS stack, including RDS, S3, and event-driven architectures
- Security & Compliance: Experience building data solutions that meet SOC 2 and GDPR standards, with a focus on data masking and zero-trust access patterns
- Domain Expertise: Familiarity with Commercial Real Estate data structures (Leases, CAM, Invoices) is a significant advantage
Desirable:
- Orchestration: Experience with Temporal for managing long-running data workflows
- Agentic Frameworks: Understanding of how data interacts with frameworks like LangChain or LangGraph
What`s in it for you?
- Strong community: Work alongside top professionals in a friendly, open-door environment
- Growth focus: Take on large-scale projects with a global impact and expand your expertise
- Tailored learning: Boost your skills with internal events (meetups, conferences, workshops), Udemy access, language courses, and company-paid certifications
- Endless opportunities: Explore diverse domains through internal mobility, finding the best fit to gain hands-on experience with cutting-edge technologies
- Care: We’ve got you covered with company-paid medical insurance, mental health support, and financial & legal consultations
About us:
At Ciklum, we are always exploring innovations, empowering each other to achieve more, and engineering solutions that matter. With us, you’ll work with cutting-edge technologies, contribute to impactful projects, and be part of a One Team culture that values collaboration and progress.
India is a strategic innovation hub for Ciklum, with growing teams in Chennai and Pune leading advancements in EdgeTech, AR/VR, IoT, and beyond. Join us to collaborate on game-changing solutions and take your career to the next level.
Explore, empower, engineer with Ciklum!
Interested already? We would love to get to know you! Submit your application. We can’t wait to see you at Ciklum.
#LI-MA1