We’re a national law firm with a local reach. Our philosophy is ‘we're legal and financial experts that care’ – something you’ll find in the way we work with our clients and how we support our teams. But we’re more than just a law firm – we’re a team of people working together to help individuals and businesses navigate life’s ups and downs. Working here you’ll feel a part of our friendly and inclusive environment.

We’ll value you for who you are and what you bring. We support each other and push boundaries to achieve incredible things and make a real difference to our clients and communities.

We're always looking to support our colleagues to work in a way that works best for them and everyone else, including our clients, the business and the regulators. Please speak to a member of our Recruitment and Onboarding team for more information.

As a Finance Systems Analyst, you will provide expert technical support for the organisation's Practice Management System, 3e.

This role focuses on leveraging in-depth knowledge of the database, SQL queries, OData, API querying, and XML generation to support projects and assist various departments in data extraction and ingestion. This role also ensures efficient, robust, and scalable financial processes through technical expertise and best practices.

• Act as a subject matter expert on financial systems, providing technical guidance and support to the Data department, CIO and Finance departments
• Provide expertise in SQL queries to support the Finance, CIO and Data departments in understanding and extracting/ ingesting relevant data from/ to the financial systems
• Utilise OData and API querying to integrate and retrieve data from systems, ensuring seamless data flow and system interoperability.
• Create and manage XML generation templates for bulk data uploads into the Finance Systems, ensuring accuracy and compliance with data standards
• Collaborate with project teams to provide technical expertise on database structure and data extraction/ ingestion methods.
• Develop and maintain PowerApps solutions to enhance system functionality and user experience
• Implement and maintain robust data governance practices to ensure data quality, security, and compliance
• Develop and maintain comprehensive technical documentation for financial systems data models and processes
• Identify and implement technical improvements to enhance system performance and efficiency
• Manage and maintain system printer templates for document generation, using Crystal Reports and/ or 3e Templates, ensuring the templates are accurate, efficient, and meet business requirements
• Facilitate the understanding of finance operational processes and data extraction/reporting requirements, ensuring seamless communication and collaboration between finance and technical teams

• Advanced knowledge of SQL, OData, API querying, and XML schema requirements
• Advanced knowledge of Microsoft Excel
• Strong understanding of data governance and data protection principles
• Experience with system integrations and technical troubleshooting
• Excellent technical problem-solving skills
• Strong analytical and data management skills
• Ability to communicate technical information effectively to non-technical stakeholders

• 25 days holidays as standard plus bank holidays - You can ‘buy’ up to 35hrs of extra holiday too.
• Generous and flexible pension schemes.
• Volunteering days – Two days of volunteering every year for a cause of your choice (fully paid)
• Westfield Health membership, offering refunds on medical services alongside our Aviva Digital GP services.

We also offer a wide range of well-being initiatives to encourage positive mental health both in and out of the workplace and to make sure you’re fully supported.  This includes our Flexible by Choice programme which gives our colleagues more choice over a hybrid way of working subject to role, team and client requirements.

We have been ranked in the Best Workplaces for Wellbeing for Large Organisations for 2024!

Our responsible business programmes are fundamental to who we are and our purpose. We’re committed to being a diverse and inclusive workplace where our colleagues can flourish, and we have established a number of inclusion network groups across our business to support this aim. 

Our commitment to Social Responsibility, community investment activity and tackling climate change is a fundamental part of who we are. It’s made up of four strands: Our People, Our Community, Our Environment and Our Pro Bono.

As part of the Irwin Mitchell Group’s on-boarding process all successful applicants are required to complete the group’s employment screening process. This process helps to ensure that all new employees meet our standards in relation to honesty and integrity therefore protecting the interests of the Group, colleagues, clients, partners and other stakeholders.

We carry out pre employment screening to establish your eligibility to work in the UK, criminal record and financial checks ­with our trusted 3rd parties.

The employment screening process will fully comply with Data Protection and other applicable laws.

Irwin Mitchell LLP is an equal opportunity employer.