Job Title: Full-Stack BI Application Developer
Location: St Louis, MO (Only On-Site)
Hire Type: Long-term contract
Moving from Excel- and MSTR-bound reporting into interactive, governed web applications. You''ll join a fast-moving group that owns these apps end-to-end: requirements, design, backend, frontend, deployment, and ongoing support. You''ll have direct exposure to senior business stakeholders and broad latitude to shape how we build.
What you''ll do
- Build new Django apps end-to-end on BI Portal: data layer, service layer, REST APIs, templates, and JS
- Translate vague business asks into specs, prototypes, and shipped features
- Own data pipelines from Redshift to UI: SQL stored procedures, parallel query orchestration, Redis caching, Celery jobs
- Design clean, accessible UIs (Bootstrap 5, AG Grid, Chart.js / Plotly) — not just functional, polished
- Take ad-hoc requests, scope them, push back when needed, and deliver
- Collaborate on agent and MCP server design as our AI tooling evolves
Must-haves
- Strong Python (3.11+), Django, Django REST Framework
- Strong SQL - comfortable reading 500+ line queries, writing CTEs, window functions, and tuning on a real warehouse
- Redshift or similar columnar warehouse experience (Snowflake, BigQuery, Synapse all count)
- PostgreSQL for application data
- Redis caching patterns (key design, TTLs, invalidation)
- Front-end fundamentals: HTML, CSS, vanilla JS, Bootstrap; comfortable building UI without a framework
- Git, code review, and a real sense of ownership
Strong pluses
- AWS (ECS / ASG, S3, Secrets Manager, IAM, CloudWatch)
- Docker, GitLab CI/CD, nginx
- Celery, async task design
- Experience building or integrating LLM agents, MCP servers, or RAG pipelines
- UI/UX sensibility - can prototype a wireframe in an afternoon and iterate
- Working knowledge of SAML SSO, AD groups, and enterprise auth
Working Style
- Honesty. Tell us when something is wrong, when an estimate slips, when a design needs to change.
- Comfortable using AI dev tools (Kiro, Claude, Cursor) as a force multiplier, but capable of debugging and reasoning about output without depending on them
- Brings ideas to the table, not just executes tickets
Stack you''ll touch day one Python 3.13 · Django 6 · DRF · PostgreSQL 16 · Redshift · Redis 7 · Celery · Bootstrap 5 · AG Grid · Chart.js · Docker · GitLab CI · AWS · Kiro / Claude