Lead Risk Analytics Consultant - Data Architecture & BI Enablement
Wells FargoAbout the role
About this role:
Wells Fargo is seeking a Lead Risk Analytics Consultant - Data Architecture & Self-Service BI Enablement lead to join IDeAS (Information Delivery and Analytics Solutions). IDeAS designs, delivers, and governs the Risk Platform, enabling consistent, scalable reporting, risk oversight, and advanced analytics across the firm.
In this role, you will focus on enabling self-service analytics at scale, not building reports or dashboards. You will design curated datasets and semantic data layers that empower business users, analysts, and BI developers to independently create reporting solutions using Tableau, and Power BI.
In this role, you will:
Drive scalable, self-serve BI solutions that deliver actionable insights and business value through advanced analytics, and automation to make actionable insights, trends, recommendations, or contribute to large-scale planning that has a broader impact
Enable self-service curated datasets and semantic layers for business stakeholders. Define and maintain semantic models, data dictionaries, and KPIs
Lead data consolidation and rationalization across a complex ecosystem, transforming hundreds of disparate source tables into curated, governed, and business-ready datasets that minimize redundancy and eliminate manual data pulls
Own the end-to-end data consumption architecture, defining how curated datasets, semantic models, and data access layers are structured and integrated with BI tools and AI-driven query interfaces
Provide hands-on enablement and training to business stakeholders and BI users in Power BI, focusing on how to effectively use curated datasets and semantic models
Partner with Technology teams to implement scalable pipelines and datasets in Microsoft Fabric (Lakehouse)
Design datasets for high-performance consumption across large-scale data volumes (millions to billions of rows)
Act as the primary business-side architectural counterpart to the Technology execution team building data models and pipelines
Provide clear execution artifacts, including dataset specifications, mapping logic, acceptance criteria, test scenarios, and performance targets.
Required Qualifications:
5+ years of Risk Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
Desired Qualifications:
Experience with Microsoft Fabric (Lakehouse, Direct Lake, semantic models)
Strong SQL, Power BI knowledge, with emphasis on leveraging semantic models and curated datasets rather than report/dashboard development
Proven ability to design data solutions that eliminate manual data pulls and reduce dependency on centralized reporting teams
Experience working with large-scale datasets, and Parquet file structure
Excellent communication, organizational, and planning skills
Experience in collaborating with both technical and non-technical partners with a problem-solving mindset
Experience in Capital Markets and Risk Management
Job Expectations:
Willingness to work on-site at stated location on the job opening
Relocation Assistance not available
This position currently offers a hybrid work schedule
This position is subject to FINRA Background Screening Requirements, including successful completion and clearing of a background check. Internal transfers are subject to comply with 17 CFR 240.17f-2 of the Securities Exchange Act of 1934 and FINRA Bylaws, Article III, Section 3, which states that Associated Persons should not be subject to statutory disqualification. Successful candidates must also meet ongoing regulatory requirements including additional screening and are required to report certain incidents
Specific compliance policies may apply regarding outside activities and/or personal investing; affected employees will be expected to provide information to the Wells Fargo Personal Account Dealing Team and abide by applicable policy requirements if hired. Information will be shared about expectations during the recruitment process
Job Posting Locations:
550 S Tryon St, Charlotte, NC
Posting End Date:
14 Jun 2026*Job posting may come down early due to volume of applicants.
We Value Equal Opportunity
Wells Fargo is an equal opportunity employer. All qualif
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s