ChiStats - Data Engineer - Python/SQL

Description : Data EngineerYear of Experience : 3-4 YearsLocation : Hybrid, PuneShift Timings - 02 : 30 PM to 11 : 30 AM (Mon-Fri)Department : Information TechnologyJob Description : At ChiStats, were on the lookout for a passionate Data Engineer to help us shape the future of intelligent solutions.Youll join a fast-moving, innovation-driven team solving real-world problems using the latest in Python-based data stacks, scalable APIs, modern databases, and cloud-native infrastructure.If you enjoy solving complex data challenges and working with emerging AI technologies, the Data Engineer role at Bold Penguin is for you. Youll collaborate with our engineering and analytics teams to build intelligent data pipelines and AI-driven systems that enhance how small business owners shop, quote, and bind commercial insurance. Your work will directly influence end-user experiences in production : - Collaborate with Senior Data Engineers, Data Analysts, and AI specialists to connect, extract, and transform data from diverse structured and unstructured sources.- Design and optimize large-scale data processing pipelines to support both traditional analytics and AI-driven workloads.- Build APIs and microservices that power intelligent systems leveraging LLMs, embeddings, and AI agents.- Implement and maintain vector databases and semantic search pipelines for retrieval-augmented generation (RAG) and contextual chat experiences.- Contribute to prompt engineering, model evaluation, and orchestration workflows that enable autonomous AI agents to interact with data and tools.- Integrate AI frameworks and orchestration tools (e.g., LangChain, LlamaIndex, CrewAI, or similar) into production data services.- Continuously improve reliability and scalability by identifying enhancements to processing, parallelization, and search pipelines.- Troubleshoot and resolve production issues to exceed SLAs.Qualifications : - Bachelors degree in Computer Science, Computer Engineering, Data Science, or a related field.- 2+ years of experience in software or data engineering roles.- Strong proficiency in Python and one other language (Java, Node.js, or Go); with experience developing APIs in a microservices architecture- Strong understanding of data modeling and database technologies, including PostgreSQL and MongoDB.- Experience building or integrating with AI/LLM-powered applications, including prompt templates, embeddings, and RAG pipelines.- Hands-on experience with AI agent frameworks (e.g., LangChain, CrewAI, OpenDevin, or AutoGen) and vector databases (e.g., Pinecone, FAISS, Weaviate, or Chroma).- Working knowledge of CI/CD pipelines and cloud infrastructure (AWS or CNCF toolkits).- Excellent written and verbal communication skills, with the ability to document and present complex systems clearly.- (Preferred) Experience with data orchestration frameworks like Apache Airflow or Prefect.- (Preferred) Familiarity with insurance or financial data ecosystems.Additional Information : Why ChiStats? : At ChiStats, we believe our people are our greatest strength. That's why we offer a holistic benefits package designed to support your wellbeing, professional growth, and financial security so you can thrive both at work and in life.Flexible & Remote Work Options : We understand that life happens and we respect individual circumstances. Whether you're navigating a personal transition or simply value work-life balance, we offer the flexibility to help you succeed on your terms.Financial Wellbeing : We care about your future as much as your present. Our benefits include : - Provident Fund contributions- Comprehensive Healthcare CoverEmployee Wellbeing & Family Support : We offer inclusive leave policies such as maternity and paternity leave, recognizing the importance of family time and lifes big moments.Recognition That Matters : Our ChiStats Honors Platform is designed to celebrate achievements, milestones, and day-to-day excellence because recognition should be timely, meaningful, and part of our culture.Growth Through Learning Elevate : We invest in your continuous learning through our internal training platform, Elevate, which identifies personalized development needs and offers targeted upskilling opportunities across tech, tools, and soft skills.Company Description : Chistats is a data science company helping clients leverage data to accelerate and augment business value.- At the core, our team of passionate data scientists, love solving complex problems for clients and partners.- We are able to do so through a solid research and development foundation (#5 individual patents and #20 publications and growing).- At one spectrum, we've helped Asia's largest Oil & Gas company in remote monitoring of the pumps and generating early warning signals before the asset failures.- On another spectrum, we are working with the largest Defense company in India on a strategic project with the Indian Navy in the area of signal processing.- As part of recent recognitions, Chistats is part of the NASSCOM, CoE for IoT and AI incubation center. And, Chistats is also a winner of DRDO, Dare to Dream Innovation Contest 2.0.Chistats is at the forefront of leveraging data science and artificial intelligence to deliver impactful business solutions (ref:hirist.tech)