EXHIBIT 5.2

27 September 2010

Dear Sirs

Alterra Capital Holdings Limited (the “Company”)

We have acted as special Bermuda legal counsel to Alterra Capital Holdings Limited in connection with a registration statement on Form S-3, as amended (File No. 333-167035) filed with the U.S. Securities and Exchange Commission (the “Commission”) on 24 May 2010 (the “Registration Statement”, which term does not include any other document or agreement whether or not specifically referred to therein or attached as an exhibit or schedule thereto) under the U.S. Securities Act of 1933, as amended, (the “Securities Act”) relating to the guarantee by the Company of certain debt securities of Alterra Finance LLC, a Delaware limited liability company (“Alterra Finance”) and a wholly-owned subsidiary of the Company (the “Securities”). The Securities being issued and sold from time to time as set forth in the Registration Statement and pursuant to the Securities Act, being $350 million aggregate principal amount of Alterra Finance’s 6.25% Senior Notes due 2020 (the “Notes”), fully and unconditionally guaranteed by the Company, are being offered and sold pursuant to the Prospectus dated 21 May 2010 as supplemented by the Prospectus Supplement dated 22 September 2010 (together, the “Prospectus”), filed by the Company and Alterra Finance with the Commission under the Securities Act and pursuant to an underwriting agreement dated 22 September 2010 among, inter alia, the Company, Alterra Finance and the several underwriters named therein.

The Notes are being issued under the indenture dated as of 1 September 2010, as amended (the “Base Indenture”), between the Company, as guarantor, Alterra Finance, as issuer and The Bank of New York Mellon Trust Company, N.A., as trustee (the “Trustee”), as supplemented by the First Supplemental Indenture, dated 27 September 2010 (the “First Supplemental Indenture” together with the Base Indenture, the “Indenture”), among the Company, Alterra Finance and the Trustee.

For the purposes of giving this opinion, we have examined the following documents:

The document listed in item (iv) above herein is sometimes referred to as the “Document” (which term does not include any other instrument or agreement whether or not specifically referenced to therein or attached as an exhibit or schedule thereto).

We have also reviewed the memorandum of association and the bye-laws of the Company, each certified by the Assistant Secretary of the Company on 27 September 2010, a copy of an extract of unanimous written resolutions of the directors of the Company (the “Board”) dated 20 May 2010 certified by the Assistant Secretary of the Company on 27 September 2010 (the “Minutes”), and such other documents and made such enquiries as to questions of law as we have deemed necessary in order to render the opinion set forth below.

We have assumed (a) the genuineness and authenticity of all signatures and the conformity to the originals of all copies (whether or not certified) examined by us and the authenticity and completeness of the originals from which such copies were taken; (b) that where a document has been examined by us in draft form, it will be or has been executed in the form of that draft, and where a number of drafts of a document have been examined by us all changes thereto have been marked or otherwise drawn to our attention; (c) the capacity, power and authority of each of the parties to the Document, other than the Company, to enter into and perform its respective obligations under the Document; (d) the due execution and delivery of the Document by each of the parties thereto, other than the Company, and the physical delivery thereof by the Company with an intention to be bound thereby; (e) the accuracy and completeness of all factual representations made in the Document, the Registration Statement, the Prospectus and other documents reviewed by us; (f) that the resolutions contained in the Minutes were passed at one or more duly convened, constituted and quorate meetings or by unanimous written resolutions, remain in full force and effect and have not been rescinded or amended or supplemented ; (g) that at all material times the Company is and will be solvent and will be able to pay its

-2-

liabilities as they become due and where any act is required to be performed by the Company under the Document, it will be preformed in accordance with applicable Bermuda law; (h) that there is no provision of the law of any jurisdiction, other than Bermuda, which would have any implication in relation to the opinions expressed herein; (i) the validity and binding effect under the laws of the State of New York (the “Foreign Laws”) of the Document in accordance with its terms; (j) the validity and binding effect under the Foreign Laws of the submission by the Company pursuant to the Document to the non-exclusive jurisdiction of any United States Federal or New York State court sitting in the Borough of Manhattan, The City of New York, New York (the “Foreign Courts”), the waiver of any objection related to inconvenient forum and the appointment of an agent for service of process; (k) that none of the parties to the Document has carried on or will carry on activities, other than the performance of its respective obligations under the Document, which would constitute the carrying on of investment business in or from Bermuda; (l) that none of the parties to the Document, other than the Company, will perform its obligations under the Document, in or from Bermuda; and (m) that on the date of entering into the Document the Company is and after entering into the Document will be able to pay its liabilities as they become due.

The obligations of the Company under the Document (a) will be subject to the laws from time to time in effect relating to bankruptcy, insolvency, liquidation, possessory liens, rights of set off, reorganisation, amalgamation, moratorium or any other laws or legal procedures, whether of a similar nature or otherwise, generally affecting the rights of creditors; (b) will be subject to statutory limitation of the time within which proceedings may be brought; (c) will be subject to general principles of equity and, as such, specific performance and injunctive relief, being equitable remedies, may not be available; (d) may not be given effect to by a Bermuda court, whether or not it was applying the Foreign Laws, if and to the extent they constitute the payment of an amount which is in the nature of a penalty and not in the nature of liquidated damages; (e) may not be given effect by a Bermuda court to the extent that they are to be performed in a jurisdiction outside Bermuda and such performance would be illegal under the laws of that jurisdiction. Notwithstanding any contractual submission to the jurisdiction of specific courts, a Bermuda court has inherent discretion to stay or allow proceedings in the Bermuda courts.

We express no opinion as to the enforceability of any provision of the Document which provides for the payment of a specified rate of interest on the amount of a judgment after the date of judgment or which purports to fetter the statutory powers of the Company.

We have made no investigation of and express no opinion in relation to the laws of any jurisdiction other than Bermuda. This opinion is to be governed by and construed in accordance with the laws of Bermuda and is limited to and is given on the basis of the current law and practice in Bermuda. This opinion is issued solely for your benefit and is not to be relied upon by any other person, firm or entity or in respect of any other matter.

-3-

On the basis of and subject to the foregoing, we are of the opinion that:

We hereby consent to the filing of this opinion as an exhibit to the Company’s Current Report on Form 8-K filed on 27 September 2010 and to the references to our firm under the caption, “Legal Matters” in the Prospectus forming part of the Registration Statement. In giving this consent, we do not hereby admit that we are experts within the meaning of Section 11 of the Securities Act or that we are in the categories of persons whose consent is required under Section 7 of the Securities Act or the Rules and Regulations of the Commission promulgated thereunder.

Yours faithfully

/s/ Conyers Dill & Pearman Limited

Conyers Dill & Pearman Limited

-4-