Feb 21, 2020
Job Description Important Note: During the application process, ensure your contact information (email and phone number) is up to date and upload your current resume when submitting your application for consideration. To participate in some selection activities you will need to respond to an invitation. The invitation can be sent by both email and text message. In order to receive text message invitations, your profile must include a mobile phone number designated as "Personal Cell" or "Cellular" in the contact information of your application. At Wells Fargo, we want to satisfy our customers' financial needs and help them succeed financially. We're looking for talented people who will put our customers at the center of everything we do. Join our diverse and inclusive team where you'll feel valued and inspired to contribute your unique skills and experience. Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you. Enterprise Finance drives financial management for the company and maintains and enhances risk and financial controls. Key functions within Enterprise Finance include finance and accounting; Treasury; corporate development, mergers, and acquisitions; Data Management and Insights, the Customer Remediation Center of Excellence, Enterprise Shared Services, Business Process Management, and Corporate Strategy. Enterprise Finance informs shareholders, regulators, taxing authorities, team members, and leaders of the company's financial performance through earnings releases, investor meetings and conferences, and meetings with regulators and credit rating agencies, following appropriate reporting guidelines. They also maintain and enhance risk and financial controls and lead many of the company's shared services functions including corporate properties, security, and global services. Wells Fargo is seeking a highly motivated individual to join a team of data analytics professionals supporting COSO testing and will have enterprise-wide exposure to key stakeholders within the external financial/risk/regulatory reporting infrastructure. The Enterprise COSO Testing team is a component of the Enterprise Controls & Oversight (ECO) Group in Corporate Controllers. The IT COSO team within ECO supports the Company's on-going objective of maintaining an industry-leading information technology control environment and is responsible for the following directives: Providing meaningful assessments of IT control environments impacted by financial, risk, and regulatory reporting; Assessing compliance with Well Fargo & Company's COSO based policies for IT controls impacted by internal controls over financial reporting (SEC and Regulatory Reporting) and strategic planning for on-going IT control compliance with COSO policies (proactive anticipation of internal control related matters); Monitoring new and emerging internal control related guidance and issues and assist with facilitating group-wide training to interested and impacted stakeholders; Providing consultation and subject matter expertise for process and IT control related matters including evaluating severity of control deficiencies and related remediation efforts; Providing process and control support and thought leadership for projects; Interfacing with external auditors, regulators and others on control related matters; and, Acting as a change agent for continual improvement of the control environment. This individual will be responsible for supporting the following team directives: Facilitating the identification of opportunities to utilize data analysis in the assessment of risk and controls. Performing business analysis, project management, design and solution testing of analytics in adherence to our development methodology. Partnering with ECO teams to ensure data analytic needs are met such as continuous auditing activities, robotics, special projects, substantive testing support, etc. Navigating within technology environments to locate, validate, extract, and format data for data analysis. Analyzing complex data and providing the analytic results in a user-friendly format. Developing and maintaining program scripts used for data analysis, controls automation and controls testing. Providing recommendations on types of analytics and procedures used to meet control testing objectives. Communicating data analysis conclusions to management. Ensuing accuracy and completeness of analytic results. Building relationships and collaborating with key stakeholders related to assigned areas. Assisting with projects impacting the broader team. Required Qualifications 4+ years of experience in one or a combination of the following: finance, accounting, analytics, reporting or business/technology audit; or a BS/BA degree or higher in Finance, Accounting, Statistics, Economics, or Business and 2+ years of experience in one or a combination of the following: finance, accounting, analytics, reporting or business/technology audit Desired Qualifications A BS/BA degree or higher in one or a combination of the following: Finance, Accounting, Analytics, or Reporting Ability to successfully operate in a complex and matrixed environment 4+ years of experience with SAS or SQL, or other data management, reporting and query tools 2+ years of Tableau experience Ability to develop operational reporting and performing complex data analysis Basic Microsoft Office (Word, Excel, Outlook, and PowerPoint) skills Intermediate Microsoft Visio skills Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment Excellent verbal, written, and interpersonal communication skills Ability to take on a high level of responsibility, initiative, and accountability Other Desired Qualifications Minimum two years Big Four/super regional public accounting firm experience in IT audit and/or IT SoX advisory/consulting service Strategic understanding of the applicability of industry tools such as ACL (Audit Command Language) General knowledge and understanding of programming languages and tools (Visual Basic, SQL Server Management Studio, SQL Server Reporting Service, etc.) Advanced SharePoint expertise to include development of tools and reporting utilizing the SharePoint, Microsoft Office tools and databases such as SQL server Ability to gather business and data requirements Certification in one or more of the following: CISA, CPA, CIA, CAP (Certified Analytics Professional), ACDA (ACL Certified Analyst), SCBDP (SAS Certified Big Data Professional) Ability to work with a variety of source data formats Working knowledge of various database designs, strategies (SQL, Oracle, Teradata etc.) Knowledge of ETL processes, master file management Ability to conceptualize and implement new analytic approaches and methodologies Strong critical thinking skills with ability to credibly challenge status quo; significant experience with continuous improvement of IT control testing processes and results Strong relationship management skills; ability to negotiate difficult positions without harming relationships Disclaimer All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act. Relevant military experience is considered for veterans and transitioning service men and women. Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.
Charlotte, NC, USA