Risk Analytics Consultant

About the Role
This role requires a developed understanding of Current processes and expertise in data analysis, reviewing database objects and building proof of concepts for new reports using advanced SQL. This knowledge is required to lead the activities of executing on the Risk and Controls model, collaborate within and across teams. This role will ensure documentation covering multiple functions as team member will be implementing several projects collaborating with IT as a part of this initiative with all the below daily responsibilities and requirements.

Responsibilities
Requirement collection and preparation of the Business Requirement document.
Developing SQL codes as per Business requirement document to create automated reports.
Developing Power BI Dashboards.
Creating backend scripts for testing and validating the changes.
Preparing Static data like Account Master and Instrument master.
Perform functional and regression testing for the changes/enhancements.
Lead the team deliverables in Agile framework and active usage of JIRA tool to achieve the same.
Act as Project Manager for all the assigned items and work with IT Team and stakeholders.
Analyze the existing queries for performance enhancement.
Handling Ad-hoc queries and Troubleshooting.
Essential Qualifications
B. Tech (IT)/BSC (CS)/MSC (CS) OR M.B.A degree with 7+ yrs. of relevant experience.
Excellent understanding of SQL programming and Power BI.
Proven leadership, team building and cross functional partnership skills.
Strong understanding of the source to target mapping, analyzing & creating transformation logics.
Desired Qualifications
Experience working in global teams.
Proficient in working with complex data model, especially associated with building new product.
Advanced desktop skills in MS Office products especially MS Excel and MS Access and tools like SQL, Tableau, Power BI
Experience in researching and resolving Data flow issues.
Strong interpersonal skills to effectively build and maintain partnership with key stakeholders and partners.
Outstanding problem-solving skills.
Ability to be agile, flexible and adjust plans quickly to meet changing business needs
Ability to perform well under pressure.
About the Role
This role requires a developed understanding of Current processes and expertise in data analysis, reviewing database objects and building proof of concepts for new reports using advanced SQL. This knowledge is required to lead the activities of executing on the Risk and Controls model, collaborate within and across teams. This role will ensure documentation covering multiple functions as team member will be implementing several projects collaborating with IT as a part of this initiative with all the below daily responsibilities and requirements.

Responsibilities
Requirement collection and preparation of the Business Requirement document.
Developing SQL codes as per Business requirement document to create automated reports.
Developing Power BI Dashboards.
Creating backend scripts for testing and validating the changes.
Preparing Static data like Account Master and Instrument master.
Perform functional and regression testing for the changes/enhancements.
Lead the team deliverables in Agile framework and active usage of JIRA tool to achieve the same.
Act as Project Manager for all the assigned items and work with IT Team and stakeholders.
Analyze the existing queries for performance enhancement.
Handling Ad-hoc queries and Troubleshooting.
Essential Qualifications
B. Tech (IT)/BSC (CS)/MSC (CS) OR M.B.A degree with 7+ yrs. of relevant experience.
Excellent understanding of SQL programming and Power BI.
Proven leadership, team building and cross functional partnership skills.
Strong understanding of the source to target mapping, analyzing & creating transformation logics.
Desired Qualifications
Experience working in global teams.
Proficient in working with complex data model, especially associated with building new product.
Advanced desktop skills in MS Office products especially MS Excel and MS Access and tools like SQL, Tableau, Power BI
Experience in researching and resolving Data flow issues.
Strong interpersonal skills to effectively build and maintain partnership with key stakeholders and partners.
Outstanding problem-solving skills.
Ability to be agile, flexible and adjust plans quickly to meet changing business needs
Ability to perform well under pressure.

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

Drug and Alcohol Policy

Wells Fargo maintains a drug free workplace. Please see our Drug and Alcohol Policy to learn more.