Senior Business Intelligence Developer
Brooksource
St. Louis, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 114KJob location
St. Louis, United States of America
Tech stack
API
Artificial Intelligence
Airflow
Data analysis
Audit Trail
Databases
Continuous Integration
Data Governance
ETL
Data Security
Relational Databases
Python
PostgreSQL
Microsoft SQL Server
Role-Based Access Control
Redis
Standard Sql
SQL Databases
Tableau
TypeScript
Web Application Frameworks
Workflow Management Systems
Okta
React
Large Language Models
FastAPI
Gitlab-ci
Kubernetes
Docker
Alteryx
Job description
Owns data products end-to-end: from source-system ingestion and data-lake modeling, through a governed semantic layer, to the custom applications and dashboards that deliver metrics to executives and operational teams. This is a hands-on role that also spans the platform and release engineering needed to run these products in production., * Design, build, and operate ingestion and transformation pipelines (ELT/ETL, CDC, API and file-based sources) into an analytical data lake.
- Model data and define trustworthy, reusable metrics in a semantic layer; ensure every metric traces to the source of truth.
- Develop and maintain full-stack data applications (TypeScript/React front ends; Python/FastAPI back ends) that serve metrics directly from the semantic layer.
- Deliver executive- and operator-facing dashboards and reports (custom apps, Kiro, and Tableau), including monthly/quarterly operational reviews.
- Own the platform: containerized deployment (k3s/Helm), highly-available databases (PostgreSQL HA), CI/CD pipelines, release promotion, and post-deploy validation.
- Implement data governance: cataloging, SSO/RBAC, PII protection, and comprehensive audit logging.
- Build and integrate AI/agentic tooling (MCP servers, chat agents) against governed, access controlled datalake.
- Provision and support cross-team data access; peer-review SQL, models, and dashboards., Python / FastAPI, TypeScript / React, Cube Core (semantic layer), PostgreSQL (HA/Patroni), MSSQL sources, Airbyte, Alteryx, Temporal, Redis, Docker + k3s + Helm, GitLab CI/CD, Tableau, Dataedo, Keycloak/SSO, MCP / Strands agents.
Requirements
- Strong SQL and Python; proven ELT/ETL pipeline development.
- Data modeling and semantic-layer / metrics-layer experience.
- Full-stack development experience (modern JS/TS framework + a Python web framework).
- Relational database operations, including high-availability Postgres.
- Containerized deployment and CI/CD (Docker, Kubernetes/k3s, Helm, GitLab CI or equivalent).
- BI/dashboarding experience (Tableau or a comparable tool, plus custom-built visualization).
- Data governance fundamentals: RBAC, SSO, PII handling, cataloging., * Semantic-layer specialization (governed metric layers).
- Experience enabling AI/ML or agentic use cases (MCP, LLM gateways, retrieval over governed data).
- Workflow orchestration (Temporal, Airflow, or similar).
- Experience as a technical lead/owner of a production platform and mentoring other engineers.
Benefits & conditions
Pulled from the full job description
- Health insurance
- Vision insurance
- Dental insurance
About the company
At Brooksource, relationships are the foundation of everything we do. Since 2000, we've built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. We offer flexible hiring models and are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions.