Wells Fargo

Lead Risk Analytics Consultant - Data Architecture & BI Enablement

Wells Fargo$100K — $130K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of Risk Analytics experience or equivalent through work experience, training, military experience, or education.
  • Experience with Microsoft Fabric, including Lakehouse and semantic models.
  • Strong SQL and Power BI skills with emphasis on semantic models and curated datasets.
  • Ability to design data solutions that minimize manual data pulls and reliance on centralized teams.
  • Experience with large-scale datasets and Parquet file structure.
  • Excellent communication, organizational, and planning skills.
  • Experience collaborating with both technical and non-technical partners.

Responsibilities

  • Drive scalable self-service BI solutions for actionable insights through advanced analytics and automation.
  • Enable self-service curated datasets and semantic layers for stakeholders, maintaining data dictionaries and KPIs.
  • Lead data consolidation across complex ecosystems, transforming disparate data into governed datasets.
  • Own end-to-end data architecture, defining structure and integration with BI tools and AI-driven interfaces.
  • Provide hands-on training to business users in Power BI for effective use of curated datasets.
  • Collaborate with Technology teams to implement scalable data pipelines in Microsoft Fabric.
  • Design datasets optimized for high-performance consumption of large data volumes.

Benefits

  • Hybrid work schedule available.
  • On-site work required.
  • Relocation assistance not available.
Full Job Description

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

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.

About Wells Fargo

Wells Fargo Careers

Joining Wells Fargo means becoming part of a distinguished financial institution that has been a cornerstone of innovation and leadership in the banking industry. At Wells Fargo, we offer a plethora of job opportunities designed to empower your career growth and development in a diverse and inclusive environment.

Work You’ll Do

At Wells Fargo, you will be part of a team that values diversity and is committed to fostering an inclusive culture. We are looking for professionals who are eager to drive innovation and lead with integrity. Our employees are our greatest asset, and we invest in their professional growth through comprehensive leadership and diversity training programs that are recognized industry-wide.

Explore a Multitude of Career Paths

Whether you're interested in a position in finance, IT, customer service, or management, Wells Fargo has career opportunities in various fields. Our team members benefit from job stability, competitive benefits, and a culture that values and rewards performance and dedication.

Internship Programs

Kickstart your career with a Wells Fargo internship. Our programs provide invaluable industry exposure, professional skills development, and networking opportunities that often lead to full-time employment offers. Interns at Wells Fargo work on real projects, solve actual challenges, and gain the mentorship of seasoned professionals.

Professional Growth and Development

We believe in nurturing the potential of our employees. Wells Fargo offers robust training programs and resources to help every team member excel in their current roles and prepare for future challenges. Growth at Wells Fargo is not just about climbing the career ladder but expanding your skills and expertise to add value to our team and customers.

Benefits and Rewards

Wells Fargo is committed to the well-being of our team members. We offer a comprehensive benefits package that includes health care, retirement plans, and generous paid time off. Additionally, we provide unique perks like employee discounts, adoption assistance, and tuition reimbursement.

Join Our Team

Discover the opportunities waiting for you at Wells Fargo by exploring open positions that match your skills and interests. We are continuously hiring and looking for individuals who bring creativity, passion, and a drive to serve our customers.

Stay Connected

Keep up to date with the latest from Wells Fargo Careers by subscribing to our job alert emails. Tailor your subscription to receive updates that align with your career preferences and get insider tips on crafting the perfect resume and acing your interview.

Networking and Innovation

At Wells Fargo, networking and innovation go hand in hand. We encourage our employees to connect across departments and roles to foster new ideas and strategies that lead to groundbreaking solutions.

Empower Your Career

Step into a role at Wells Fargo where your skills will be honed, your achievements recognized, and your career can flourish. We're not just filling positions; we're building leaders who are equipped to navigate the complexities of the financial world. Join Wells Fargo today and be part of a team that’s redefining the future of banking.
Learn more about Wells Fargo
Size
246,577 employees
Market Cap
$155.2 billion
Industry
Net Income
$3.3 billion
Founded
1852
5 Year Trend
-5.9%
NASDAQ

Similar Jobs

More Jobs at Wells Fargo

More Finance & Insurance Jobs

Find similar Lead Risk Analytics Consultant - Data Architecture & BI Enablement jobs: