Lead Business Intelligence Consultant

About this role:

Wells Fargo is seeking a Lead Business Intelligence Consultant.

In this role, you will:

• Lead cross-functional complex initiatives with broad impact and act as key participant in large-scale planning for the Business Intelligence functional area that enable clear and consistent delivery of insights
• Review and analyze complex, multi-faceted, longer-term business and technical challenges that require in-depth evaluation of data aggregation and visualization methodology to drive user-centric diagnostic analytics and dashboards
• Make decisions in complex situations requiring solid understanding of data structures, domain-specific knowledge and the end user experience that impact the final data visualization product, which includes dashboards, reports, insights, or analyses
• Influence and lead a broader work team to deliver data and visual outputs and new initiatives to inform strategy and decision making by the company
• Strategically collaborate and consult with peers, colleagues, and mid-level to senior managers to resolve issues and achieve goals related to assessing business needs and producing actionable insights and trends, leveraging data visualization and business intelligence
• Lead projects, teams and serve as a peer mentor
• Work to drive adoption of insights and metrics as a resource for the company to enable a data-driven decision-making approach

Required Qualifications:

• 5+ years of business intelligence and data visualization experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Required Qualifications for Europe, Middle East & Africa only:

• Experience in business intelligence and data visualization, or equivalent demonstrated through one or a combination of the following: work experience, training, education

Desired Qualifications:

• Overview:

We are seeking a highly skilled, self-driven, results-oriented Lead Analytics Consultant to support the data and analytics needs of the Chief Administrative Office (CAO). This is a business partner facing role and is responsible for providing reporting and analytic solutions that provide actionable insights to the d enterprise function partners and leadership. This role includes gathering and writing use case requirements, performing data analysis, developing semantic data models to support analytics and AI/ML model development and effective use of data visualization, reporting/dashboarding and AI-enabled BI solutions to enable explainability, exploratory analytics and actionable insights.

We are looking for a high performer to join our team and help us solve challenging and interesting business problems through rigorous data analysis and visualization. In this highly consultative and visible role, you will support business intelligence and analytics projects for leadership in key CAO functions.

Key Responsibilities:

• You would be required to work individually, or as part of a team or lead projects and work closely with business partners across the organization.
• Responsible for planning and performing reporting, analyses and projects to solve a variety of business issues for a department or functional area.
• Collaborate with business stakeholders to gather and refine requirements for use cases.
• Develop and deliver end to end high-performing reporting solutions and data analysis.
• Perform exploratory analysis to identify the co-relations existing in the data and generate insights.
• Ability to leverage data visualization tools (Power BI, Tableau) and alternative data manipulation and front-end solutions to deliver data analysis results and insights
• Capable of performing ad-hoc analyses and drill down into data inconsistencies and perform root cause analysis for unusual trends
• Work closely with Business and Technology Partners to generate new BI solutions or modify current work products to optimize capabilities and improve efficiency
• Strong experience in evaluating different types of AI/ML outputs and models (recommender systems, similarity scoring, classification and regression).
• Should be able to break down complex business problems into sub-tasks that can be solved with BI and analytics to enable decision making on a scale.
• Should have good grasp on statistical concepts and empirical methods that drive post-modelling decisions like sorting, ranking, selection etc.
• Be exceptional at communicating and translating model algorithms and their outputs to non-technical users and stakeholders, through visualization and BI tools like Power BI, Tableau.
• Ability to integrate AI-enabled features (e.g. Copilot for Power BI) into end-user consumption interfaces to enable natural language led analysis for business users.
• Fluent in agile ways of working and agile project management practices, should be able to create efficient user stories, and other agile project artifacts.
• Thought leadership in the field, capable of mentoring junior team members.
• Proactively seek opportunities to contribute in areas beyond project deliverables like exploratory data analysis, best practices, reusability and automation.
• Proactively seek opportunities to deliver value above and beyond the prescribed book of work.

Essential qualifications & Skills:

• 9+ (overall experience) years of experience in one or a combination of the following: reporting, analytics, or modeling (Tableau, Power BI, SQL, Python) or a Master's degree or higher in a quantitative field such as applied math, statistics, engineering, computer sciences,
• 8+ years of SQL, ETL, BI and PowerBI/Tableau programming experience
• Exposure & knowledge of Data Science, AI/ML.
• Business Intelligence
  • Proficiency in designing and implementing complex and interactive dashboards with BI tools like Power BI (including complex DAX implementations, embedded Power Apps and Power Automate workflows, Copilot for Power BI), Tableau
  • Ability to gather end-user requirements, user stories, data requirements and translating them into technical requirements and solution design.
  • Strong capability in using heterogeneous sources for deriving complex KPIs using Tableau, Power BI.
  • Understand high-level business objectives and continually align the BI/Reporting roadmap to needs of the business and present findings to leadership and exec level audience.
  • Experience on other BI tools like MSTR , BO , SSRS, Qlik, Thoughtspot will add value.
  • Strong oral and written communication and consultative skills, storytelling and narrative skills.
  • Outstanding problem solving and analytical skills with ability to turn findings into strategic imperatives
  • Extensive knowledge and understanding of research, analysis, data aggregations, and reconciliation processes
  • Ability to perform trend analysis, forecasting and pattern recognition, exploratory Data analysis and insights

• Data analysis
  • Experience in data cleansing, validation, and transformation logic using Alteryx and SSMS.
  • Advanced exploratory data analysis skills using Python,SQL, excel etc., ability to write, read, and optimize queries for data extraction, transformation, and analysis
  • Experience with data environments like Oracle , Teradata, Sql server, HDFS, GCP
  • Designing and implementing enterprise data and reporting architectures, proficiency in semantic data modeling for BI and AI/ML solutions
  • Data integration and clean up/preparation of data
  • Experience with structured data and semi-structured text or Excel files
• Familiarity with Agile processes and Atlassian software (Jira).

Desired Skills:

• Strong collaboration & problem-solving skills
• Strong communication skills (presentation and narrative skills)
• Ability to translate analytical data into useful business insights through presentation and storytelling
• Self-driven and passionate about continuous learning
• Knowledge of functional area such as risk, marketing, operations or supply chain in banking industry would be an added advantage.
• Ability to multi-task and prioritize between projects, independently or as part of a team
• Ability to mentor junior team members

Posting End Date:

We Value Equal Opportunity

Wells Fargo is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.

Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit's risk appetite and all risk and compliance program requirements.

Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process.

Applicants with Disabilities

To request a medical accommodation during the application or interview process, visit.

Drug and Alcohol Policy

Wells Fargo maintains a drug free workplace. Please see our to learn more.

Wells Fargo Recruitment and Hiring Requirements:

a. Third-Party recordings are prohibited unless authorized by Wells Fargo.

b. Wells Fargo requires you to directly represent your own experiences during the recruiting and hiring process.