MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious
2

Senior Analytics Assistant

Location Hyderabad, India
Posted 03-July-2022
Description
:

As an integral part of Commercial Banking group, the Business Insights, Analytics, and Tools (BIAT) Team is responsible for development, management and maintenance of MIS reports for various units of CB group by providing Qualitative & Quantitative Analytical Support including design development implementation and mission-critical enterprise Business Intelligence (BI) reports and other tools working with cross-functional teams.


Wells Fargo is seeking a Senior Analytics Assistant who is responsible for delivering the analytic solutions that drive to meet business needs. Using skills and experience as a reporting Analyst, will need to design, develop, test and implement reports and dashboards that utilize the underlying data store(s)/ data warehouse(s) / data mart(s). It includes customer and product profitability, business opportunity pipeline and sales tracking, liquidity trends, and compliance risk management reporting.


Job Duties and Responsibilities:


Sourcing data from across multiple systems (AQUA, Hogan, J System, TradeWorks, Intellitracs, GMTS) using a variety of database reporting applications (DB2, Crystal, ORACLE, TOAD, SQL)
Provide support/generate and distribute existing management information systems (MIS) reports in accurate and timely manner.
Develops MIS documentation to allow for smooth operations and easy system maintenance.
Develop and implement projects addressing moderately complex business issues. Support to develop data models and create strong database designs of moderate complexity.
Support to automate reports by identifying the opportunities on existing process and reports.
Perform data analysis for generating reports on periodic basis.
Understand customer problems and provide appropriate technical solutions.
Create best-practice reports based on data mining, analysis, and visualization.
Identify trends and opportunities for growth through analysis of complex data sets.
Provide strong and timely financial and business analytic decision support to business partners and stakeholders.
Managing risk (procedural, operational, reputational, credit, etc.)
Ensure adherence to compliance and regulatory guidelines.
Demonstrate adherence to Wells Fargo core values.
Provide feedback and present ideas for improving or implementing processes and tools within the Analytics group


Analyzing the data to support functions such as:

Reporting trends of markets, market penetration, credit exposure clients, revenue analysis of trade and FX transactions and product usage for payment services, then researching abnormal variances and troubleshooting any discrepancies found in the data.
Monitoring/quantifying success of business opportunities, sales campaigns and initiatives, and tracking progress towards GPS managements revenue and profitability goals and targets.
Performing calculations on client activity to determine any adjustments needed to account analysis billing for clients using exception processes that cannot be supported through automated system capabilities.
Maintaining logs of active clients and their accounts of various types through account openings, closures and profile updates, and producing a correspondent list to promote our global payment network.
Responsible for maintaining partner relationships, ensuring high quality team deliverables and SLAs.
Designing and solving complex business problems by using analytical techniques and tools.
Works with large data sets, both structured and unstructured, and from multiple sources.
Will be involved directly in the technical build-out and/or support of databases, query tools, reporting tools, BI tools, dashboards, etc. that enable analysis, data visualization and/or advance analytics.

Essential Qualifications:

Bachelor/Master Degree of any discipline, preferably in Business Administration / Commerce / Computer Application.


Desired Qualifications:

5years relevant industry experience. Good knowledge of banking industry and experience in working with financial institutions. Good experience with data warehouse implementations. Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal and external teams.


Technical Knowledge & Skills:


Required Skills:

Tableau/Power BI and other BI Tools.

MS SQL Server

Well versed knowledge in Advanced MS Office Applications


Preferred Skills:

Language VB.Net,

Knowledge of VBA and Macro

Python / R

Database SQL queries (DB2/Oracle/SQL Server)


Desired Skills:

Experience in RDBMS.
Ability to compile research and perform in-depth analysis.
Demonstrate aptitude to independently provide summary and data driven solutions.
Ability to multi-task on projects in a fast-paced environment with minimal supervision.
Ability to work well in team environment and independently.
Experience in developing and creating BI dashboards, working on end-to-end reports, deriving insights from data.
Excellent verbal, written and interpersonal communication skill
Experience
Min 5 to 8 Years.

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url