Job Description

About Wells Fargo Wells Fargo & Company (NYSE: WFC) is a leading global financial services company headquartered in San Francisco (United States). Wells Fargo has offices in over 30 countries and territories. Our business outside of the U.S. mostly focuses on providing banking services for large corporate, government and financial institution clients. We have worldwide expertise and services to help our customers improve earnings, manage risk, and develop opportunities in the global marketplace. Our global reach offers many opportunities for you to develop a career with Wells Fargo. Join our diverse and inclusive team where you will feel valued and inspired to contribute your unique skills and experience. We are looking for talented people who will put our customers at the center of everything we do. Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you. About Wells Fargo India enables global talent capabilities for Wells Fargo Bank NA., by supporting business lines and staff functions across Technology, Operations, Risk, Audit, Process Excellence, Automation and Product, Analytics and Modeling. We are operating in Hyderabad, Bengaluru and Chennai locations. Corporate & Investment Banking (CIB) Corporate & Investment Banking delivers a comprehensive suite of capital markets, banking, and financial products and services. A trusted partner to our clients, we provide corporate and transactional banking commercial real estate lending and servicing investment banking equity and fixed income solutions including sales, trading, and research capabilities to corporate, commercial real estate, government, and institutional clients across the globe. Department Overview (Product Control Analytics Support) The Corporate and Investment Banking (CIB) Line of Business Finance Teams report to the Head of CIB Finance and manages the finance functions directly supporting the Wells Fargo CIB Line of Business. CIB consists of Market, Banking, Commercial Real Estate, and International. PCAS Finance team manages a team of subject matter experts providing very detailed functional support to Product controllers. Creating new Source to target mapping for fresh data flow. Streamlining data transformation logics and backend processes. Managing change management and doing impact analysis. Database performance monitoring. Building proof of concepts for new business requirements. Maintaining a team characterized by deep functional and technical subject matter expertise, and a team culture consistent with the Company\'s Vision and Values. About the Role This role requires a developed understanding of Current processes and expertise in data analysis, reviewing database objects and building proof of concepts for new reports using advanced SQL. This knowledge is required to lead the activities of executing on the Risk and Controls model, collaborate within and across teams. This role will ensure documentation covering multiple functions as team member will be implementing several projects collaborating with IT as a part of this initiative with all the below daily responsibilities and requirements. Responsibilities Requirement collection and preparation of the Business Requirement document. Developing SQL codes as per Business requirement document to create automated reports. Developing Power BI Dashboards. Creating backend scripts for testing and validating the changes. Perform functional and regression testing for the changes/enhancements. Lead the team deliverables in Agile framework and active usage of JIRA tool to achieve the same. Act as Project Manager for all the assigned items and work with IT Team and stakeholders. Analyze the existing queries for performance enhancement. Handling Ad-hoc queries and Troubleshooting. Essential Qualifications B. Tech (IT)/BSC (CS)/MSC (CS) OR M.B.A degree with 7+ yrs. of relevant experience. Excellent understanding of SQL programming and Power BI. Proven leadership, team building and cross functional partnership skills. Strong understanding of the source to target mapping, analyzing & creating transformation logics. Desired Qualifications Experience working in global teams. Proficient in working with complex data model, especially associated with building new product. Advanced desktop skills in MS Office products especially MS Excel and MS Access and tools like SQL, Tableau, Power BI Experience in researching and resolving Data flow issues. Strong interpersonal skills to effectively build and maintain partnership with key stakeholders and partners. Outstanding problem-solving skills. Ability to be agile, flexible and adjust plans quickly to meet changing business needs Ability to perform well under pressure. @RWF22 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, age, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. 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.

foundit