Analyst, Business Intelligence

2 weeks ago


Ottawa, Canada EDC Full time

**Analyst, Business Intelligence** - 00045P

**Posting Date**: Feb 7, 2023, 8:24:40 AM

**Primary Location**: Ontario-Ottawa

**Job Type**: Permanent

**Schedule**: Full-time

EDC is Canada’s export credit agency, offering information, knowledge and innovative commercial solutions to help Canadian exporters and investors expand their international business. We take on risk so Canadian businesses can take on the world.

When you join our team, you’ll be helping Canadian companies bring their vision, passion and innovation to the global marketplace. Your knowledge and expertise will support more than 25,000 Canadian companies and their customers in as many as 200 markets worldwide. You’ll work shoulder-to-shoulder with the best and brightest in an inclusive, collaborative environment that fosters professional development and success. And you’ll know that you’re making a difference every day—for companies, for Canada and for the people you work with.

Year after year, EDC has been recognized as a Top 100 and Top Family-Friendly Employer. #LI-Hybrid

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

**Discipline Summary**
- Perform all aspects of the data lifecycle including consulting with business users to ensure articulation of business requirements, translating the requirements into viable solutions, testing of the developed solution and deployment to the necessary environments.
- Determines the best source of information to suit the users’ needs.
- Ensures the functionality, security, availability, and accuracy of the information provided to end users of data.
- Develop and maintain in depth reporting and analysis for the lines of business
- Work across functions to develop relevant metrics and reporting to support decision making process.

**Key Responsibilities**
- Determines the best source of information to suit the users’ needs and develops queries and reports
- Provides analysis of query/report output for clients and/or conducts statistical analyses, interprets results, and writes reports to explain findings
- Represents the client and their needs when dealing with data platform issues and helps to evaluate, select, test, and optimize both hardware and software products
- Identifies data integrity issues and determine feasible solutions and maintains documentation, templates, procedures, processes, building codes, and standards relating to data
- Performs all aspects of the data lifecycle management including consulting with business users to articulate requirements, translating the requirements into viable solutions, testing and deployment of solutions

**Screening Criteria**
- Undergraduate degree in business administration, computer science, management information systems or related discipline
- Minimum 2 years of experience in business intelligence and reporting, or related experience
- Basic knowledge of business intelligence and reporting principles and practices
- Advanced data analysis skills
- Knowledge of Data Transformation tools
- Experience using Business Intelligence tools (Power BI, Cognos Analytics, or Tableau)

**Assets**
- Experience writing SQL queries (Microsoft SQL Server or Oracle)
- Experience using R and/or Python
- Experience with Data virtualization software, such as Denodo
- Experience with Data Transformation tools, such as Databricks or DataStage
- Experience with SAS Enterprise Guide
- Bilingual in both official languages (French and English)

**Salary Ranges**
- $56,100 - $84,300 + performance-based incentive

**Location**
- Please be advised that this position is based at our Head Office in Ottawa or could be performed remotely at any city within Canada.

**How to apply



  • Ottawa, Canada Canadian Security Intelligence Service Full time

    **Important**: **Closing Date** 2023-06-30 **Reference Number** 23-968-08-081 **Job Category** Experienced **Who Can Apply** Canadian Citizens **Location** Ottawa, Ontario **Salary Range** $84,050 - $102,250 **Status** Indeterminate (permanent) **Language Requirement** Bilingual Non-Imperative (CBC/CBC) **Job Summary**: The Intelligence Analyst...

  • Business Analyst

    3 weeks ago


    Ottawa, ON, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategies Our client has a requirement for the...

  • Business Analyst

    7 days ago


    Ottawa, Canada Canada Foundation for Innovation Full time

    With a bold, future-looking mandate, the Canada Foundation for Innovation equips researchers to _ - be global leaders in their field and to respond to emerging challenges. Our investments in state -of-_ - the-art tools, instruments and facilities underpin both curiosity - and mission-driven research that _ - cuts across disciplines and bridges all sectors....


  • Ottawa, Canada Maplesoft Group Full time

    Maplesoft Group is currently seeking a Business Systems Analyst for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Under the direction of the Senior Manager, Business Analysis Payments Modernization: - Participate in a Data as a Product scrum team to gather and convert...


  • Ottawa, Canada Home and Community Care Support Services Full time

    Position Summary: The Business Intelligence Partner is responsible for obtaining, summarizing, analyzing, interpreting, and presenting organizational, program and patient data to support strategic objectives and facilitate efficient and effective service operations across the organization. To support this work, the Business Intelligence Partner...

  • Front Line Analyst

    3 days ago


    Ottawa, Canada Canadian Security Intelligence Service Full time

    **Important**: **Closing Date** 2024-02-22 **Reference Number** 23- 968-05-141 **Job Category** Entry Level **Who Can Apply** Canadian Citizens **Location** Ottawa, Ontario **Salary Range** $57,960 - $70,500 **Status** Indeterminate (permanent) **Language Requirement** Bilingual Non Imperative - BBB **Job Summary**: **Front Line Analyst**: - Review...


  • Ottawa, Canada Myticas Consulting Full time

    Myticas Consulting's Ottawa-based client is looking for a Business System Analyst for a 3 year HYBRID contract. This requirement requires the resource to have a valid **Secret Level Security Clearance.** **Under the direction of the Senior Manager, Business Analysis Payments Modernization**: - Participate in a Data as a Product scrum team to gather and...


  • Ottawa, Canada Microsoft Full time

    Security represents the most critical priorities for our customers in a world awash in digital threats, regulatory scrutiny, and estate complexity. Microsoft Security aspires to make the world a safer place for all. We want to reshape security and empower every user, customer, and developer with a security cloud that protects them with end to end, simplified...


  • Ottawa, Canada Canadian Air Transport Security Authority Full time

    The Canadian Air Transport Security Authority (CATSA) has 2 exciting student opportunity from May 6th, 2024 to August 23rd, 2024 within the Technology branch at CATSA Headquarters. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference...


  • Ottawa, Canada Canadian Air Transport Security Authority Full time

    The Canadian Air Transport Security Authority (CATSA) has 1 exciting student opportunity from January 9th, 2023 to April 14th, 2023 within the Technology branch at CATSA. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference and...


  • Ottawa, Canada N12 Consulting Full time

    N12 Consulting is a leading Enterprise Performance Management (EPM) firm in Ottawa, with a team of experienced consultants who specialize in unifying Performance Management and Business Intelligence (BI). We accomplish this bysupporting a broad range of strategic, financial and operational management processes to provide a complete and integrated system...


  • Ottawa, Ontario, Canada Microsoft Canada Full time

    OverviewSecurity represents the most critical priorities for our customers in a world awash in digital threats, regulatory scrutiny, and estate complexity. Microsoft Security aspires to make the world a safer place for all. We want to reshape security and empower every user, customer, and developer with a security cloud that protects them with end to end,...


  • Ottawa, Canada Bank of Canada Full time

    **Business Support Analyst** **Take a central role** The Bank of Canada has a vision to be “a leading central bank—dynamic, engaged and trusted—committed to a better Canada.” No other employer in the country offers you the unique opportunity to work at the very center of Canada’s economy, in a diverse and inclusive organization with significant...


  • Ottawa, Ontario, Canada Microsoft Canada Full time

    OverviewSecurity represents the most critical priorities for our customers in a world awash in digital threats, regulatory scrutiny, and estate complexity. Microsoft Security aspires to make the world a safer place for all. We want to reshape security and empower every user, customer, and developer with a security cloud that protects them with end to end,...


  • Ottawa, Canada Canada Mortgage and Housing Corporation Full time

    Job Requisition ID: 10128 Position Status: Permanent Full Time Position Type: Hybrid Office Location: Ottawa (ON); Toronto (ON) Travel Requirement: Travel not required Language Designation: English Essential Language Skill Levels (Read/Write/Speak): ZZZ Salary: Our salaries generally range from $ 83038.35 to $ 103797.93 and are based on qualifications...


  • Ottawa, Canada Canada Mortgage and Housing Corporation Full time

    Job Requisition ID: 10128 Position Status: Permanent Full Time Position Type: Hybrid Office Location: Ottawa (ON); Toronto (ON) Travel Requirement: Travel not required Language Designation: English Essential Language Skill Levels (Read/Write/Speak): ZZZ Salary: Our salaries generally range from $ 83038.35 to $ 103797.93 and are based on qualifications...


  • Ottawa, Canada Canada Mortgage and Housing Corporation Full time

    Job Requisition ID: 10128 Position Status: Permanent Full Time Position Type: Hybrid Office Location: Ottawa (ON); Toronto (ON) Travel Requirement: Travel not required Language Designation: English Essential Language Skill Levels (Read/Write/Speak): ZZZ Salary: Our salaries generally range from $ 83038.35 to $ 103797.93 and are based on qualifications...


  • Ottawa, Canada CMHC Full time

    Job Requisition ID: 10128 Position Status:  Permanent Full Time  Position Type:  Hybrid Office Location:  Ottawa (ON); Toronto (ON) Travel Requirement:  Travel not required  Language Designation:  English Essential  Language Skill Levels (Read/Write/Speak):  ZZZ  Salary:  Our salaries generally range from $ 83038.35 to...

  • Operations Analyst

    3 weeks ago


    Ottawa, Canada Crisis24 Full time

    At Crisis24, A GardaWorld Company, we take a proactive approach to solving business challenges and our customers are at the heart of everything we do. It’s the reason we love rolling up our sleeves and getting down to work - and it’s why we’re so successful. It takes an entire team to stand behind something big. Interested? Operations Analyst - Ottawa...


  • Ottawa, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategiesOur client has a requirement for the provision...