We are seeking an Analytics consultant to join our Financial Crimes Analytics team. This role is critical in supporting investigative units such as Intelligence and Special Operations by identifying and extracting relevant data from a vast metadata repository. The ideal candidate will have strong SQL expertise, deep understanding of customer and transaction data, and an investigative mindset.
In this Role, You Will:
- Write and optimize complex SQL scripts involving multiple table joins, CTEs, temporary tables, CASE statements, RANK, QUALIFY clauses, index creation, and table design.
- Navigate large metadata portals to identify relevant tables and columns for financial crime investigations.
- Collaborate with Financial Crimes teams (Intel, Special Ops) to understand data needs and deliver outputs per JIRA descriptions.
- Create and maintain documentation of data sources, table structures, and data lineage.
- Ensure data accuracy and completeness in all outputs.
- Apply domain knowledge in retail and corporate banking to contextualize findings.
- Demonstrate proactive problem-solving and creative thinking in ambiguous scenarios.
- Communicate findings effectively through clear verbal and written communication.
- Education: B.Tech in CSE or IT; MBA in Finance is a plus. Other qualifications acceptable with strong retail banking and SQL experience.
- 2+ years of experience in data analysis with strong SQL focus.
- Extensive Power BI experience with the ability to develop dashboards, visualizations, and analytical reporting solutions using data from enterprise-scale databases and data warehouses.
- Proven experience working with large-scale banking or financial services data environments, including customer, account, transaction, payment, and related operational datasets.
- Strong experience querying and analyzing data from enterprise data warehouses, data marts, or centralized analytics platforms containing high-volume structured data.
- Advanced SQL skills, including complex joints, CTEs, performance optimization, data profiling, and data validation.
- Experience working with transactions, customer, and account-level data to support analytics, investigations, risk management, compliance, financial crimes, fraud, or operational reporting functions.
- Teradata experience.
- Support investigative units (Intel, Special Ops) by providing accurate and timely data extracts.
- Ensure compliance with internal data governance and security standards.
- Maintain clear documentation for all SQL scripts and data sources.
- Proactively identify data anomalies and escalate potential risks.
- Collaborate effectively with cross-functional teams and meet deadlines for JIRA tasks.
- Curiosity and passion for solving complex data problems.
- Investigative and discovery-oriented mindset.
- Critical and creative thinking with strong learning aptitude.
- Collaborative spirit and willingness to support cross-functional teams.
13 Aug 2026
*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.
Skills Required
- B.Tech in Computer Science or Information Technology
- MBA in Finance
- 2+ years of data analysis experience with strong SQL focus
- Advanced SQL skills (complex joins, CTEs, performance optimization, data profiling, validation)
- Extensive Power BI experience (dashboards, visualizations, analytical reporting)
- Proven experience with large-scale banking or financial services datasets (customer, account, transaction, payment)
- Experience querying and analyzing data from enterprise data warehouses, data marts, or centralized analytics platforms
- Teradata experience
- Experience working with transaction, customer, and account-level data to support investigations, risk, compliance, or fraud functions
- Ability to navigate metadata portals and document data sources, table structures, and data lineage
- Experience delivering work based on JIRA task descriptions and collaborating with investigative teams
Wells Fargo Compensation & Benefits Highlights
-
Retirement Support — Retirement support is anchored by a dollar‑for‑dollar 401(k) match on employee contributions after one year of service, with an additional non‑matching company contribution for some lower‑paid employees. Access to an employee stock purchase plan further expands long‑term savings opportunities.
-
Parental & Family Support — Family supports include up to 16 weeks of paid parental leave available from the first day of employment, plus paid critical‑caregiving leave and extensive backup care options. Fertility, adoption, and surrogacy programs are highlighted with meaningful coverage and reimbursements, including a combined lifetime maximum up to $35,000 for eligible expenses.
-
Healthcare Strength — Health coverage is comprehensive from day one, spanning medical, dental, vision, mental health, prescriptions, and preventive care often fully covered in‑network. Employer cost‑sharing is emphasized alongside no‑cost counseling through the EAP within plan limits.
Wells Fargo Insights
What We Do
Wells Fargo & Company (NYSE: WFC) is a leading financial services company that has approximately $2.2 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 continues to rank on the LinkedIn Top Companies lists of best workplaces “to grow your career.” 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. © 2026 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. Wells Fargo continues to rank on the LinkedIn Top Companies lists of best workplaces “to grow your career.”
Gallery
Wells Fargo Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
