Solution Architect

Mphasis

New York (NY)

Hybrid

USD 80,500 - 157,500

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Solution Architect – Business Intelligence & AI‑Driven Analytics (Power BI, Tableau)
Solution Architect – Business Intelligence & AI‑Driven Analytics (Power BI, Tableau)

Evergreen • Dunwoody (GA)

Hybrid
USD 100,000 - 130,000
Pre-Sales Solution Architect – BI & AI‑Driven Analytics (Power BI, Tableau)
Pre-Sales Solution Architect – BI & AI‑Driven Analytics (Power BI, Tableau)

Insight Global (United States) • Dunwoody (GA)

Hybrid
USD 100,000 - 140,000
Power BI Architect
Power BI Architect

TechDigital Group • Los Angeles (CA)

On-site
USD 130,000 - 170,000
Business Intelligence Architect
Business Intelligence Architect

nymbusinc • United States

Remote
USD 135,000 - 150,000
Health insurance
Dental insurance
Vision insurance
+5
Enterprise Analytics Architect
Enterprise Analytics Architect

Teledyne Technologies Inc. • Daytona Beach (FL)

On-site
USD 140,000 - 190,000
Enterprise Data Architect
Enterprise Data Architect

Paladin Consulting • Dallas (TX)

On-site
USD 180,000 - 240,000
Power BI Technical Lead & Analytics Architect
Power BI Technical Lead & Analytics Architect

Compunnel Inc. • Texas

On-site
USD 95,000 - 135,000
BI Solution Architect: Snowflake & Power BI Leader
BI Solution Architect: Snowflake & Power BI Leader

Mphasis • New York (NY)

Hybrid
USD 80,500 - 157,500
Senior BI and Analytics Engineer
Senior BI and Analytics Engineer

Prosum • Los Angeles (CA)

On-site
USD 100,000 - 130,000
Business Intelligence Consultant
Business Intelligence Consultant

Elios Talent • United States

Remote
USD 120,000 - 150,000