Data Analyst Private Equity - HYBRID

NOTE: HYBRID work model, 2-days/week in office. Office located in Toronto.

Type: 6 Month Contract, 8 hours/day, 40 hours/week

Work Experience: Data Analyst, Complex Excel, Python, PowerBI, Dashboards, Statistics, CFA, Math, Private Equity

Industry: Capital Markets, Investments, Bank

DESCRIPTION:

Understand and extract relevant data from valuations Excel and pdf files (cash flows, macro drivers, terminal values and multiples, discount rates, equity beta, debt equity ratios, list of peers, peers multiples, etc.)

Research and propose portfolio and deal statistics and corresponding visuals use cases

Provide feedback on how the existing databases can accommodate adding new deals and whether anything else of relevance is available that was not already planned for

Run existing Python code to update data for internal dashboards

Build visuals in PowerBI dashboards

REQUIREMENTS:

A degree (bachelor or graduate) with at least one Corporate Finance course (CFA Level II or business exposure to privates’ valuation process are considered equivalent)

Ability to detect relevant deal information and ask for directions when the concepts used are not within a pre-defined list or in the initial mandate.

Previous experience with relational databases and unstructured data

Exposure to basic programming (any one of VBA, Python, R, JAVA, etc. or a course in Statistics, Logic or Set operations, are considered equivalent)

Ability to understand how data is aggregated at portfolio level as well as non-linear attribution of valuation changes

Detail-oriented, well organized and very good mathematical skills are a must

TO APPLY: