Finance Analyst

About this role:

Wells Fargo is seeking a Financial Analyst

In this role, you will:

• Participate in functions related to financial research and reporting
• Forecast analysis of key metrics, as well as other financial consulting related to business performance, operating and strategic reviews
• Identify opportunities for process improvements within the scope of responsibilities
• Research moderate to complex financial data in support of management decision-making for a business
• Create and communicate various activities such as product pricing, product, and portfolio performance
• Exercise independent judgment to guide key metrics forecasting, closing data and validation
• Present recommendations for resolving all aspects of delivering key forecasting projections as well as financial reporting to support monthly and quarterly forecasting
• Develop expertise on reporting that meets brand standards and internal control standards
• Collaborate and consult with peers, colleagues and managers to resolve issues and achieve goals
• This Individual contributor role is responsible for all of the month end close activities starting from BD -4 to BD +5 (Business days).
• Post the book closures, the role needs to support on reporting, Providing impactful insights, descriptive & diagnostic analysis, dashboards and ad-hoc reports.
• Reports include preparing daily, weekly and monthly reporting and other ad-hoc reports to support the line of business and provide meaningful analysis and analytics support.
• This role also extensively includes a wide range of data management activities such as data extractions, consolidations, aggregations, validations and modelling support.
• The role strives for excellence in providing timely, accurate and meaningful insights to senior stakeholders and driving efficiency and process innovations.

• 2+ years of Finance experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

• Post graduate in Accounting, Finance or Business Administration
• Candidate must have hands on experience in LOB / segment / product reporting / management reporting / dashboard / analytics / commentary
• Minimum 6-8 years' experience in finance or reporting roles, including monthly close, management reporting, Reconciliation & General ledger with good analysis and commentary skills.
• Preferably should have relevant banking experience with hands on experience in management reporting, forecasting and planning process.
• Candidate should be fairly familiar with the AU/OU/ Hierarchy process, and should also be extremely good at change management and ability to turn around the reports not only with speed, but with high quality, integrated controls and checks.
• Candidate should also have good financial modelling, template building, dashboard and presentation skills as this will help in transforming reports to the next level.
• Candidate should have Essbase/Hyperion experience and should be a subject matter expert in data retrievals from different cubes.
• Ability to work both independently and within team environment.
• Strong communication and presentation skills.
• Ability to perform complex analyses, build financial models, draw conclusions, and communicate recommendations to business leaders.
• Prioritize multiple tasks in a fast-paced environment with critical deadlines.
• Advanced knowledge of Excel, Macros, Access and Power point.

• Preferable to have prior experience in FP&A role, with expertise in review and modification of financial reporting along with variance analysis to drive value
• Expertise with Essbase along with SQL skills and query management. Knowledge of Tableau, Power-BI, Alteryx and data analytics will be added advantage.
• Comfortable to work in flexible timings to maximize overlap with US counterparts

• Month-end and quarter-end close reporting processes, with a focus on accuracy and process improvement; suggest innovative ideas and take initiative to automate the process.
• Evaluate all financial results and related reporting, check for reasonability in results between current month and expectations and prior months
• Provide meaningful analysis and variance commentary to inform and guide stakeholders; identify risks and opportunities to future forecast
• Data management, data integrity and data lineage skills in ensuring appropriate reporting of financials and related metrics/drivers.
• Monitor key financial and metric trends and provide weekly and monthly reporting; identify and explain the cause of any material variances
• Requires extensive data reconciliation & consolidation as well as analysis, coupling the use of scenario and sensitivity analysis to forecast possible outcomes.
• Design new report / Modify existing financial report using Essbase excel add in tool.
• Generate multiple reports like Close, Balance sheet, P &L reports and Variance analysis report from Dodeca tool
• Improvise the process by suggesting innovative ideas and take initiative to automate the process.
• Deploy proper knowledge management process within Consumer Lending group by regularly updating the process documents and create back up for all the process.
• Consumer lending finance group brings together enterprise functions that drive Wells Fargo's financial management, including accounting and control, financial planning and analysis, line of business finance, asset-liability management, treasury, tax management, and the company's investment portfolios. Key portfolios include Business facing finance support for Home Lending FP&A activities.