Sign in
Employer registration
Login
Employer registration
Login
Forgot password
Forgot password
Sign in
Sign in
Employer registration
Find Meaningful Work

Analyst - Trainee job in Toronto

Corporate Knights jobs
Ontario, Toronto
Company Type:  Certified B Corporation
Industry:  Printing & Publishing
Job Type:  Finance & Accounting
Employment:  Contract
Impact Area:  Knowledge & Information
Company Name:  Corporate Knights

Location
Country:  United States
State / Province:  Ontario
City:  Toronto
Zip / Postal Code:  M5V 2L7
Map: 

Description

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


Attributes:
1. Persistent
2. Detail oriented
3. Critical systems thinking
4. Big question-asker
5. Resourcefulness


Skills
1. Ability to interpret income statements
2. Ability to consistently refine and apply “clean” definition to revenue lines
1. 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)
2. 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.
3. Ensuring ongoing historical database completeness which requires among other things extracting data from multiple workbooks.
4. Ability to extract data from various forms of documents – PDF, HTML into Excel format.


Research
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.


Self-check
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 www.corporateknights.com and www.cleancapitalism.com. We are looking to fill this position immediately. Please submit your resume via this site (with your full name and “Analyst-Trainee” in the subject line) by January 15, 2018. Only interview candidates will be contacted.

ref: (25809)
Back to search results