AVP - Analytics Consultant

In this role, you will:

• Consult with business line and enterprise functions on less complex research
• Use functional knowledge to assist in non-model quantitative tools that support strategic decision making
• Perform analysis of findings and trends using statistical analysis and document process
• Present recommendations to increase revenue, reduce expense, maximize operational efficiency, quality, and compliance
• Identify and define business requirements and translate data and business needs into research and recommendations to improve efficiency
• Participate in all group technology efforts including design and implementation of database structures, analytics software, storage, and processing
• Develop customized reports and ad hoc analyses to make recommendations and provide guidance to less experienced staff
• Understand compliance and risk management requirements for supported area
• Ensure adherence to data management or data governance regulations and policies
• Participate in company initiatives or processes to assist in meeting risk and capital objectives and other strategic goals
• Collaborate and consult with more experienced consultants and with partners in technology and other business groups

Required Qualifications:

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

Desired Qualifications:

• Bachelors degree or higher in a quantitative field such as computer sciences, engineering, applied math, accounting, finance, economics, econometrics with a quantitative emphasis.
• Experience in one or a combination of the following: Data quality, reporting, analytics.
• Prior experience in an internal/external consultative role and/or investment banking/corporate banking support experience is preferred.
• Prior experience in handling small or medium complexity projects individually, complex or large-scale project participation, experience with matrix managed teams is a plus
• Candidates should have a solid mastery of Advanced SQL, Advanced Excel, Power BI, knowledge in performing ETL tasks using SQL Python, Microsoft PowerPoint skills
• The successful candidate will have a very strong interest in developing both business and technical skills while navigating a dynamic business environment.
• Excellent verbal, written, and interpersonal communication skills
• Strong analytical skills with high attention to detail and accuracy
• Experience with and knowledge of relational databases and concepts
• Ability to interact and build relationships with senior leaders, peers and key support partners.
• Ability to work creatively, analytically and independently in a dynamic environment.
• Exceptional oral and written communication skills and ability to communicate effectively with both business unit (non-technical) and development (technical) personnel.
• Experience documenting processes and reporting workflows

Job Expectations:

• Strong Individual contributor with excellent communication skills for a variety of audiences (other technical staff and senior management) both verbally and in writing
• Experience in problem analysis, solution implementation, and change management
• Must make timely and independent judgment decisions while working in a fast-paced and results-driven environment
• Ability to articulate issues, risks and proposed solutions to various levels of staff and management
• Capability to multi-task and finish work within strict timelines and provide timely requests for information and follow-up questions
• Skill in managing relationships with key stakeholders
• Eagerness to contribute collaboratively on projects and discussions
• Perpetual interest in learning something new, but being comfortable with not knowing all the answers
• Attention to detail in both analytics and documentation
• Connects with customers to understand and document business processes workflow.
• Develop understanding of business processes and recommend efficiency based on technical and architectural knowledge
• Provide both technical consulting to business leaders at an appropriate level of information encapsulation
• Apply critical thinking skills and perform advanced analytics with the goal of solving complex and multi-faceted business problems.
• Develop reports using Power BI, SQL, Tableau, Python, Excel or various other tools
• Having SSRS knowledge will be added advantage
• Verify accuracy of reports, reconciling data and producing data/information within established timelines
• Generate deep insights through the analysis of data and understanding of operational processes and turn them into actionable recommendations
• Work with technology partners to managing tables, views and other database structures to adapt to changing business needs and in compliance with embedded IT policies.
• Answer ad hoc questions from customers including confirming data, populating templates provided to the group or creating new reports/extracts as requested by customers
• Collaborate with team members to operate at higher level of dimensionality to innovate and bring in game changing ideas to fruition
• Partner with business stakeholders in the development of key business reporting (e.g. Portfolio level dashboard, Productivity, regulatory reporting etc.) and optimal delivery channels for the distribution of the reporting solutions