SPV Reporting Analyst

Job title:

SPV Reporting Analyst

Company

Mars Capital

Job description

Company DescriptionWELCOME TO MARS CAPITALMars Capital Finance Ireland DAC (“Mars Capital”) is part of Arrow Global Group Limited, which is one of Europe’s leading integrated asset managers with €70bn Assets Under Management (“AUM”) and 2,000 employees across five jurisdictions.Mars Capital was established in 2015 and is a Regulated Credit Servicing Firm, authorised by the by the Central Bank of Ireland and located in Dublin 2. Mars Capital has the capacity and regulatory authority to service loans secured against properties and has €8bn AUM, experiencing significant growth in recent years. We provide services that span the full lifecycle of a loan post origination, from drawdown through to loan administration, asset management, enforcement as well as syndication, securitisation, and standby servicing.We value our relationship with our clients and believe that our deployment of dedicated, Dublin-based project and asset management teams give us a competitive advantage over other competitors who operate a shared services model across their portfolios. Placing the customer first in a simple and efficient manner in line with our regulatory obligation is our number one priority.Our local strategic ambition is to provide value accretive services to institutional clients, while building better financial futures for our customers, clients, communities and colleagues.Our Culture and Way of WorkingWe’re entrepreneurial, fast-paced and decisive, working together safely and supportively. We trust our colleagues to make the right decisions and are brave enough to acknowledge mistakes and to learn from them. Celebrating success, we reward those who help us to achieve exceptional long-term results.We’re inclusive and encourage our colleagues to be themselves. Our culture supports the difference that makes each of us unique. We’re open and eager to embrace new ways of working and have a diverse community, enriched by our local identities that works collaboratively to build a unified and dynamic organisation.We believe that a supported flexible working approach helps us to retain valued colleagues, enhance wellbeing, increase motivation and encourage a healthy work/life balance. If you’re interviewed, ask about the flexibility involved in this role.Our ValuesOur stakeholders expect us to act in an ethical and responsible way and this is at the heart of how we conduct our business. Our values support this philosophy, and we seek out and reward behaviours that will make us more sustainable, responsible and successful. Our values are- we succeed together; we do the right thing; we’re trusted and valued; and we’re brave and creative. You’ll hear more about these throughout the interview process.Our STAR Awards provide a fantastic platform to send a special thank you to a colleague who may have gone above and beyond to help you and the business succeed, or someone who has been brave and creative with their own approach to how they work. Values orientated, our Recognition Scheme plays a pivotal role in aligning and celebrating our culture, and simply wouldn’t exist without colleague participation and input.Our Environmental, Social and Governance (“ESG”) CommitmentWe’re committed to investing responsibly and supporting our local communities and charitable organisations. Every colleague is encouraged to take a paid day each calendar year to volunteer for our nominated charities. Internally we are very proud of our four colleague-led engagement groups, who run events/initiatives, that promote our culture and values which is a key part of the life blood of this business.Job DescriptionWe are currently recruiting four Reporting Analysts to join our business as it goes through a vast period of growth. The roles will involve producing and implementing data management, data quality, control and data standards across the function. Supporting both our internal colleagues and external client requirements.This role will be based at either our Dublin or Manchester office with some home working.What will you be doing?

• Prepare and validate weekly and monthly reporting deliverables using existing SQL queries
• Work through the requirements with the stakeholders to maintain the structure and integrity of the reports
• Build checks required across different data sources to ensure consistency and completeness
• Work with Data Integrity team and wider business to promote data quality and usability
• Consult, influence and build relationships with all key internal and external contacts
• Ad hoc analysis and reporting on the investment level including requests from the business and client
• Gain understanding of the portfolios and underlying assets
• Assist the development and implementation of effective and consistent systems, as required

Qualifications

• Extensive knowledge of data quality issues, data transformations. Best practice in data manipulation and cleansing
• Extensive SQL essential experience
• Excellent understanding of working in an Asset Management or financial services business and interpreting data
• Strong analytical skills and numeracy, with high levels of accuracy
• Ability to understand complex data and present it in a clear and understandable way
• Able to manage and organise large volumes of information
• Ability to link different data sources and come up with an overall/overarching story
• Proven ability to mine and manage large populations of data from multiple and diverse systems
• Able to plan all action steps to conclude assignments on time
• Structured approach to problem solving
• Strong critical thinking skills, intuitively curious and an ability to diagnose data issues
• Advanced MS Excel skills (Power Pivot, Power Query, VBA)
• Automation knowledge is desirable
• Experience with data visualisation / reporting tools (Tableau, Power BI, etc)
• Experience of dealing with senior management and stakeholders
• Experience of working in a fast paced, changeable environment

Additional InformationCentral Bank of Ireland (“CBI”) Fitness & Probity RegimeSome of our roles are Control Functions (“CF”) as defined by the . If a vacancy is for a CF role, it will be indicated above. For CF roles, appointment will be conditional on Mars Capital being fully satisfied that the appointee meets the requirements as set out in the Fitness and Probity Standards 2018 issued by the Central Bank of Ireland. In the case of proposed appointees to Pre-Approval Control Functions, this includes prior approval by the CBI of such appointments.D&I statement

Expected salary

Location

Dublin

Job date

Wed, 13 Nov 2024 23:50:03 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.net) you saw this job posting.