Level 1
Job Description:
Experience: 1 to 3 years
Position Description:
* This is an application developer role in the team responsible for developing on the firm’s strategic data mart for OTC (Over the Counter) derivatives products. OTC derivative transaction and confirmation messages are fed into our data mart in real time and we provide data through a consolidated interface allowing our downstream systems to conveniently extract reports across multiple data marts.
* The candidate will be part of the team involved in building scalable and high-performance databases and components for regulatory, business analytics (metrics reporting), and operational risk reporting.
* The global team consists of highly technical team members who are adaptable to both hands-on development and project management.
* We deliver multiple projects for multiple business areas in parallel.
* The business owners and subject matter experts will be globally distributed, making communication and proactivity important. You will be expected to work closely with our operations partners on requirements for projects.
* The development will be performed using an agile methodology which is based on scrum (timeboxing, daily scrum meetings, retrospectives, etc.), Kanban Jira Boards, and XP (continuous integration, refactoring, unit testing, etc.) best practices.
* The candidate will be able to work collaboratively within a larger team.
Key Responsibilities:
* Design, build and enhance the SQL projection broker in DAL (data access layer) for all remaining OTC derivative assets with good performance and scalability.
* Design, build and enhance the real-time reporting infrastructure which captures the upstream messages, persists onto NFS storage, and shreds attributes into database tables for reporting purposes.
* Enhance and support multiple regulatory/business reports including Volcker, IMRS, etc., and act as a POC (Point of Contact).
* Translate business requirements into queries against a set of relational tables and produce reporting based on the requirements.
* Database and ETL development, including stored procedures, queries, performance tuning, etc., using SQL and ETL tools such as Informatica or Python Pandas.
* Create efficient testing automation for Java/Scala/Python processes.
Required Skills:
* Strong with Java / Scala
* Good understanding of SQL
The current global team members are all very skilled in domain modeling, database design, big data, Java, and messaging, so this is an excellent opportunity to play a key role in the growing team.
#J-18808-Ljbffr