JPMorgan Controls- Production Support Metrics & Reporting - Senior Associate 

United States, Florida, Tampa 

826187424

As the Production Support Metrics & Reporting - Senior Associate in the Agile Metrics and Solutions Team, you will primarily work 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. You will also help tech to make enhancements to the various case management systems to continue growth and efficiency for the teams.

Job responsibilities

• 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 SQL, SAS, or MS Access in accordance with practice standards and client requests in order to produce datasets for both internal and external delivery
• Possess 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
• Demonstrate SQL writing ability that pulls from relational databases like Oracle and DB2
• Create daily/weekly/monthly reporting items within Tableau as needed
• Ensure Tech changes are complete and effective

Required qualifications, capabilities, and skills

• 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 within GCO
• 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