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

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