Forward to a friend Tweet this Share this on Facebook Share:

Home | Job Postings


Position: Sustainability Analyst Trainee
Type: 3-month paid full-time position, possibility of extension
Organization: Corporate Knights
Location: downtown Toronto, Ontario (near Queen & Spadina)

Corporate Knights Analyst-Trainee Position Corporate Knights Inc. is seeking a finance and sustainability savvy excel wizard to join our research team. This person will work with the Director of Research to collect, manipulate and analyze large amounts of data to support the preparation of Corporate Knights’ ESG (environment, social and governance) research reports. This person will have significant opportunity to contribute to the CK Clean Revenue Project calculating the proportion of revenue earned from “clean” products and services. We are looking for someone energetic who likes to take initiative. There is a lot of room for growth and skills development in this role for those who are eager to learn.

Desired attributes and skills


  • Persistent
  • Detail oriented
  • Critical systems thinking
  • Big question-asker
  • Resourcefulness


  1. Ability to interpret income statements
  2. Ability to consistently refine and apply “clean” definition to revenue lines
  3. Advanced Excel capabilities (PERCENTRANK with multiple criteria, VLOOKUP, Fuzzy lookup, INDEX, MATCH, nested IF–AND-OR statements, ISBLANK, ISTEXT, ISNUMBER, COUNTIF(S), SUMIF(S), PIVOT, conditional formatting among others)
  4. Familiarity with data integrity problems such as leading or trailing spaces, metadata, hidden zeros and their impact on excel calculations. Ability thereof to solve such problems.
  5. Ensuring ongoing historical database completeness which requires among other things extracting data from multiple workbooks.
  6. Ability to extract data from various forms of documents – PDF, HTML into Excel format.


  1. Familiarity in navigating and extracting to Excel Bloomberg data – financial and ESG, as well as Thomson Reuters and FactSet is an advantage
  2. Navigating the internet, and especially corporate websites to find and verify items of data
  3. An understanding of financial statements, financial statement items, financial disclosure requirements and basic differences across several jurisdictions around the world, sustainability/ESG/CSR reports as well as the ESG disclosure environment and the various stakeholders is an advantage
  4. Resourcefulness: ability to search the internet to educate oneself on the above aspects.


  1. Ability to set up tests to verify the accuracy of formulas, of data manipulations and transformations – whether the intended results were generated, resolving any problem thereof.
  2. Managing time constraints: ability to come up with alternative solutions when faced with research time constraints.

This is a 3-month paid full-time position located in downtown Toronto, with the possibility of extension. The successful candidate will also receive reimbursement for transit pass and gym membership. For more information on our company, please visit and

We are looking to fill this position immediately. Please submit your resume to:
jobs mask*
(with your full name and “Analyst-Trainee” in the subject line) by January 22, 2018.

Only interview candidates will be contacted.

When applying, please indicate that you saw this posting at

*Email: The e-mail address above has been masked to prevent spam. Please copy the address or type it manually, add the @ sign, remove “mask” and any spaces.

Share this on Facebook   Tweet This!  Email this to a friend   Share this on LinkedIn   Add this to Google Bookmarks   Print this page

Note: This posting is provided on an "As Is" basis and for general informational purposes only. People and Planet (also known as "GoodWork") is not responsible for the content, accuracy, timeliness, completeness, legality, reliability, quality or suitability of this posting. We do not screen or endorse the organizations or individuals involved. If you decide to accept an offer of employment, volunteering or any other arrangement, you do so at your own risk and it is your responsibility to take all protective measures to guard against injury, abuse, non-payment or any other loss. Please read our full Terms & Conditions.

GoodWork ID: 43609       Date posted to Jan 12 2018