Apply Now    

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

Req #: 180021447
Location: Glasgow, SCT, UK
Job Category: Technology
Job Description:
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
 
Duties
  • 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    
Link for schema

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.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.