Senior Analytics Consultant- Wells Fargo Rail

    • Wells Fargo
  • Rosemont, IL
  • Posted 13 days ago | Updated 4 hours ago

Overview

On Site
USD 92,400.00 - 164,400.00 per year
Full Time

Skills

Business intelligence
Attention to detail
Microsoft Power BI
Policies and procedures
Data Analysis
Business process
Data quality
Data warehouse
Data mining
Data Visualization
Data extraction
RDBMS
Data integrity
Data collection
Test plans
Test cases
Pivot table
Data modeling
Relational databases
Problem solving
Organizational skills
Multitasking
Customer relationship management
Regulatory Compliance
Analytics
Reporting
Data
Modeling
Analytical skill
Auditing
Research
Metrics
Dashboard
Design
Training
Military
SQL
Microsoft Excel
R
Python
Creativity
Communication
Law
FOCUS
Accountability
Finance
Governance
Recruiting
Policies

Job Details

About this role:

Wells Fargo is seeking a Senior Analytics Consultant to support data analytics and reporting for Wells Fargo Rail (WFR). Critical to success, is an in-depth understanding of the underlying data for key business processes to complete data analysis and reporting requests using a variety of tools and methods.

This position supports projects related to data quality and the development of business intelligence and data warehouse solutions. This position supports senior business leaders, with data mining and reporting needed to make data-driven decisions.

In this role, you will:
  • Business Intelligence- Become a strong technical resource in the implementation and support of business intelligence tools that enable analysis, modeling, and data visualization.
  • Data Analytics -Develop analytic capabilities to identify anomalies, outliers, emerging trends, and risks. Identify and interpret trends and patterns in large and complex datasets.
  • Data Extraction -- Execute complex queries on large data sets needed to respond to ad-hoc data requests. Understand the data needed to answer business questions. Combine internal and external data sources as needed. Compile data from the relational database tables and/or data warehouse tables.
  • Data Integrity - Monitor audit reports and complete data reconciliations for data warehouse tables. Prepare data quality reviews, including analysis of findings. Research and analyze data collection inconsistencies and inaccuracies from source system tables. Plan and execute test plans and test cases that ensure data is accurate and complete. Propose recommendations to ensure future data quality.
  • Metrics/Reporting --Present key performance indicators and other metrics on dynamic reports and dashboards. Design, develop, and maintain ongoing reports and dashboards that summarize large volumes of data in easy-to-read formats. Visualize data to help senior business leaders easily identify trends, opportunities, and problems.


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


Desired Qualifications:
  • Advanced proficiency in using SQL for data extraction, manipulation and reporting
  • Advanced proficiency in MS Access
  • Advanced proficiency in MS Excel, including the use of pivot tables
  • Experience in at least one data modeling language or tool such as R, Python
  • Data analysis and reporting experience
  • Understanding of relational databases
  • Analytical, creative, and innovative approach to solving problems
  • Excellent verbal, written, and interpersonal communication skills
  • Strong organizational skills with ability to prioritize workload and maintain concentration while multi-tasking
  • Ability to work independently after goals or objectives are established
  • Strong mathematical aptitude
  • Strong attention to detail and accuracy
  • Ability to take large amounts of data and provide overview with validation of variances
  • Ability to think analytically, define problems, extract large volumes of data, perform data comparison and validation, establish facts and draw valid conclusions
  • Effectively present information and summarize key findings with data formatting that is easy to follow and appropriate to the audience
  • Advanced proficiency in MS Power Point
  • Knowledge of data warehousing principles
  • Experience with data visualization tools
  • Experience with Microsoft Power BI or similar business intelligence tools.


Posting Location

9377 W Higgins Road Rosemont, IL

Salary Range by Location:

Rosemont, IL- 92,400.00 - 164,400.00 USD Annual

Salary range is determined by location of the job. May be considered for a discretionary bonus, Restricted Share Rights, or other long-term incentive awards.

#CommercialBanking

Posting End Date:
8 May 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.