Solution Architect- Business Intelligence
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Role descriptionRole: BI Solution ArchitectLocation: Houston, TX-USRole summary: 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 expectationsRequired Skills & ExperienceCore SkillsBachelor’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 designPower BI / Fabric: Datasets, dataflows, DAX, Power Query, semantic modelsData 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 BISQL: Strong SQL for analytical validation and troubleshootingPreferred / Nice-to-HaveFabric Advanced Features: Semantic Link, shortcuts, advanced dataflowsPerformance Optimization: Incremental refresh, aggregations, model tuningSemantic Layer Tooling: dbt or similar semantic‑model management toolsLegacy BI Modernization: Migration of ADW/legacy reports to Power BIDomain Knowledge: Insurance / Financial Services KPIs and reportingSelf‑Service BI Enablement: Standards, templates, and adoption frameworksOther detailsSalary range $80500 to $157500