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