Description
At EXP, we’re driven to provide innovative solutions for the world’s built and natural environments. As a team of engineers, architects, designers, scientists, creators and a community of professionals, we bring diverse and talented people together to solve the world’s most complex challenges. Here, you join a team that leverages differences, harnesses their entrepreneurial spirit in an employee-owned company, that believes diversity is what gives us strength, seeks sustainable results and shares ambitions for each other, our clients and the communities we are part of and serve. To be a part of EXP means to have your own experience, while staying connected to a global network of professionals, who believe we are a part of something bigger. Together, we are EXP.
Junior Performance Analyst
**Ottawa, Ontario
Are you ready to design your future?
Be our next Junior Performance Analyst!
**Your work environment at EXP
In this role, you will be a part of the *Major Projects *team, based in *Ottawa, ON *office.
What a day at EXP has in store for you
- Support Major Projects in data collection, management, and analysis
- Meticulous attention to detail, identifying inconsistent data, and resolving errors
- Frequent communication with Design Leads in collecting and confirming their data
- Maintaining normalized data sets standardized and organized
- Generating analysis of data sets in Excel which are presented in a clear and consistent format
What your experience looks like
- 2-3 years’ experience using Excel, including functional knowledge of the following:
- Ability to transform data in Pivot Tables
- Functions (e.g. AND, DATEDIF, SUMIFs, IF, IFERROR, INDEX, MATCH)
- Familiar with Dynamic Arrays (e.g., FILTER, SORT, UNIQUE, XLOOKUP)
- Adept user of Microsoft Office Suit (Word, PowerPoint, Outlook)
- Experience in data visualization (Power BI) is an asset
- Experience working within and supporting a team
- Analytical and pragmatic approach to information
- Previous corporate / office experience
- Excellent communication skills (verbal and written)
- Willing to learn new skills and enhance technical knowledge in data analysis
- Excellent analytical, judgment and problem-solving capabilities
- High initiative, great interpersonal skills, and the ability to work with mínimal supervision
- Creative mind and collaborative spirit
- Desire to grow within the role