VBA Business Analyst role supports Home Lending strategic initiatives team & its counterparts by creating and managing complex User Tools.

Job Responsibilities:

Creating automated solutions to provide efficiencies and maintaining existing tools: Understanding VBA coding language  Modifying existing VBA code & fixing bugs  Interpreting BRD’s, validating requests from LOB and developing  Version control & password resiliency  Oversight of UT inventory  Documenting solutions, including technical requirements and operating instructions Assisting other business analysts understand UT design as needed  Operate with minimal to no supervision and drive things through to completion

Required qualifications, skills and capabilities:

Minimum of 5 years of experience related to process automation and VBA Extensive experience working with VBA  Advanced Microsoft Excel experience including macro development and design  Visualization experience working with Tableau Desktop and Server Capable of technically guiding high performing agile teams Ability to design and code solution a solution from scratch as well as modifying an existing UT Experience troubleshooting skills to identify, root-cause and providing solutions in VBA Advanced critical and analytical thinking skills (ability to devise complex formulas & algorithms); strategic thinking/planning Flexibility and willingness to adapt to new initiatives or changing business requirements Requires the ability to manage multiple functions and tasks while staying within project SLA expectations.  Strong time management and organization skills; ability to identify and escalate risk Ability to work in tandem with colleagues at all levels of the organization and obtain buy in to new concepts and processes, while tailoring reporting appropriately and as warranted Must be able to work within deadlines in a fast-paced environment and possess strong problem solving and relationship management skills.  Heavy Business/Financial acumen; presentation and delivery skills with the ability to “tell the story” Good understanding of Relational Database management systems MS SQL, MySQL and with Non-SQL DB systems is a plus 

Internal Application Eligibility Requirements

PERFORMANCE:

Meets satisfactory performance standards as defined by the firm Not enrolled in Performance Counselling

CORRECTIVE ACTION:

Employees who were given written warning or higher and within the prescriptive period are not eligible to apply.

By submitting an application and/or joining the interview, you affirm to meet the Internal Mobility Eligibility Requirements as stated in the Applying for Internal Positions Firmwide Standard. You are expected to provide true and accurate information to the Company during the recruitment and application process. Knowingly giving false or misleading information shall be subjected to the imposition of appropriate corrective action, following the firm’s HR Policies and Guidelines.

Consult your Manager for any specific guidelines for your line of business or if you’re unsure about your eligibility for an internal application. 

Make sure your profile is updated in the new me@jpmc > Hiring and discuss internal mobility plans with your Manager at the soonest time possible.  Attaching your updated resume is encouraged.

In partnership, Hiring Managers and Recruiters will review applications to determine which candidates best meet the required skills and experience specified in the job description. While not every application will result in an interview, applications will be acknowledged.