About this opportunity
Mphasis lists this Solution Architect opportunity in new york, New York. Review the employer’s description below for duties, qualifications and application requirements.
Job description
Overview
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.
Required Skills & Experience
Core Skills
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
Role details
Role : BI Solution Architect
Location : Texas/New York
Role 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 expectations.
Required Skills & Experience
Core Skills
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
Other details
Salary range : $80,500 to $157,500
#J-18808-Ljbffr
Worksite address
new york, NY, 10261, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.