Job Responsibilities:
- Interact with the stakeholders to understand business needs and work closely with them to produce efficient solutions.
- Writing SQL Codes/Stored procedures/Python code capturing all the logics to identify the exceptions and testing data, developing Tableau dashboards – taking ownership end-to-end.
- Product experience and Cloud Knowledge (AWS and Snowflake)
- 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
- 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 consumer Bank to design and deliver customized analyses and synthesize the data into actionable insights to be delivered to the business.
- 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 4-7 years of experience in Data Transformation and Visualization.
- Hands-on experience writing complex SQL and Python code and automating processes to source, transform and analyze data from multiple sources including structured and unstructured data preferred. Hands-on experience with standard data analytics tools and technologies (SQL, Tableau, Alteryx, Python & Snowflake).
- 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 to 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.
- Experience working on Snowflake, AWS. PySpark .
Preferred Qualifications, Skills and Capabilities:
- 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 candidates 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.