Solution Architect

Mphasis; New York (NY); Hybrid; USD 80,500 - 157,500; Full time

Job summary

Mphasis is hiring a BI Solution Architect to oversee the design and governance of enterprise BI and analytics architecture. This role requires strong experience in ETL development and BI solutions, ensuring secure and efficient analytics consumption from Snowflake-based data layers.

The ideal candidate should possess extensive knowledge in Power BI, data modeling, and governance aspects while effectively bridging business needs with technical teams.

Qualifications

• Bachelor’s degree in Computer Science or Information Systems or equivalent.
• 8+ years of ETL development experience with a strong coding ability.
• End-to-end BI / analytics architecture and semantic layer design.
• Strong SQL skills for analytical validation and troubleshooting.

Responsibilities

• Design and govern the enterprise BI and analytics architecture.
• Ensure scalable, secure, and trusted analytics consumption.
• Bridge business reporting needs with data engineering and BI delivery teams.

Skills

ETL development experience

BI Architecture

Power BI / Fabric

Data Modeling

Cloud Data Warehouse with Snowflake

Security & Governance

Strong SQL

Education

Bachelor’s in CS/IS or equivalent

Tools

Power BI

Snowflake

dbt or similar tools

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