Backend Engineer

We're building a simple but powerful feature for a bank: enabling traders and analysts to ask natural language questions about Avaloq end-of-day reports and get instant answers powered by AI.

We're seeking a Backend Engineer to build the technical foundation for this proof-of-concept. Your main job: connect the LLM to Avaloq's MS SQL database through an MCP server so the AI can safely query financial data and answer questions like "What's our exposure to counterparty X?" or "Show me the P&L summary."

It's a focused technical challenge with real impact no overwhelming scope, just solid engineering to prove the concept works.

What You'll Do

• Set up an MCP server that connects our LLM to Avaloq's MS SQL database
• Map key database tables (positions, P&L, counterparties, etc.) so the AI understands what data exists
• Integrate the MCP server into the chat backend (Bun/Node.js)
• Write prompts and test queries to make sure the AI generates safe, accurate database queries
• Deploy the PoC and document how it works

Requirements

• Solid experience with Node.js/TypeScript backend development
• Comfortable working with relational databases (MS SQL Server or similar)
• Experience with LLM integrations or prompt engineering (or willingness to learn)
• Security-conscious: understand read-only access, audit logging, basic data governance
• Independent worker who enjoys solving clear technical problems

Benefits

• Location: remote
• Workload: 40-60%
• Duration: 2-3 months
• Start: asap
• Hourly rate: CHF 40+ (depending on qualifications)