Apply Now    

Business Intelligence Support Analyst (Informatica/ETL/Data Warehouse)

Req #: 180021447
Location: Glasgow, SCT, UK
Job Category: Technology
Potential Referral Amount: 3500 Pound Sterling (GBP)
Data Warehouse/Informatica/ETL Support Analyst
Client Intelligence is a platform that provides analytics on clients, deals, bankers, products, and profitability measures at the detail and aggregated level across key business metrics and dimensions. It contains a service-oriented, secure and scalable information platform; it is a corporate finance dashboard targeted at senior and junior bankers across different lines of business within the firm.
IBIE serves as data warehouse for Banking and Research, Client Profitability/Analytics for IB Markets and Whole Sale Client Profitability system for the Firm. The warehouse has five data marts and feeds to 20+ downstream systems. The platform uses many tools including Informatica, Oracle and columnar database Vertica. IBIE is one of the biggest database clusters in the Firm and runs around 1500 jobs every day.
Key Requirement
  • Ability to work in a highly energetic global environment showing ability to quickly overcome technical challenges and respond appropriately.
  • Experience in working as L3 support in a large scale data warehouse with tight deadlines
  • Strong communication and verbal skills as individual may be required to work closely with clients, users and managers.
  • Excellent analytical and problem-solving skills.
  • Good team player, gets on well with others and able to work with people of different skill levels.
  • An understanding of quality and process improvement.
  • Good organization skills to keep track of issues & requests and ensure proper follow-up and closure
  • 3rd line support for Production Night cycle (may require out of hours support)
  • Support UAT Night Cycle
  • Support downstream partners to resolve data queries
  • Support AD teams with data queries for upstream systems
  • Participate in agile daily scrums, sprint planning and sprint retrospective activities.
Required Skills: 
  • Proven track record in L3 Support experience in a large scale data warehouse environment
  • Hands on experience of troubleshooting and issue resolution
  • Ability to quickly analyze and communicate root cause and resolution steps
  • Strong verbal and written skills
  • Ability to work unsupervised to tight deadline
  • Proven ability to identify bottlenecks in slow performing processes and provide appropriate solutions
  • Hands on proficiency in the following tools/skill sets are a must: Informatica, Oracle (including SQL and PL/SQL) and UNIX scripting
  • Demonstrate ability to understand and work effectively within complex IT environment containing onshore/offshore model, multiple development and testing environments, sharing of environment with multiple teams, load balancing and disaster recovery setup.
  • Possess excellent written and verbal communications skills  
Additional Optional Skills
  • Knowledge of one or more of the followings would be a plus:
    • Vertica
    • Autosys
    • Hands on /knowledge of reporting tools (Cognos, Qlikview, Qliksense)
    • Business Analysis
Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.