Data Warehouse/ETL Software Engineer Data Warehouse/ETL Software Engineer …

J.P.Morgan
à Glasgow, Ecosse, Royaume-Uni
CDI, Plein-temps
Soyez parmi les premiers à postuler
Competitive
J.P.Morgan
à Glasgow, Ecosse, Royaume-Uni
CDI, Plein-temps
Soyez parmi les premiers à postuler
Competitive
Data Warehouse/ETL Software Engineer


Data Warehouse/ETL Software Engineer

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.

GIBIE serves as data warehouse for Banking and Research, Client Profitability/Analytics for IB Markets and Whole 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. GIBIE is one of the biggest database clusters in the Firm and runs about 1500 jobs every day.

We are growing the team and looking for a Data Warehouse Lead Developer who is proficient in database and ETL implementations to support GIBIE platform

Key Requirement

  • Ability to work in a highly energetic global environment showing ability to quickly overcome technical challenges and respond appropriately.
  • Experience in working on projects with demanding timelines.
  • Keeps abreast of industry trends and able to bring industry standards and best practices, lessons learned to projects.
  • Strong communication skills as this individual will need 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


Skills and Experience

  • Hands on experience and hands on proficiency in the following tools/skill sets are a must: Informatica, Oracle and UNIX scripting, delivering high quality solutions.
  • SDLC lifecycle experience leading development efforts within data warehouse environment with complex dataflow and data integration from multiple sources with different integration strategies (push vs pull, file vs database, etc.).
  • Knowledgeable with data warehouse concepts such as: SCDs, star schema, hierarchy, aggregation.
  • Demonstrated 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.
  • Knowledge of one or more of the followings would be a plus: Vertica, Autosys and star schema-based reporting.
  • Ability to quickly grasp problems and issues and communicate effectively with other team members.
  • Understanding of development using SCRUM and Agile practices
  • Possess good communications skills



At JPMorgan Chase& Co. we value the unique skills of every employee, and we're building a technology organization that thrives on diversity. We encourage professional growth and career development, and offer competitive benefits and compensation. If you're looking to build your career as part of a global technology team tackling big challenges that impact the lives of people and companies all around the world, we want to meet you.

@2019 JPMorgan Chase & Co. JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.

Close