senior analytic Consultant for wceaWells Fargo

Job Description : * Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with $2.0 trillion in assets. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, insurance, inve Job Description : Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with $2.0 trillion in assets. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, insurance, investments, mortgage, and consumer and commercial finance through more than 8,500 locations, 13,000 ATMs, the internet (wellsfargo.com) and mobile banking, and has offices in 42 countries and territories to support customers who conduct business in the global economy. With approximately 273,000 team members, Wells Fargo serves one in three households in the United States. Wells Fargo & Company was ranked No. 25 on Fortune's 2017 rankings of America's largest corporations. Wells Fargo's vision is to satisfy our customers' financial needs and help them succeed financially. News, insights and perspectives from Wells Fargo are also available at . 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. Department Overview Wholesale Customer Experience Analytics, which includes the Wholesale Customer Experience Management program and data teams (Janice Baker), Treasury Management (TM) Delivery and CB reporting and business intelligence (Catherine Munsch), Transactional Risk Intelligence Reporting,and Data Delivery, Infrastructure and TM Risk and Compliance data support (Rohit Bhadri), performs the data and analytic functions for TMPS and broader CB businesses. WCEA also drives analytics for TRIG Business which support Financial Crimes, Transaction analysis on many money movement products, Portfolio reviews and managing relationships for Correspondent Banking Financial Institution to Financial Institution) About the Role: The role sits with CB Data & Analytics Team to support the Data Architecture group on issue analysis, routine data tasks, issue identification and enhancements Understanding the dynamics of Web Log data capture and the underlying implication to the data warehouse and business partners. Create complex queries joining multiple Databases/tables/views to retrieve and analyze information in support with business partner's needs Create query logic to explore and investigate possible data anomalies/exceptions/discrepancies Monitor (request or perform as necessary) data processing or update tasks needed This role will be responsible for partnering across the WCIA teams to understand the Dimensional Model environment, objects and processes to support the seamless updates of Tableau Reports of our partners. The role will also require extensive data manipulation language (DML) skills to performs analysis on specific dimensions that business would like to look at. Responsibilities: Perform various complex activities in partnership with Technology Team to supporting end user (Reporting Team) updates like data load/updates Monitor, report, and analyze any data discrepancy/exceptions Assist in validation processes with respect to newly developed data and architecture builds Assist in Identifying opportunities for possible improvements or automations. Enhance and standardize performance analysis, reporting packages and business processes Essential skills qualifications: Bachelor of Science in a quantitative field such as applied math, statistics, engineering, physics, accounting, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis 5+ years of experience in following: Dimensional Models, Data Warehouse, Root cause analysis skills for system issue/fall-out deep dive, and Exploratory data analysis Exposure to Web capture technology and architecture Partner with leaders and team members in a geographically dispersed team environment 5+ years of experience developing SAS, SQL, Tableau, R/Python 5+ years of experience in an environment that utilizes large relational databases such as SQL Server, Oracle, DB2, or Teradata Good understanding of Data Quality Dimensions and Use Cases Good understanding of data flows and transformation (ETL/ELT/ETLT) Excellent verbal, written and interpersonal communication skills Strong analytical skills with high attention to detail and accuracy Desired Qualifications: Languages: T-SQL, Teradata SQL, SAS, R/Python BI Tools: Oracle BI/SSRS/Tableau/PowerBI OS: MS Windows Financial services experience (Wholesale Banking a plus) and Operations research Understanding Financial products, systems, and platforms Exposure to or understanding of Agile Solution Development Life Cycle team environment Exposure to Teradata Studio kit Applications: MS Office (Access, Excel, Word, PowerPoint), SharePoint 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, 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.
Monster

Philippines
Permanent
Full-time