Reporting Analyst

  • Full-time

Company Description

Ensemble Travel® Group is a travel industry related company which supports travel agencies with turnkey marketing and technology solutions. Founded in 1968, Ensemble is a proactive, member-owned international organization of approximately 850 professional travel agencies in the U.S. and Canada, and with recent expansion into Australia and New Zealand. With a membership that represents billions of dollars in travel sales each year, Ensemble Travel Group has achieved a 50-year record of boosting members' profits and delivering high-volume sales to its preferred suppliers.

Job Description

Ensemble Travel Group is currently looking for a SQL Report Developer. The SQL Report Developer is responsible for aspects of database reporting based on multiple related databases. Responsibilities also include designing table layouts, enhancements to existing processes, analyzing new business reporting needs, and creating new reports.

 

Responsibilities

  • Data integration and data migration activities.
  • Develop stored procedures, complex SQL queries, scripts and database programming for systems.
  • Assist in identifying process improvements for database performance, reliability and stability.
  • Participate in all of Software Development Life Cycle, starting from requirements, design, maintenance, enhancement, coding, and administration of SQL servers
  • Creates complex Graphs & Charts in ZOHO Reporting Tool with drill down functionality accessing SQL databases.
  • Prepares and delivers reports, recommendations, or alternatives for improving processes in reporting systems across the organization.
  • Researches, reviews, and analyzed the effectiveness and efficiency of existing report procedures and develops strategies for enhancing or further leveraging these processes

Qualifications

Minimum of 5 years of experience writing reports against Microsoft SQL Server databases.

Minimum of 5 years of experience working with data in a travel/hospitality related field

 

Experience with

Zoho, SQL and other drag and drop / analytic reporting tools

Statistical analysis

Additional Information

Travel:

Approximately 10% of travel is expected for this position with occasional international travel.

Supervisory Responsibility:

This position has no direct supervisory responsibilities.

Position type & expected hours of work:

This is a full-time position. Days and hours of work are Monday through Friday, 9:00 a.m. to 5 p.m. Occasional evening and weekend work may be required as job duties demand. This position is exempt from Overtime.

What we offer: 

  • Supportive team environment 
  • Mentoring and coaching opportunities 
  • Company match RRSP program  
  • Medical benefits 
  • Dental benefits  
  • Bonus program including travel bursary 
  • Comprehensive employee assistance program 
  • Health and Wellness subsidy  
  • 3 weeks’ vacation to start 
  • Corporate gym membership rates 
  • Advancement opportunities 

We thank all candidates for their interest however only those selected for an interview will be contacted.

We are is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require accommodation due to a disability at any stage of our hiring process, please advise us when completing your application.