Senior Lead Business Intelligence Consultant

About this role :

Wells Fargo is seeking a Senior Lead Business Intelligence Consultant.

In this role, you will :

Perform data validations for SHRPs, regulatory issues, control reports, and internally identified issues. Evaluate and test business requirements and programs written by the LOB to run control reports, and output from those programs.

Validate the output of those programs against the data warehouse.

• Provide advice to the LOB on the design and execution of control reports to address issues found by regulators and internal resources.
• Use advanced programming skills in BOTH SAS and SQL to write, modify, and test data extraction and analytics programs in a Unix environment.
• Provide data validation and code review for reports and applications written by other teams within Wells Fargo Auto.
• Review documentation of control processes as implemented by the LOB.
• Collaborate with users to design, implement, automate and manage data acquisition and load processes.
• Translate business needs and objectives into technical requirements and data solutions.
• Perform data discovery and investigation to ensure that the data meets the business objectives.
• Build and maintain the necessary and mandated controls and procedures to ensure data accuracy and business functionality.
• Provide technical consulting, requirements analysis, and code design recommendations to various teams within the business including Credit Risk, Corporate Controllers, and Corporate Credit and COE stakeholders, and LOB Operations.
• Collaborate with other analysts and programmers and serve as a subject matter expert to different teams within the line of business.

Required Qualifications :

• 7+ years of business intelligence and data visualization experience, or equivalent demonstrated through one or a combination of the following : work experience, training, military experience, education
• 7+ years of SQL experience
• 7+ years of SAS programming experience
• 7+ years of banking experience.

Desired Qualifications :

• Excellent verbal and written communication skills
• In depth experience with advanced programming tools and job schedulers, preferably in an applications development environment, which may include some combination of Java, C++, VBA, .

NET, Unix shell scripts, CRON, etc.

• Strong expertise in reporting, analytics, or modeling.
• Knowledge and understanding of business intelligence tools
• Knowledge and understanding of Basel and FRY14Q reporting
• Ability to work effectively in a team environment and across all organizational levels, where flexibility, collaboration, and adaptability are important
• Audit background or experience working with audit teams is preferred

Job Expectations :

• Knowledge and understanding of Basel and FRY14Q reporting
• This position offers a hybrid work schedule.
• This position does not offer Visa sponsorship

Locations :

• 550 S Tryon St, Charlotte, NC 28202
• 2501 S Price Rd Chandler, AZ 85286
• 1100 Corporate Center Dr Lot B, Raleigh, NC 27607
• 6051 / 6061 N State Hwy 161, Irving, TX 75038

Posting End Date : 5 Sep 2024

5 Sep 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.