Job Responsibilities:
- Interact with the stakeholders to understand business needs and work closely with them to come up with the efficient solutions
- Writing Sql Codes/Stored procedures capturing all the logics to identify the exceptions, developing Tableau reports out of it and delivery of the control reports – taking ownership end-to-end
- Ensure codes are designed efficiently to maximize performance and consistency of reporting environment. Enhance ad-hoc reporting capabilities for broad user community
- Ensure the reporting elements are organized, clearly labeled, and assigned meaningful descriptions. Ensure commonly used formulas and variables are built into reporting universe
- Ensure all the reporting elements are automated and executing in controlled environment and has appropriate documentation in Bitbucket repository
- Pro-actively identify key growth areas and opportunities and communicate recommendations to the leadership team and various teams across the firm to influence and fine-tune our strategies.
- Collaborate with cross-functional strategy teams within Business Bank to design and deliver customized analyses and strategic roadmaps and synthesize the data into actionable insights to influence and drive business and strategies.
- Providing regular updates to key stakeholders and senior leaders
Required Qualifications, Skills and Capabilities:
- Bachelor’s / Master's Degree in quantitative discipline such as business, finance, economics, engineering, statistics, information system, or mathematics with minimum 7 years of experience in Data Transformation and Visualization
- Hands-on experience with standard data analytics tools and technologies
- Flexibility/adaptability, ability to listen and defend or change direction based upon team and stakeholder consensus. Self-motivated, goal-oriented, and able to manage and deliver in an innovation-operated and fast-paced environment
- Should have a very good understanding of IT processes and databases. Should be able to work directly with Stakeholders/Partners and contribute in building controls reporting suite. Have a demonstrated ability to think both independently and collaboratively to implement creative solutions that solve business problems, being diligent in the detail while maintaining focus on broader purpose and business objectives
- Leadership managed ability to analyze problems, design solutions, and communicate effectively and confidently with relevant stakeholders to influence and gain buy-in across various job functions. Flexibility/adaptability, ability to listen and defend or change direction based upon team and stakeholder consensus
- Superior judgment to mitigate risk, and to foster an environment where risk/control issues are escalated and trends are anticipated and identified
- Experience in wrangling large, complex datasets, strong database skills and ability to write, optimize and tune complex SQL scripts. Experience delivering analytics solutions under strict timelines quick turn-around
Preferred Qualifications, Skills and Capabilities:
- Experience on ETL tools like Alteryx & Visualization tool like Tableau
- Previously worked in an insights function at a financial services firm or consulting firm supporting Financial firms.
- Have a strong grasp of big data disciplines, AWS, Agile (scrum) methodologies, and new technologies. Able to communicate effectively with Senior leaders to enable collaboration, decision-making, and transparency
- Are a lifelong learner and hold a growth mindset; we welcome individuals who geek out on industry podcasts, stay abreast of cutting edge techniques, and love to share what they are learning with the rest of the team
- Have a demonstrated ability to think both independently and collaboratively to implement creative solutions that solve business problems, being diligent in the detail while maintaining focus on broader purpose and business objectives
- Hands-on experience writing complex SQL code and automating processes to source, transform and analyze data from multiple sources including structured and unstructured data preferred.