Marketing Analytics (SQL Coding) - Associate Sr. -

Job Description
The Quant Analytics Associate Sr. role is part of the Business Banking D&A Marketing Team. This dynamic position will be focused on providing data driven solutions to questions/problem statements on Adhoc basis from Business related to BB Campaigns & Acquisitions and will require lot of interaction with the stakeholders. This will require a strong understanding of the end-to-end business processes and involve a lot of Data discovery and documentation. This is a high exposure role that offers frequent opportunities to work directly with presidents, general managers.
Our business is based on a strong culture of highly informed decision-making. As such, the successful candidate will be one who is able to scan across a large ecosystem of data, research, and other customer insights, to develop and influence critical initiatives and marketing strategies across teams and channels.
Job Responsibilities:
This is a vital hands-on role so we're looking for exceptionally creative, ambitious, \"data curious\" thinkers who can help to extract true business value from data. A typical day might include:

• Interact with the stakeholders to understand business needs and work closely with them to analyze the problem statements and provide data driven insights.
• Involve in identifying different data points required for the analysis throughout the Enterprise Data warehouse.
• Writing Sql Codes/Stored procedures to capture data required and share it with stakeholders in form of Tableau report or Presentations.
• 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 data logics are documented correctly and stored 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
• Leadership : The ideal candidate will (at a minimum) exhibit the below leadership abilities:
  • Make smart decisions that will have an impact on both business and people
  • Solve business problems having highest complexity level
  • Should be self-motivated and able to coach team for consistent high performance
  • Able to help manager in identifying and onboarding talents across industry, mentor newer team members and identify growth opportunities for existing team members

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 8+ 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 preferred. Hands-on experience with standard data analytics tools and technologies (SQL, Alteryx, Tableau)
• 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
• 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 and having knowledge of Campaigns & Acquisitions
• 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

About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
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. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
About the Team
Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.
The CCB Data & Analytics team responsibly leverages data across Chase to build competitive advantages for the businesses while providing value and protection for customers. The team encompasses a variety of disciplines from data governance and strategy to reporting, data science and machine learning. We have a strong partnership with Technology, which provides cutting edge data and analytics infrastructure. The team powers Chase with insights to create the best customer and business outcomes.