About the opportunity
Financial Systems Team is looking for a Finance Systems & Integrations Analyst to support operations in Europe. The key responsibilities for this role are to maintain and develop integrations between systems as well as troubleshoot and improve performance of finance systems.
He or she will work closely with IT and Finance Teams all over the Europe. The individual is also expected to contribute to our global projects in the cloud (Azure) and On Premise environment.
About the role
Manage and resolve queries and issues at all levels.
Effectively use other Microsoft SQL Server Solutions (MSSQL Studio, Visual Studio)
Maintain and improve MS SQL databases (creating and modifying tables, views, stored procedures).
Build and understand complex T-SQL queries for reporting purposes.
Support and improve existing integrations between different systems.
SQL Jobs maintenance and proactive troubleshooting (updating existing jobs and creating new ones).
Analyse user issues and create solutions that effectively meet these needs.
Work closely with DBA’s, software developers and finance teams.
Assist in troubleshooting performance issues on the database such as slow running queries.
Cooperate proactively with business end users and clearly document their requirements.
Communicate progress and deliver results in a timely manner.
Ensure data accuracy and credibility (in terms of integrity, simplicity and performance
Technical Skills Required
Strong proficiency with T-SQL language and its variation among relational databases (RDBMS).
Strong understanding of data analysis and process modelling.
Performance tuning experience related to reporting queries
Experience with MS SQL Management Studio and SQL Server Reporting Services.
Proven experience :
as a support of business / financial systems
in the field of integrations
Strong overall IT skills including data manipulation and management.
A good understanding of finance and accounting department needs within a legal environment.
Excellent communication skills, both written and oral; in particular, ability to communicate clearly and effectively with people for whom English is not their native language.
Objective focused with a tenacious appetite to provide the highest level of service.
Able to demonstrate excellent customer / client facing skills.
Strong organizational and time management skills.
Ability to build internal and external relationships.
Beneficial experience :
SQL Server Integration Services
Financial background (understanding of cash collection, time recording and billing processes)
Microsoft Power BI and other BI visualization tools
Data Warehouse and OLAP cubes
What we can offer
Dentons is always looking to invest in the highest-quality talent, recognizing that our success is built on the diverse and unique strengths of each of the members of our Firm.
Our team of business services professionals play a significant role in the success of Dentons, and we recruit Talent into a wide variety of areas.
Here, we look for focused, flexible individuals from a variety of backgrounds who are team players. Previous experience within the legal sector is not essential.
We want to give everyone the opportunity to develop his or her potential fully and, therefore, provide support, training and encouragement to members of teams at all levels.