Lead Analytics Consultant

About this role:

Wells Fargo is seeking a Lead Analytics Consultant part of the Technology Analytics team and provides works/collaborate closely with the other team members to provide best in class Analytics support.

In this role, you will:

• Advise line of business and companywide functions on business strategies based on research of performance metrics, trends in population distributions, and other complex data analysis to maximize profits and asset growth, and minimize operating losses within risk and other operating standards
• Provide influence and leadership in the identification of new tools and methods to analyze data
• Ensure adherence to compliance and legal regulations and policies on all projects managed
• Provide updates on project logs, monthly budget forecasts, monthly newsletters, and operations reviews
• Assist managers in building quarterly and annual plans and forecast future market research needs for business partners supported
• Strategically collaborate and consult with peers, colleagues, and mid-level to senior managers to resolve issues and achieve goals
• Lead projects, teams, or serve as a peer mentor to staff, interns and external contractors

Required Qualifications:

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

Desired Qualifications:

• This position will be responsible for creating, maintaining, and augmenting data and analysis solutions within the Technology Analytics environment, utilizing multiple presentation solutions, including PowerPoint, Excel/Excel Web Services, Power BI, Python and SSRS.
• Involve directly in the technical build-out and/or support of query tools, databases and ETL using SSIS
• Hands on with database design/orchestration fulfilling data/reporting requirements
• Extensive on complex SQL development and performance tuning
• Good at data modelling skills to integrate data from multiple sources
• Providing statistics, accurately based on the large volume of data, to appropriate partners requests
• Communication skills and the ability to develop a story from the data are a must along with strong data visualization and database skills.
• Duties typically include providing leadership & insights, developing analytical strategies, performing analytical support and/or modeling regarding a wide array of business initiatives.
• This position will leverage SQL Server (SSRS, T-SQL, etc.), automate metrics calculations from available source data, and provide ad-hoc analytics with focus on WFT objectives, based on business requirements and in partnership with stakeholders.
• Relational database and data repository experience
• Understanding of data governance & associated frameworks in global banks
• Experience designing reusable ETL solutions using Python and/or SSIS
• Experience with automation of data quality/governance controls
• Ability to work independently
• Ability to organize and manage multiple priorities
• Advanced Microsoft Excel skills
• Experience meeting high production and quality standards in a fast paced, development and production support environment
• Knowledge and understanding of Data Models, ERD, Dimensional Models and Metadata
• Experience working with complex datasets using SQL
• Advanced data modeling skills and experience in capacity planning
• Proficiency in data quality analysis
• Experience using data analysis to identify trends
• Ability to develop business metadata and data dictionaries
• Experience analyzing data defects, identifying the root cause and defining the remediation options.
• Knowledge of data security and governance principles utilized at WF
• Release process knowledge and experience using ServiceNow and/or DevSecOps
• Working knowledge of EPL including GitHub, Liquibase
• Proficiency in written skills to author requirements documents, specifications and training documents.
• Developing and following best practice for data management.
• Ability to research, analyze, document, and present organizational metrics that drive business decisions
• Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations
• Ability to research, compile, and present critical operational data in executive summaries
• Ability to communicate effectively, in both written and verbal formats, with senior executive-level leaders
• Ability to convert data into visualization with a focus on telling a story with large amounts of data from many data sources is required for this position.

Job Expectations:

• 5+ years of experience in T-SQL, SSIS, Teradata, data modelling, data analysis; or a BS/BA degree or higher 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.
• Hands on with database design/orchestration to fulfil data requirements
• 5+ years of experience in data product lifecycle (MS SQL, Oracle, Teradata)
• Exceptional SQL skills, Performance tuning of reports/query optimization
• 5+ years of experience on Microsoft BI (SSIS/SSRS/SSAS/SQL Server)
• Good at data modeling skills to integrate data from multiple sources
• Knowledge and understanding database and ETL best practices
• 3+ years of experience with ETL design and implementation
• Knowledge and understanding of data organizing or structuring complex data scattered across various data sources
• Knowledge and understanding of database architecture, design, and support
• Experience conducting root cause analysis for data-driven process-related improvements and troubleshoot data/report discrepancies
• 5+ years of experience on Tabular/Multidimensional Model using SSAS
• 2+ years of experience in Python (Pandas, oracledb, sqlalchemy, etc) or any other scripting language
• Should be able to narrate stories, recommend actions/next steps using data
• Excellent verbal, written, and interpersonal communication skills

Posting End Date: 

*Job posting may come down early due to volume of applicants.

We Value Equal Opportunity

Wells Fargo is an equal opportunity employer. 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.

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