Software Engineer - DB + ETL

JP Morgan

Location: Glasgow City

Job Type: Full time

Last updated

Be brave, not perfect.
- Reshma Saujani

Organization Description

Our Corporate Technology team relies on smart, driven people like you to develop applications and provide tech support for all our corporate functions across our network. Your efforts will touch lives all over the financial spectrum and across all our divisions: Global Finance, Corporate Treasury, Risk Management, Human Resources, Compliance, Legal, and within the Corporate Administrative Office. You’ll be part of a team specifically built to meet and exceed our evolving technology needs, as well as our technology controls agenda.

Employer Description

J.P. Morgan is a global leader in financial services, providing strategic advice and products to the world’s most prominent corporations, governments, wealthy individuals and institutional investors. Our first-class business in a first-class way approach to serving clients drives everything we do. We strive to build trusted, long-term partnerships to help our clients achieve their business objectives.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as any mental health or physical disability needs.

Job Description

The Asset and Wealth Management Risk Technology group works closely with quantitative specialists to produce refined data for global risk reporting groups to consume. The metrics that we produce are used by our portfolio management and risk management teams to track portfolio risk relative to benchmarks and external funds. Risk alerts on outsized risks and anomalies are raised by the system, after which they are reviewed and acted upon. Our system is used to monitor and report on risk both internally and to regulators. The information we produce is reviewed by the highest levels of management at the firm.

The Glasgow team is a new addition to the AWM Risk Technology and has a potential to become a hub for excellence so it is an exciting time to join. The team will be involved in developing and re-architecting legacy systems using cutting-edge technologies and driving the business into the Big Data era.

Primary responsibilities:

  • Developing clean, reusable, scalable and testable code
  • Actively participating in design sessions and owning modules throughout their lifecycle
  • Creating Automated Unit Tests using Flexible/Open Source Frameworks using a Test Driven Development approach
  • Digesting and understanding Business Requirements and designing new modules/functionality to meet those needs
  • Delivery of software on time and on budget, based on original scope & requirements
  • Work as a team to deliver value in a sustainable fashion
  • Pro-actively look to improve and innovate existing flows and processes
  • Participate in regular standups and code reviews
  • Provide proper technical documentation on code

Essential skills:

  • Strong database and PL/SQL programming experience. Preferably Oracle stored procedures and SQL knowledge.
  • Experience in resolving the data processing performance issues through improvements.
  • Manage end to end data collection and collaboration processes to meet SLAs.
  • Design, code, test and deliver software to automate manual operational work.
  • Troubleshooting of priority incidents, facilitate post-mortems and ensure permanent closure of the incidents.
  • Experience in projects with large data volumes.
  • Experience in Agile development lifecycle methodology.
  • Engage with development team throughout the life cycle to help develop software for reliability and scale, ensuring minimal refactoring or changes.
  • Strong attention to detail.
  • Strong analytical and problem solving skills
  • Innovative and team-player mindset.
  • Relevant university degree, specialized training or equivalent work experience
  • Working knowledge of Unix.
  • Knowledge of CI/CD and SDLC development tools such as Jenkins, Jira, Git/Stash etc

Beneficial skills:

  • Experience with Informatica
  • Experience with Java Microservices
  • Experience with AWS
  • Experience with Cloudera Hadoop, Spark, HDFS, HBase, Hive
  • Experience with Sybase, Greenplum
  • Experience with Maven or Gradle
  • Experience in No-SQL databases
You’ve got this!