Merchant Services Lead Data Product Management Consultant

About this role:
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.

Cloud Strategy & Modernization (Google Cloud Platform)

• 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.

Analytics, Reporting & Business Impact

• 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.

Leadership, Governance & Collaboration

• 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.

Required Qualifications:

• 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.

Required Qualifications for Europe, Middle East & Africa only:
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.

Job Expectations:

• 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.

Posting End Date:
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.