BI Solution Architect

TalentOla View all jobs
Houston, TX, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Compensation
$80,500.0 - $157,500.0
Working hours
Regular working hours
Job source

Tech stack

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
+1 more
Star Schema

Job 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

Requirements

  • 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

Benefits & conditions

Binyod LLC

  • Houston, TX Benefits: Bonus based on performance Competitive salary Paid time off Training & development Position Summary The Technical Account Manager (TAM) is a client-facing en…

  • 2 months ago + *

About the company

RSM International

  • Houston, TX We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to …

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careerjet.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · WWC Europe 2026

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · WWC Europe 2026

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

Videos

See all

Related articles

See all