Job Opportunity
Team & Job Overview
As EDC aims to be the leader in helping all Canadian exporters go, grow and succeed internationally, the Business Performance Analytics team strives to maximize the performance of our sales teams by arming them with the skills, insights and tools they need to succeed. As part of the Business Enablement group, the Business Intelligence team is seeking an individual contributor to enhance the capacity of its sales analytics capacity and capability to allow business development teams to make faster, smarter and more well-informed decisions.
As an analyst, you will be responsible for building dashboards and providing in-depth reporting and analysis on business results that help to drive informed decision making. The candidate will have the ability to work on multiple projects simultaneously and translate business data into digestible information that provides insights and improves corporate processes. A strong communicator, they will not only have a natural curiosity to understand why things are happening but the ability to explain that to different audiences. The successful candidate should possess deep analytical skills, a results focused approach, while striving for quality improvement to impact business results and customer experience.
Discipline Summary
- Develop and maintain in depth reporting and analysis for the different lines of business across EDC
- Develops and enhances core team analytics, including reports, dashboards, and curated datasets
- Develop analytics, forecasting, and actionable data insights on Business Performance data
- Perform all aspects of the data lifecycle including consulting with business users to ensure articulation of business requirements, translating the requirements into viable solutions, building and testing of the developed solution and deployment to the necessary environments
Key Responsibilities
- Design and build dashboards that provide insights and drive decision making across the lines of business
- Determines the best source of information to suit users’ needs
- Perform data profiling and data mining activities based on business requirements
- Provides analysis of query/report output for clients and/or conducts statistical analyses, interprets results and writes reports to explain findings
Screening Criteria
- Undergraduate degree in relevant discipline
- Minimum 5 years of experience in business intelligence and reporting, or related experience
- Basic knowledge of business intelligence and reporting principles and practices
- Advanced Excel skills
- Advanced Power BI skills
- Strong communication, problem solving and collaboration skills
Assets
- Experience creating wireframes (using software such as Figma or Illustrator)
- Experience with advanced analytics, such as statistical modeling, forecast modeling, and machine learning
- Strong design skills
- Experience writing SQL queries (Microsoft SQL Server or Oracle)
- Experience using R and/or Python for analytics
- Experience with Data virtualization software, such as Denodo
- Bilingual in both official languages (French and English)
Interested? email: Richards@telfer.uottawa.ca