Data Analytics (SQL, Tableau) - Associate

Key Skills

Alteryx, AWS, Big Data Technology, Data Analytics, Data Transformation, Data Visualization, Database, Design, Effective communication skills, Scrum Agile Methodology, SQL, Tableau

Job Description

The Deposit 2.0 initiative is charged with revolutionizing Chase’s deposit platform. This team will use agile development principles to build and maintain operational dashboards that will drive the development of new services for Chase deposit customers. This critical function will help transform the deposit experience for over 36 million customers. This team will also provide ad hoc analytic support to the Deposit 2.0 team as needed.

Job Responsibilities:

• Interact with the stakeholders to understand business needs and work closely with them to produce the efficient solutions.
• Writing SQL Codes/Stored procedures capturing all the logics to identify the exceptions, developing Tableau dashboards 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 consumer Bank to design and deliver customized analyses and strategic roadmaps and synthesize the data into actionable insights to influence and deliver 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 4-7 years of experience in Data Transformation and Visualization.
• Hands-on experience writing complex SQL code and automating processes to source, transform and analyze data from multiple sources including structured and unstructured data will be advantage. Hands-on experience with standard data analytics tools and technologies (SQL, Tableau, Alteryx & 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.

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.

ABOUT US

J.P. Morgan is a global leader in financial services, providing strategic advice and products to the world’s most prominent corporations, governments, wealthy individuals and institutional investors. Our first-class business in a first-class way approach to serving clients drives everything we do. We strive to build trusted, long-term partnerships to help our clients achieve their business objectives.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as any mental health or physical disability needs.