Description
RM&C - ICB - Risk Data Associate
Short Description
Join the Risk Management and Compliance team at JPMorgan Chase, where you'll play a pivotal role in maintaining our strength and resilience. You'll support innovation and design, assist in the technical implementation of data models, and anticipate emerging risks. Your expertise will help us grow responsibly, challenge the status quo, and transform customer experiences through our digital transformation strategy. This role offers the opportunity to impact our company, customers, and communities while focusing on product excellence.
Job Description
As an Associate - ICB Risk Data & Reporting in Risk Management and Compliance, you are at the center of keeping JPMorgan Chase strong and resilient. You help the firm grow its business in a responsible way by anticipating new and emerging risks and using your expert judgement to solve real-world challenges that impact our company, customers, and communities. Our culture in Risk Management and Compliance is all about thinking outside the box, challenging the status quo, and striving to be best-in-class.
JPMorgan Chase is investing in a digital transformation strategy, exploring innovative ways to attract customers, deepen customer engagement and achieve increased customer satisfaction through efficient and thoughtful interactions with digital products and experiences. We continue to strive toward transforming customer experiences, simplifying business processes whilst remaining laser focused on product excellence.
In this role, as the Risk Data Associate, you will be an individual contributor, working as part of the ICB Risk Data team, help analyze/build data model across all horizon for International Consumer Business (ICB) Risk– Chase UK. You will work closely with senior team members and wide range of stakeholders such as business, data providers, and support functions to understand requirements, complete feasibility study, and create data models around credit, fraud, model and loss forecasting risk needs.
This an excellent opportunity for an individual who thrives in a fast-paced, team-oriented environment where strong data & analytical skills, business acumen, and excellent communication skills will be fully leveraged.
Job Responsibilities
- Design, develop, and optimize SQL queries, stored procedures, and functions for Amazon Redshift data warehouse.
- Must be well versed with various SQL stuffs such as views, functions, stored procedures, triggers, joins , sub queries and dynamic queries.
- Perform data analysis and optimization to ensure optimal performance and scalability of Redshift clusters.
- Utilize Amazon Athena for ad-hoc querying and analysis of data stored in Amazon S3.
- Troubleshoot and resolve database-related issues in a timely manner.
- Collaborate with data engineers and data architects to design and implement efficient data models and ETL processes using AWS Glue.
- Utilize Jira for project management, task tracking, and agile development workflows.
- Manage code repositories and version control using Bitbucket, ensuring code quality and collaboration among team members.
- Develop and maintain data pipelines using AWS Glue for data ingestion, transformation, and loading.
- Work closely with business analysts and stakeholders to understand data requirements and translate them into technical solutions and Develop and maintain documentation, including technical specifications, data dictionaries, and user guides.
- Participate in code reviews, provide constructive feedback, and ensure adherence to coding standards and Mentor junior developers and provide technical guidance on SQL development and AWS services.
Required Qualification
- Master’s degree in computer Application, Bachelor’s degree in Computer Science, Information Technology, or related field.
- 6-9 years of experience as a SQL Developer or Database Developer, with a focus on Amazon Redshift.
- Strong proficiency in SQL programming and database design principles.
- Experience working with AWS services such as Glue, Athena, S3, and Redshift.
- Proficiency in utilizing project management tools like Jira for agile development.
- Experience with version control systems like Bitbucket for code collaboration and management.
- Familiarity with development environments like IntelliJ IDEA or similar IDEs.
- Excellent problem-solving skills and attention to detail.
- Ability to work independently and as part of a team in a fast-paced environment.
- Strong communication skills, both verbal and written.
Preferred Qualifications
- Working knowledge on Python, Looker and Tableau
- Advanced MS Office suite skills (Excel, Word, PowerPoint, Visio, Project)
- Highly self-motivated with an ability to work under pressure, prioritize multiple tasks, and execute to completion.
- Well versed in developing new ideas and process re-engineering
- AWS certifications (e.g., AWS Certified Solutions Architect, AWS Certified Developer) are a plus.
About Us
Across JPMorgan Chase, we serve millions of customers and many of the world’s most prominent corporate and government clients. Our mission is to build a stronger, more equitable economy, and we strive to make a positive impact everyday with our customers in their communities. We are proud of our reputation as one of the world’s most admired companies and we know that it’s our people who make us successful. We are committed to a diverse and inclusive workplace where our employees are welcomed, valued and able to bring their authentic selves and best work forward.
