Internship Opportunity


BI Developer Analyst

Merit Travel Group
Travel Industry
Number of Positions:
Application Deadline:
Dec 07, 2018
Start Date:
Jan 07, 2019
End Date:
May 10, 2019

Job Description:


The BI Developer Analyst will report directly to the Sr. Director of Business Intelligence and work closely with various business unit leads, vendors and internal EBI team members.  The BI Developer Analyst will design and develop company-wide data analysis and reporting solutions. The BI Developer Analyst is expected to analyze data from multiple internal and external sources and communicate their results and recommendations to non-technical as well as technical team members.

The BI Developer Analyst works on initiatives that span the entire organization, including regional offices. This individual will have a proven track record of delivering client facing solutions using the latest technologies specifically concentrating on a heterogeneous data stack primarily based in Microsoft and Tableau Server technologies. An interest in emerging trends is an asset.


A detailed understanding of SDLC and attention to detail in updating documentation with changes to internal business processes, the website and database are essential.
Key contributor providing analytical support, data, recommendations and analysis to our business stakeholders
Develops in-depth understanding of underlying data, data structures, KPIs, and business uses of data to provide clear data visualizations and analysis
Maintains/updates business intelligence tools, databases, dashboards, systems, and methods (Tableau Server).
Data validation testing as new reports come online and replace existing reports.
Assists with ongoing systems and process improvement initiatives to ensure efficient data capture and reporting capability
Provides ad-hoc analysis as required to aid management decision making and business planning
Provide accurate work estimates
Other duties as assigned by manager


Works closely with Accounting Managers
Works closely with Business Unit Managers and Leads


Hours are commensurate with responsibility
Office environment


Previous report and dashboard development experience using Crystal, SSRS, Tableau or similar BI tools
Experience with SQL databases and DW/ETL processes and tools in a Microsoft BI stack
Strong grasp of SDLC and development including VS and Eclipse IDEs, web services, working with APIs, etc.
An aptitude for QA testing
Strong research skills, adaptability and organizational abilities with an attention to detail


Excellent communication skills, highly personable
Software/hardware knowledge of Windows client and server platform, networking
Ability to respond to change and problem solve
Ability to multi-task
Works well under pressure, able to set deadlines and monitor department performance
Takes initiative to reach and exceed expected targets  
Ability to present reports with clearly outlined objectives, processes, and metrics
Attention to detail balanced by the ability to see the “big picture” 

About H.I.S. Merit Travel Group

Merit Travel Group is a speciality travel company established in 1991 by Michael Merrithew and Louise de Grandpré. Now one of Canada’s largest independent travel companies with offices across Canada, Merit Travel services more than 350, 000 Canadians each year across their speciality brands; Merit Travel, Travelcuts, MeritBiz, Merit Loyalty and Exclusive Tours. Merit Travel Group is jointly owned by the Merrithew Family and Tokyo-based, H.I.S. Co. Ltd., a publicly traded global company with ¥606B in annual revenues.

Employer Question 1:

What interests you most about this role?

Employer Question 2:

Please list the computer systems and/or software that you are proficient in.

Employer Question 3:

Are you legally eligible to work in Canada for the entire duration of this internship?