Job Description

Wells Fargo is seeking an Analytics Consultant to support front line activities in Corporate and Investment Banking (CIB) by implementing and improving data methodologies while coordinating with technical and business partners.



In this role, you will: • Create SSIS packages and SQL Server stored procedures based on new requirements and translated from existing SQL/SAS code
• Promote SSIS packages, stored procedures and tables from Dev to UAT to Prod by submitting Change Requests in ServiceNow and working them through to completion
• Monitor the daily execution of SSIS packages and escalate issues as appropriate
• Assess specific data risks as they relate to governance, storage, and movement to the practices of the first-line of defense
• Produce performance monitoring and benchmarking
• Be an integral part of implementing a fully integrated analytics and reporting infrastructure to support the group and leverage resources for multiple, on-going activities/initiatives
• Create tools and methodologies to deliver clear, consistent risk management and market conduct messaging
• Support the design and implementation of front-line Market Conduct risk and control reporting across all regions, ensuring consistent standards and aggregation of reports at the legal entity, country and regional levels

Required Qualifications, US: • 6+ months of Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Desired Qualifications: • Excellent verbal, written, and interpersonal communication skills
• 3+ years of Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
• 3+ years' experience with SQL Server databases using SSIS as an ETL
• 3+ years' experience with SQL Server stored procedures
• Experience with a standard business intelligence platform, eg. PowerBI, Tableau, or MTSR
• Experience in Analytics, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
• Ability to articulate complex concepts in a clear manner
• Experience with data governance tools
• Experience with database mapping tools
• Strong analytical skills with high attention to detail and accuracy
• Advanced experience in development and reporting tools (Java, .Net, Tableau, PowerBI, SharePoint, SAS, SQL, ETL Data modeling is a must.
• Proven experience in creating and managing databases (such as SQL, Teradata and Oracle)
• Experience managing Change Requests via ServiceNow

Posting End Date:


27 Oct 2024

•Job posting may come down early due to volume of applicants.




We Value Diversity



At Wells Fargo, we believe in diversity, equity and inclusion in the workplace; accordingly, we welcome applications for employment from all qualified candidates, regardless of race, color, gender, national origin, religion, age, sexual orientation, gender identity, gender expression, genetic information, individuals with disabilities, pregnancy, marital status, status as a protected veteran or any other status protected by applicable law.



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 US: 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.



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.