Solution Architect Business Intelligence
NEW YORK, NYJobSeen 1w agoSeen in employer's feed 1w ago
Most applications go out cold — see where you stand first. No sign-up to start.
Watch jobs like this. New roles like this one near NEW YORK, NY, by email.
Don't just apply. Show up ready.
Olive works from this exact posting.
At a glance
Olive lists jobs from US employers, including remote roles you can work from the United States.
Job overview
The BI Solution Architect designs and governs enterprise BI and analytics architecture, enabling scalable, secure, and trusted analytics consumption from Snowflake-curated data layers. The role connects business reporting needs with data engineering and BI delivery teams, defining semantic models, reporting standards, and governance patterns for self-service analytics while meeting enterprise performance and compliance expectations.
Skills & qualifications
Skills
Qualifications
Full job description
Role: 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 Snowflakebased 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 selfservice analytics while meeting enterprise performance and compliance expectationsRequired Skills & ExperienceCore Skills * Bachelors in CS/IS or equivalent. * 8+ years of ETL development experience with strong coding capability. * BI Architecture: Endtoend 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: RowLevel Security (RLS), access controls, governed BI * SQL: Strong SQL for analytical validation and troubleshootingPreferred / Nice-to-Have * Fabric Advanced Features: Semantic Link, shortcuts, advanced dataflows * Performance Optimization: Incremental refresh, aggregations, model tuning * Semantic Layer Tooling: dbt or similar semanticmodel management tools * Legacy BI Modernization: Migration of ADW/legacy reports to Power BI * Domain Knowledge: Insurance / Financial Services KPIs and reporting * SelfService BI Enablement: Standards, templates, and adoption frameworksSkillsEqual opportunity Employer:Mphasis is an equal opportunity/affirmative action employer. We provide equal employment opportunities to applicants and existing associates and evaluate qualified candidates without regard to race, gender, national origin, ancestry, age, color, religious creed, marital status, genetic information, sexual orientation, gender identity, gender expression, sex (including pregnancy, breast feeding and related medical conditions), mental or physical disability, medical conditions military and veteran status or any other status or condition protected by applicable federal, state, or local laws, governmental regulations and executive orders.VEVRAA Federal Contractor.We request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.
How this job compares
Set against the 7,947 open Solutions Architect jobs on Olive Jobs, counted October 28, 2026.
- Pay
- This postingNot listed
- New York median$152–232K/yr470 salary ranges
- US median$73–88/hr58 hourly ranges
- Openings
- Olive Jobs lists 578 open Solutions Architect jobs in New York and 7,947 across the US. 11% of them nationwide are listed as remote or flexible.
- Experience
- This posting asks for at least 8 years of experience; Solutions Architect postings that state a minimum ask for 7 years at the median (7,133 postings).
- Education
- 3,257 of the 7,947 open Solutions Architect jobs (41%) ask for a bachelor's degree or higher.
Counted across the open, public US postings on Olive Jobs on October 28, 2026. Pay medians are the middle values of the low ends and of the high ends of postings that list both ends of a range in the same cadence (a yearly salary or an hourly rate); a range's midpoint is halfway between its ends. Pay and experience figures resting on fewer than 20 postings are left out.
Similar jobs, posted recently
Open roles like this one, listed in the last 30 days.
Sr. Technical ArchitectSnowflake Inc. · NEW YORK, NY
Data and Analytics Engineering Lead, ReinsuranceMarsh McLennan Inc. · NEW YORK, NY
Solution Architect Data PlatformsRSM US LLP · NEW YORK, NY- Associate Data ArchitectMphasis Corporation · NEW YORK, NY
Senior Solutions ArchitectCity of New York · New York, NY · $100–180K/yr
You've read the whole posting — now see how you match it.