Rosemont, IL

At Wells Fargo, we are looking for talented people who will put our customers at the center of everything we do. We are seeking candidates who embrace diversity, equity and inclusion in a workplace where everyone feels valued and inspired. Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you.

About this role:

Wells Fargo is seeking a Senior Analytics Consultant to join our Rail Data Analytics team.

In this role, you will:

• Business Intelligence- Become a strong technical resource in the implementation of business intelligence tools. Lead functional requirements gathering and discovery workshops. Complete functional design specifications, data dictionaries, process and data flow diagrams, and data mapping.
• Data Analytics - Use business intelligence data, statistical and financial analysis, to develop predictive models. 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
• Knowledge of data warehousing principles
• Understanding of dimensional modeling
• Experience with data visualization tools
• Experience with Oracle Business Intelligence (OBIEE) or a similar business intelligence tools.

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.