Snowflake Developer - 6 Months at Mars Capital

Dublin, Leinster, Ireland -

Full Time

Start Date

Immediate

Expiry Date

07 Oct, 26

Salary

0.0

Posted On

09 Jul, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Snowflake, SQL, Dimensional Data Modeling, ELT/ETL Pipelines, Cloud Data Architecture, Data Quality, Agile Methodology, Stakeholder Management, Power BI, Visual Basic, Microsoft Excel, Data Governance

Industry

Financial Services

Description

Company Description WELCOME TO MARS CAPITAL Mars Capital Finance Ireland DAC (“Mars Capital”) is part of Arrow Global Group Limited, which is one of Europe’s leading integrated asset managers with €112bn Assets Under Management (“AUM”) and 4,400 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 Working We’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 Values Our 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”) Commitment We’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 Description Role Overview We are seeking an experienced Snowflake Developer to join our Data & Analytics team. The successful candidate will design, develop, and optimise cloud-based data solutions using Snowflake, working closely with IT teams and business stakeholders to deliver scalable, secure, and high-performing data solutions. This role will help deliver a modern cloud-based data platform that supports regulatory reporting, portfolio analytics and operational decision-making. Key Responsibilities Design, develop and maintain data pipelines within the Snowflake platform. Migrate mortgage portfolio data from legacy platforms into Snowflake. Build scalable, secure and high-performing data models to support reporting and analytics. Develop ELT/ETL processes using modern cloud-based tooling. Ensure data quality, reconciliation and validation throughout the migration lifecycle. Optimise Snowflake performance, storage and compute usage. Collaborate with business analysts and reporting teams to translate business requirements into technical solutions. Support the delivery of regulatory, operational and management reporting. Implement data governance, security and best practices within Snowflake. Produce technical documentation, data dictionaries and deployment documentation. Participate in code reviews, testing and release activities. Work within Agile delivery teams to achieve programme milestones. Qualifications Required Skills & Experience Essential 5 years of proven commercial experience developing solutions using Snowflake. Strong SQL development skills with the ability to write complex, optimised queries. Experience designing dimensional data models and analytical data structures. Experience developing ELT/ETL pipelines. Strong understanding of cloud data architecture principles. Experience integrating data from multiple source systems. Knowledge of data quality, reconciliation and validation techniques. Experience working within Agile delivery environments. Excellent analytical and problem-solving skills. Strong communication and stakeholder management abilities. Desirable Experience within Financial Services, Banking or Mortgage servicing. Knowledge of mortgage servicing systems and mortgage portfolio data. Experience with Power BI or other enterprise reporting platforms. Understanding of data governance and regulatory reporting requirements. Visual Basic Skills. Strong knowledge of Microsoft Excel. Additional Information Central Bank of Ireland (“CBI”) Fitness & Probity Regime Some of our roles are Control Functions (“CF”) as defined by the Central Bank Reform Act 2010. 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

Responsibilities

Design, develop, and optimize cloud-based data solutions and pipelines within the Snowflake platform to support regulatory reporting and analytics. Migrate mortgage portfolio data from legacy systems while ensuring data quality and performance optimization.