Wells Fargo is seeking a Lead Data Analytics Consultant in our Merchant Services group as part of Data Infrastructure, Analytics & Reporting. In this role, you will serve as the Senior Data Architect & Analytics Lead, responsible for legacy system stewardship, SSRS cube-based reporting, and cloud modernization.
What You'll Do:
Legacy Environment Support & Deep Analysis
- Perform in-depth analysis of legacy systems, including 15+ year-old code and undocumented processes, to identify issues and engineer durable solutions.
- Maintain and enhance SSIS packages for ETL workflows, including automation and performance tuning.
- Manage SQL Server-based data marts and SSRS reports connected to SSAS multidimensional cubes.
- Use MDX queries in SSRS to extract data from SSAS cubes, enabling fast, multidimensional analysis across business dimensions and measures.
- Design and optimize SSRS cube-based reports that support slicing and dicing of data across time, geography, product, and other dimensions.
- Develop and optimize stored procedures for data retrieval and workflow automation.
- Ensure data quality, lineage, security, and compliance across all legacy systems.
- Document findings and create knowledge artifacts to reduce future technical debt and improve supportability.
- Collaborate with reporting and analytics teams to define and implement the Google Cloud migration strategy.
- Design scalable, future-ready data architecture leveraging BigQuery, Cloud SQL, and ThoughtSpot.
- Build data pipelines using Dataflow, Dataproc, and Pub/Sub.
- Develop CI/CD pipelines for data integration and deployment in GCP.
- Implement governance, security, and cost optimization standards for cloud-based data solutions.
- Advise leadership on analytical strategies, KPI frameworks, and advanced data visualization for complex business and technical needs.
- Partner in the creation of a data environment that supports reporting needs and enables decision-making across Finance, Accounting, Customer Marketing, Operations, and Risk.
- Translate business requirements into robust data models, semantic layers, and dashboards.
- Create and maintain Key Performance Indicator (KPI) reports for business segment management; deliver proactive insights and ad-hoc analyses.
- Lead process improvement strategies that simplify and automate financial reporting and analytics.
- Design and lead complex, cross-functional projects with long-term, enterprise-scale impact.
- Provide vision, direction, and expertise to leadership on innovative data solutions aligned to enterprise standards.
- Engage with peers, senior leaders, risk, compliance, and finance as a trusted advisor.
- Mentor team members; foster a culture of innovation, documentation, and continuous improvement.
- Lead new projects and ongoing maintenance of the Merchant Services MIS infrastructure.
- 7+ years of Analytics & Reporting, Financial Modeling, Statistics, or equivalent demonstrated through work experience, training, military experience, or education.
- Expert-level experience with SSIS, SSRS (including SSAS cube integration), SQL Server, and stored procedures.
- Strong ETL design, dimensional modeling, and data warehousing fundamentals.
- Proficiency in Python for data processing and automation.
- Familiarity with Power BI and semantic modeling.
- Proven ability to investigate undocumented systems and resolve complex issues independently.
- Strong analytical mindset with persistence to solve challenging problems.
Desired Qualifications:
- Finance and financial services industry experience; strong understanding of Merchant Services P&L and profitability drivers.
- Experience supporting the development of financial and analytical reporting systems and MIS infrastructure enhancements.
- Experience coordinating delivery across data warehousing and reporting infrastructure.
- Project management experience leading multi-team data initiatives.
- Knowledge of SQL or SAS, and MDX for SSRS cube reporting.
- Hands-on experience with Google Cloud Platform (BigQuery, Cloud SQL, Dataflow, Dataproc, Pub/Sub).
- Knowledge of DevOps/CI-CD practices for data (testing, versioning, deployment, observability).
- Exposure to Databricks, Spark, BigQuery, MongoDB, and or Postgres.
- GCP certifications (e.g., Professional Data Engineer) are a plus.
- Experience migrating legacy ETL and reporting solutions to GCP.
- Own complex problem-solving in a challenging legacy environment and make a lasting impact.
- Drive transformation from legacy platforms to a modern, governed cloud architecture.
- Work on mission-critical systems while shaping the future data strategy and enabling advanced analytics.
13 Nov 2025
*Job posting may come down early due to volume of applicants.
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 Disability Inclusion at Wells Fargo .
Drug and Alcohol Policy
Wells Fargo maintains a drug free workplace. Please see our Drug and Alcohol Policy 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.
Top Skills
What We Do
Wells Fargo & Company (NYSE: WFC) is a leading financial services company that has approximately $2.0 trillion in assets. We provide a diversified set of banking, investment and mortgage products and services, as well as consumer and commercial finance, through our four reportable operating segments: Consumer Banking and Lending, Commercial Banking, Corporate and Investment Banking, and Wealth & Investment Management. Wells Fargo ranked No. 33 on Fortune’s 2025 rankings of America’s largest corporations.
Our technology professionals drive innovation, information security, and big data analytics while maintaining a network that handles more than 12 billion customer interactions a year. Join us!
Are you looking for more? Find it here.
At Wells Fargo, we're more than a financial services leader – we’re a global trailblazer committed to driving innovation, empowering communities, and helping our customers succeed. We believe that a meaningful career is much more than just a job – it’s about finding all of the elements to help you thrive, in one place. Living the Well Life means you’re supported in life, not just work. It means having robust benefits, competitive compensation, and programs designed to help you find work-life balance and well-being. You’ll be rewarded for investing in your community, celebrated for being your authentic self, and empowered to grow. And we’re recognized for it – Wells Fargo once again ranked in the top three – making us the #1 financial services employer – on the 2025 LinkedIn Top Companies list of best workplaces “to grow your career” in the U.S.
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. © 2025 Wells Fargo Bank, N.A. All rights reserved. Member FDIC.
Why Work With Us
We're known for our “Well Life” approach to supporting employees’ career aspirations, work-life balance, and mental and physical health. We ranked in the top 3 on the 2025 LinkedIn Top Companies list – and #1 among financial services companies – as the best workplace “to grow your career” in the U.S.
Gallery
Wells Fargo Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
