Lead Analytics Consultant

• Advise line of business and companywide functions on business strategies based on research of performance metrics
• Provide influence and leadership in the identification of new tools and methods to analyze data
• Ensure adherence to compliance and legal regulations and policies on all projects managed
• Provide updates on project logs, monthly budget forecasts, monthly newsletters, and operations reviews
• Assist managers in building quarterly and annual plans and forecast future market research needs
• Strategically collaborate and consult with peers, colleagues, and mid-level to senior managers to resolve issues and achieve goals
• Lead projects, teams, or serve as a peer mentor to staff, interns and external contractors
• Lead the design and implementation of reports, dashboards, and data flows across various topics
• Support simple to complex ad-hoc reporting requests
• Manipulate and process large datasets using analytical and reporting features of multiple tools
• Provide leadership in the identification and development of new reporting concepts and designs
• Define requirements for and test data sources for reporting
• Participate in cross-functional project teams and provide guidance and training to teams
• Build and maintain interactive dashboards and reports using Power BI and Tableau
• Leverage Alteryx and SQL to extract, transform, and load (ETL) data from enterprise systems
• Utilize Power Automate and Power Apps to streamline business processes and automate repetitive tasks
• Establish and enforce data governance, security, and reporting standards
• Interact / coordinate with different teams to proactively raise any specific issues or challenges
• Perform complex variance and trend analysis
• Build financial models, draw conclusions, and communicate recommendations to business leaders

• 5+ years of Analytics experience
• 2+ years of Power BI Cloud experience with strong capability to design and maintain data flows
• 2+ years' experience in PowerApps & Automate with capability to design complex workflows and automations
• Advanced level skills in data visualization tools (Power BI Cloud) with hands on experience building and maintaining visualizations
• Experience with data querying tools such as SQL Server, SQL Server Integration Services (SSIS), SAS, Alteryx
• In depth knowledge of Wells Fargo database environments (CBDW, C2T/MDSS, BMG, EIW)
• Experience with Agile methodologies
• Strong analytical skills with high attention to detail and accuracy
• Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
• Ability to take initiative and work independently with minimal supervision in a structured environment
• Strong presentation skills – written and verbal, and the ability to adapt to multiple audiences
• Strong critical thinking skills combined with strategic business focus and a passion for the customer experience and the employee experience
• Ability to take apart existing processes to find the issue and build a new process to resolve it
• Ability to create and execute on logical process flows
• Highly organized and detail-oriented, with the ability to manage processes, handle multiple tasks simultaneously and prioritize effectively
• Proven success building and maintaining strong credible relationships with key stakeholder
• Solid understanding of Business Intelligence projects throughout the entire lifecycle
• Hands-on experience with GPT, LLaMA or similar models including fine tuning and prompt engineering
• Proficiency in Python, Langchain, vector databases (Pinecone, Chromadb, FAISS etc) and API integration
• Strong skill in data preprocessing, embeddings and building RAG pipelines
• Familiarity with Cloud platforms (AWS, GCP, Azure) containerization (Docker) and CI/CD for AI models
• Ability to design scalable AI solutions, evaluate model performance and optimize for real-world use cases

Experience mentoring and serving as a peer-coach to other analysts with the ability to transfer skills and knowledge to peers