Software Engineer II – ETL / Data Engineer, CIB Securities Services – Agent Lending Analytics

JPMorgan Chase · Tokyo

Agent Lending Technology Analytics team have a requirement for a versatile, experienced software engineer with solid exposure in database technologies, ETL development, SQL, and Java. The individual will play a key part in the development of solutions within the Analytics space.

Job responsibilities

Liaise with Business Analysts, Product team and End Users for an understanding of the requirements.
Build robust, scalable applications that require participation in every facet of the SDLC.
Partner with global development teams and user base.
Ability to organize a development plan to meet agreed deadlines.
Produce code that conforms to controls standards, e.g. jobs should be re-runnable with minimal effort.
Develop diligently with a high regard for system reliability.
Enforce discipline across software development lifecycle including test-driven development. Contribute to continuous improvement.
Help support our environment and effective utilization of the platform. Ensure that systems run well in production, are highly available at disaster recovery and have sufficient capacity.

Required qualifications, capabilities, and skills

Solid experience as a database developer in large-scale Unix and Linux environments
Solid experience as an ETL developer with exposure to modern ETL and data integration tools
Experience developing or supporting Java-based applications/services
Expertise in database design, logical modelling and UNIX / LINUX operating systems
Expertise in PL/SQL, ANSI SQL or Transact-SQL, SQL queries
Data modelling experience (warehousing, marts, star schemas and relational)
Experience in database migration strategies and upgrades
Experience with traditional and modern Data Warehouse environments (Dimensional Modeling)
Exposure to database tuning techniques
Experience with performance analysis and monitoring tools
Exposure to capacity expansion and infrastructure scalability
Understanding of backup and recovery strategies
Experience with database administration, data migration, partitioning, materialized views and performance optimization techniques
Experience running and supporting large databases under high transaction rates
Ability to manage database maintenance activities including backups, indexing, integrity and consistency checks
Ability to analyze traces, build and debug stored procedures, triggers and packages
Understanding of Database Architecture, Operating Systems, Client/Server Architecture, Middleware and Hardware (Servers, SAN, Network).
Demonstrate good written and verbal communication skills
Ability to collaborate effectively with other operational support teams and vendors to support the service
Demonstrate ownership and strong problem management, problem solving and prevention of SLA breaches under Incident / Problem Management processes.
Experience with SDLC / Agile methodologies
Strong communication and interpersonal skills with an ability to work with a global team

Preferred qualifications, capabilities, and skills

Understanding of Securities Lending business / Financial Services domain
Experience in Python
Experience in Big Data technologies
Experience in a Business Intelligence tool (e.g. QlikView or Cognos)
Experience with Snowflake
Experience with cloud-based data platforms and modern analytics architectures
Operating Systems: Proficient in UNIX Solaris/Linux and Microsoft Windows
UNIX Shell Scripting

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. We also make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

Serve as an emerging member of an agile team to design and deliver market-leading technology products in a secure and scalable way

More jobs at JPMorgan Chase · Quant Development jobs in Tokyo, TO