Full Stack Developer (Python, Django, SQL) :: Need 12+ years

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