> Markdown version of [/jobs/ext/510340-bi-solution-architect](https://www.wearedevelopers.com/jobs/ext/510340-bi-solution-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# BI Solution Architect

- **Company:** TalentOla View all jobs
- **Location:** Houston, TX, United States
- **Experience:** Expert
- **Salary:** $80,500.0 - $157,500.0
- **Contract:** Permanent contract
- **Skills:** Sql Data Warehouse, Business Analytics Applications, Information Engineering, Extract Transform Load (ETL), Dimensional Modeling, Performance Tuning, Power BI, Standard Sql, SQL Databases, Snowflake, Powerquery, Data Layers, Star Schema
- **Published:** June 4, 2026
- **Apply:** https://www.careerjet.com/jobad/usd1add0e13606524d288143746d1fdaa0

## About the Role

* Bachelor's in CS/IS or equivalent.
 * 8+ years of ETL development experience with strong coding capability.
 * BI Architecture: End to end BI / analytics architecture, semantic layer design
 * Power BI / Fabric: Datasets, dataflows, DAX, Power Query, semantic models
 * Data Modeling: Dimensional modeling (star schema, conformed dimensions, KPIs)
 * Cloud Data Warehouse: Snowflake (DirectQuery vs Import, performance patterns)
 * Security & Governance: Row Level Security (RLS), access controls, governed BI
 * SQL: Strong SQL for analytical validation and troubleshooting

Preferred / Nice-to-Have

 * Fabric Advanced Features: Semantic Link, shortcuts, advanced dataflows
 * Performance Optimization: Incremental refresh, aggregations, model tuning
 * Semantic Layer Tooling: dbt or similar semantic model management tools
 * Legacy BI Modernization: Migration of ADW/legacy reports to Power BI
 * Domain Knowledge: Insurance / Financial Services KPIs and reporting
 * Self Service BI Enablement: Standards, templates, and adoption frameworks

## Description

The BI Solution Architect is responsible for designing and governing the enterprise BI and analytics architecture, ensuring scalable, secure, and trusted analytics consumption from Snowflake based curated data layers. The role bridges business reporting needs with data engineering and BI delivery teams, defining semantic models, reporting standards, and governance patterns that enable self service analytics while meeting enterprise performance and compliance expectations


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)