Role: BI Solution ArchitectLocation: Onshore (US)Reports To: Program Manager 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 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 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.PDN-a18fe03b-281a-4f18-8c1c-823354111289
