Data Warehouse Developer

New York, NY

Posted: 06/14/2019 Industry: IT Consulting Job Number: 12314675
Main purpose of the role:

We have an exciting opportunity for a hybrid role within the Technology department to help maintain and shape the banks Regulatory Reporting platform, Moody's Risk Authority.
This role requires a skilled support analyst / Developer who can undertake day-to-day support and technical development activities on an Oracle 12c database servicing a number of regulatory reporting regimes including RWA and JFSA using Moodys RAY.
The candidate will work closely with various development teams and Business managers to further enhance the data warehouse and reporting elements of the platform. Strong core TSQL/PSQL skills are essential along with a solid understanding of data warehousing design principles.
The role would suit a candidate with at least 5 years' experience of working within a PLSQL and 1-2 years using and loading Moody's Risk Authority. Previous experience working within Risk, Finance or Product Control areas is desirable although a strong track record of comparable experience on large scale Regulatory Reporting platform implementations is also acceptable.

Key Responsibilities:
  • Respond to day-to-day system related queries or issues from key system users including Regulatory Reporting team, Business Intelligence, Treasury or Technology
  • Build and upgrade the Moodys RAY environments to 6.1.
  • Collaborate with end users and help with BAU of Moody's Risk Authority.
  • Define solutions paying particular attention to ensuring technical requirements have been factored in
  • Develop efficient ETL routines using advanced Oracle database technologies such as PL/SQL external tables
  • Aggregate large datasets [< 10m] into views or materialized views
  • Work on the regulatory reporting application (Moody's Risk Authority) and use application functionality to help deliver extensions and enhancements
  • Work with the overnight batch processes using schedule software, Control-M
  • Work with wider Technology teams to ensure development and testing is coordinated and best practices are followed
  • Help define test cases and work closely with users assisting them with testing bug fixes or new features and functions
  • Report to the Technology team lead and keep management abreast of status and progress on in-flight issues
  • Ensure due diligence has been carried out on all software changes, paying particular attention to detail on unit, component and systems integration testing
  • Package up artifacts using industry standard tools such as Subversion, SDA & TeamCity
  • Work with BAU teams to ensure project changes are released to live in a co-ordinated manner Design and develop warehouse enhancements
  • Load and validate dimensions and measures stored procedures
  • Perform all application unit and system testing
  • Support the loading and integrity of the data warehouse.
  • Create data dictionary's and proper documentation on the data warehouse (Oracle DB)
Skills and Experience:
  • Worked with Oracle databases and be considered an expert in database development
  • Experience with regulatory Reporting application software Moody's Risk Authority (RAY)
  • Have an exceptionally strong understanding of PL/SQL and be comfortable with performance tuning and working with large datasets efficiently
  • Have experience working on regulatory reporting platforms for an broker dealer, ideally with exposure to Regulatory Reporting such as Capital and/or Liquidity
  • Strong experience working with interfaces and have a good appreciation of ETL techniques and reporting technologies
  • Have worked in a fast paced BAU environment and appreciate deadlines the regulatory reporting teams are working towards
  • Pay great attention to detail and be client driven with a focus on delivery and milestones
  • Have exceptional communication skills, being able to converse with a wide variety of stakeholders including department heads
  • Would be advantageous working on scheduling software such as Control-M
  • Be flexible, particularly when working on rolling out system changes in non-business hours
  • Have experience working on documenting testing and be au-fait with the various types of technology testing which needs to be undertaken to ensure deliverables are fit for purpose
  • Provide post live production support Solid Oracle Development skills with 12g or later
  • Data Warehousing Design Experience and Kimball Methodologies
  • Understating of the data governance life cycle
  • The ability to understand financial products and how they are reported on by Risk, Product Control and Finance departments within an investment bank

    Preference will be given to candidates with experience in the following:
  • Have experience working on regulatory reporting platforms for an broker dealer, ideally with exposure to Regulatory Reporting such as Capital and/or Liquidity
  • Has worked with RWA and SCCL reporting.

Personal Requirements:
  • Have a " can do " attitude with flexibility to adapt.
  • Good communication skills, and the ability to simplify technical jargon into business speech
  • Agile and flexible approach to delivery.
  • Excellent interpersonal skills to ensure clarity of communication to users and Technology colleagues.
  • Prioritise and structure own workload according to delivery requirements.
  • A fast learner with the ability to understand, retain and apply new information quickly.
  • Be comfortable with on-call/out of hours support and have a flexible approach to working hours

Seth Friedland

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.