Business AnalystJPMorgan Chase

Job Description: .
Primary Responsibilities:
Manual Report Production
Extraction of data, transformation, analysis and delivery of business reports using Alteryx, Toad for Oracle, TERADATA, Oracle SQL Scripts, MS SQL Server, MS Access, VBScripts and MS Office tools
Retrieval of data from applications and other reporting platform, consolidation to consumable reporting view and delivery to business users.
Supports business functions under Home Lending Originations.
Report Automation - (Alteryx, Toad for Oracle, SSIS, MS SQL Server)
Knowledge of Alteryx, Toad, SSIS, SSRS, Tableau and MS SQL Server to create, modify and re-execute SQL Scripts manually based on the requirements
Monitoring of completed reports executed via different report delivery tools such as Toad or Alteryx and updates the template aligned to the report if needed.
Conversion of Manual Reports (MS Access and Excel Manual reports like dashboards) to Alteryx workflows then be consumed in a reporting system like Tableau
Intermediate knowledge of VBA and/or Python programming to create/modify report and schedule/execute and monitor using Task Scheduler
Report Modification of Manual (JIRA, Toad, MS SQL Server) Reports
Modification of existing Manual, Toad, MS Access and SSIS packages to accommodate business change requests by understanding business requirements, applying TERADATA ICDW, Oracle and SQL Server Script logic change, engaging business users during report validation and full production implementation and support
Skills Required:
MS Access - intermediate is preferred
MS Excel - intermediate is preferred
Toad for Oracle - intermediate is preferred
VBScript - intermediate is preferred
Alteryx - basic is required
MS SQL - basic is required
SharePoint - basic is preferred
Tableau -basic is preferred
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.
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.
JPMorgan Chase

Metro Manila
Permanent
Full-time