Job Description The Analytics Solutions Team primarily works with the internal businesses of Compliance which are AML Investigations, Employee Compliance, Client List Screening, Regulatory Reporting, GFCC Quality Testing, and OFAC Sanctions to create data or reports out of complex business specifications. They also help technology teams to make enhancements to the various case management systems to continue growth and efficiency for the teams.
Responsibilities:

• Experience in developing reports and dashboards in Tableau.
• Partner with teams and drive the planning of strategic automated solutions, creation of reusable reports and extracts, which can be applied to metrics and reports from the bottom to executive level operations
• Assist with the creation, support, and scheduling of SAS programs within the reporting infrastructure
• Create repeatable and standard analytics to help drive business decisions
• Identify, document and track process issues/risks and remediation plans
• Normalize, aggregate, and organize raw data using one or more of the following tools: SQL, SAS EG, or MS Access in accordance with practice standards and client requests in order to produce datasets for both internal and external delivery
• Understanding of end user reporting tools like Business Objects, Cognos, and SharePoint
• Exclude, parse, tag, and segment data according to the provided business rules
• Liaise with line of business to determine the appropriate business rules for logic formation and automation
• Ensure Tech changes are complete and effective

Qualifications:

• Five or more years of experience in an analytical and metric reporting environment working with data
• Advance skills with Tableau, SAS, and in MS Office product suite (Access, Excel, Word, PowerPoint, and SharePoint)
• Demonstrate SQL query writing ability
• Experience with relational databases like Oracle and SQL Server
• Broad understanding of data and its relative concepts (Measures , Dimensions etc.)
• Ability to quickly learn and understand new business segments
• Ability to analyze and review compliance business data to identify key indicators pertaining to operations, risk, finance, Compliance, process and controls
• Design and implement analytical business and technology solutions to meet key indicators
• Ability to perform functions in office tools like VBA, macros, pivots, complex formulas etc.
• Comfortable working with large data sets and normalizing the data for various reporting views
• Update and change SharePoint sites using MS InfoPath or designer

About Us JPMorgan Chase & Co., 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. 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.
The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.
As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set, and location. For those in eligible roles, discretionary incentive compensation which may be awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
Equal Opportunity Employer/Disability/Veterans
About the Team Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.