BI & Data Engineer

Position Summary The BI Data Applications Engineer is an experienced BI and data engineering professional responsible for building and maintaining Focus's data consumption layer — the reports, dashboards, and interactive applications that let the business work directly with data in Snowflake. , Streamlit in Snowflake, and custom React + FastAPI applications hosted natively in Snowflake). You'll use AI-assisted development tools such as GitHub Copilot to accelerate delivery, and partner closely with data engineers and analytics engineers who build the underlying semantic models.

The ideal candidate is comfortable moving between report design, platform administration, and full-stack application development, with a strong focus on making data genuinely usable for business stakeholders. This role is hybrid with 3 days/week onsite in St. Louis.

Responsibilities

BI Reporting Semantic Model Consumption: Design, build, and maintain Power BI reports and dashboards built on top of Snowflake semantic models and semantic views, ensuring reporting is accurate, performant, and aligned to business needs. Power BI Platform Administration: Own Power BI tenant administration, including workspace governance, row-level security (RLS), capacity management, gateway configuration, and DirectQuery performance tuning against Snowflake. Data Application Development: Design, build, and maintain interactive data applications directly in Snowflake, using Streamlit in Snowflake and custom container-based applications (React frontend with a FastAPI backend) via Snowpark Container Services, enabling business users to interact with data beyond static dashboards.

, GitHub Copilot) to accelerate development of reports, applications, and backend services, while maintaining code quality and review standards.

Requirements

and translate them into usable reporting and application experiences. Performance Access Governance: Monitor and optimize performance across Power BI reports and Snowflake-hosted applications, and manage access controls for reports, apps, and underlying datasets in coordination with data platform governance standards. Application Lifecycle Deployment: Manage the full lifecycle of BI reports and data applications, including version control (Git/GitHub), CI/CD for application deployment, testing, and release management.

Required Skills BI Reporting: Advanced Power BI development skills (DAX, data modeling, report design) and administration experience (workspace governance, RLS, gateways, capacity planning). Experience connecting Power BI to Snowflake via DirectQuery or Import against semantic models. Application Development: Proficiency building Streamlit applications, along with experience using React (or a similar frontend framework) and FastAPI (or a similar Python backend framework) to build custom applications.

Familiarity with containerization (Docker) and deploying containerized apps, ideally within Snowflake via Snowpark Container Services. Snowflake SQL: Strong SQL skills and familiarity with Snowflake semantic models/semantic views, Cortex Analyst, and general Snowflake data structures. , GitHub Copilot) as part of a daily development workflow.

Programming: Solid Python skills for backend and application development, and working knowledge of JavaScript/TypeScript for frontend development.