**About this role:** Wells Fargo is seeking a Lead Business Intelligence Consultant for the Wells Fargo Auto Data Services team. In this role, you will use your technical skills and knowledge of banking data to perform data validations of high-risk reporting including, but not limited to, control reports, customer redress, and regulatory data requests. You will be heavily involved in Change Management activities related to modernizing Wells Fargo Auto's servicing system and enhancing the associated data environment. Learn more about the career areas and lines of business at wellsfargojobs.com (https://www.wellsfargojobs.com/career-areas/) **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:** + 5+ 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 + 5+ years of SQL experience + 5+ years of SAS programming experience + 5+ years of banking experience + Unix 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. + Auditing background or experience working with audit teams is preferred. **Job Expectations:** + This position offers a hybrid work schedule. + Ability to work nights, weekends, and/or holidays as needed or scheduled **Posting Locations:** + 2501 S Price Rd – Chandler, Arizona + 401 S Tryon St - Charlotte, North Carolina + 1100 Corporate Center Dr Lot B - Raleigh, North Carolina + 6051/6061 N State Hwy 161 - Irving, Texas Required locations listed above. Relocation assistance is not available for this position. Job posting may come down early due to volume of applicants. This position is not eligible for Visa sponsorship. **Posting End Date:** 19 Nov 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 (https://www.wellsfargojobs.com/en/diversity/disability-inclusion/) . **Drug and Alcohol Policy** Wells Fargo maintains a drug free workplace. Please see our Drug and Alcohol Policy (https://www.wellsfargojobs.com/en/wells-fargo-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. **Req Number:** R-416159