Our client is a US subsidiary of a global financial house working in multiple markets and asset classes.
We are currently looking 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 of SSIS pipelines used on top of 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 PL/SQL and T-SQL and skills are essential along with a solid understanding of data warehousing design principles.
Successful candidate will join a highly professional Luxoft team of 6 people helping to develop and support a range of client applications.
The team currently operates in WFH mode, working from the office is possible upon request.
MS SQLPL/SQLSQL
- 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 internal Treasury reporting app.
- Define solutions paying particular attention to ensuring technical requirements have been factored in.
- Develop efficient ETL routines using Oracle database technologies
- 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).
MUST
- At least 4 years experience with Oracle PL/SQL, expert query writing skills
- At least 1 years experience with MS SQL (T-SQL)
- At least 1 years experience with SSIS
- Experience with regulatory reporting.
Control-M experience is a plus
Exposure to Regulatory Reporting such as Capital and/or Liquidity is a plus
Ability to understand financial products and how they are reported on by Risk, Product Control and Finance departments within an investment bank is a big plus
Luxoft Poland
2500
Luxoft, a DXC Technology Company, is a global digital strategy and software engineering firm with about 18,000 international employees within its 44 offices in 21 countries. It is headquartered in Zug, Switzerland.
In January 2019, Luxoft was acquired by U.S. company DXC Technology. Luxoft partnered with LG Electronics to create a next-generation Autonomous Mobility concept vehicle that integrates consumers' personalized digital lifestyles into a driving experience. Luxoft enabled Switzerland's first Blockchain based e-vote platform with the City of Zug and Hochschule Luzern's Blockchain Lab.
Luxoft, a DXC Technology Company is a world-renowned company. It has been present on the Polish market for over 11 years. We have offices in Krakow, Warsaw, Wroclaw, and Tri-City. We employ almost 2,500 experienced experts carrying out projects for over 40 clients from the financial, automotive, medical, tourist industries, etc. We work for many international clients, including the USA, Great Britain, and Switzerland.
So far, Luxoft Poland has made a name for itself as a company that offers work on innovative projects, we offer various experiences in the field of IT, opportunities for rapid development, an extensive training program, and attractive benefits for employees.
At present, 62% of Luxoft Poland employees come from Poland, and 38% from around 50 countries, including Ukraine, Brazil, India, Turkey, Spain, Portugal, Italy, Romania, USA, etc.
At Luxoft, a DXC Technology Company, as much as 85 percent of employees are experts with the "Senior" experience level, with at least five years of experience. We care about our employees, so every day we try to provide them with the best possible conditions for work and development.
Technology is our passion! We focus on top engineering talent means that you will be working with the best industry professionals from around the world. Because of that, Luxoft is a global family with an epic atmosphere – we love what we do!