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