Regular Reporting Data Warehouse Developer

Our client is a UK subsidiary of a global financial house working in multiple markets and asset classes.

We are currently looking to expand our Kyiv team developing and supporting a variety of projects and services to a new area.

We have an exciting opportunity for a hybrid role to help maintain and shape the banks Regulatory Reporting platform, 2052A reporting.

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.

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 of working with a treasury department. 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.

Successful candidate will join a highly professional client team and will be likely required to travel to London for initial induction.

• Respond to day-to-day system related queries or issues from key system users including Regulatory Reporting team, Business Intelligence, Treasury or Technology
• Support Treasury team, with their day to day intraday liquidly reporting.
• Collaborate with end users and help with BAU of TRAM(Internal Treasury reporting app).
• 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 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)

• At least 2 years of experience with Oracle databases and be considered an expert in database development.
• Experience with regulatory Reporting.
• 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.
• Strong experience working with SSIS.
• Experience using C#.
• 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.
• 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 11g 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.

Would be advantageous working on scheduling software such as Control-M.

Have experience working on regulatory reporting platforms for an broker dealer, ideally with exposure to Regulatory Reporting such as Capital and/or Liquidity.

Be comfortable with on-call/out of hours support and have a flexible approach to working hours.