JPMorgan Chase Mortgage Banking - Information Analyst II - Lewisville, TX in Lewisville, Texas
The Information analysts position assist operational units in mortgage banking with creating reports and architecting data structures that assist in managing controls, business processes and information relevant to making decisions about portfolio management.
The role will run the full gamut in delivering useful and analytical data. From creating database objects, ETL of source data, design of processes and possible data modeling all the way to data presentation via either Excel or SSRS reports.
Responsibilities will include, but are not limited to:
- Execute, maintain and enhance various processes and reports that the area currently has in support different lines of businesses within mortgage.
- Develop and code new database objects and processes and tasks that are being requested by the business. SQL (both T-SQL and PL-SQL) are the primary logic languages used. Mid to advance level Excel manipulation may be leveraged for presentation purposes. Beginner to mid-level SSRS report coding and design may also be leveraged for presentation of data.
- Development of dtsx packages using Visual Studio 2012 in support of needed information to drive reports/process needs.
- Adheres to various standards (i.e. technology, business unit and audit) with regards to risk management, security policies and development guidelines.
Requirements: - Problem solver and analytical: Proven track record of being able to understand processes and how an issue can be caused and possible resolutions to that issue. Ability to comprehend and meaningfully collaborate with both technical and non-technical scenarios presented. - Self-motivated: Ability to learn and pick up concepts and understand processes and research as needed to understand or resolve an issue. - SQL: Previous experience with Structured Query Language. Ability to code SQL scrips as necessary to pull the desired result set. T-SQL and PL-SQL is preferred. Mid to advance level SQL knowledge is expected for this position - Database Object Experience: Whether it’s in Oracle, SSIS, MySQL or even MS Access, the candidate must be able to show that he/she has the knowledge and understanding - and preferably experience - in navigating through these object oriented environments. Experience in creating and altering objects (tables, views, stored-procedures) is preferred. - Communication: Ability to communicate clearly and with good and useful information to various levels within the organization, both written and verbal.
Organization: *CONSUMER & COMMUNITY BANKING
Title: Mortgage Banking - Information Analyst II - Lewisville, TX
Location: TX-Lewisville-Lake Vista 3 / 41054
Requisition ID: 160101134