Date Posted
Category
Salary
Job type
Work model
Level
Location
Unfortunately, this job posting is expired.
Company

EnsembleSee more

addressAddressMontreal, QC
CategoryIT

Job description

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

The Sequel Developer and Reporting Manager acts as a Data Warehouse administrator, BI admin, and quality control for all internal and external facing reportable data.

This role leverages ETG supplier and member data for inclusion in CRM, Analytics, and Data Warehouse systems and maintains integrity and accuracy in available data. This position works with internal and external stake holders to initiate, implement, and support business objectives for all data related business requirements.

The SQL Report Developer and Manager 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, PHP scripts and database programming for systems.
  • Assist in identifying process improvements for database performance, reliability and stability.
  • Maintains data integrity with validation and QA control
  • 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.
  • Project manages the implementation, testing and user acceptance of new business products and procedures.
Qualifications
  • A creative individual with an eye towards visual design and the optimal user experience.
  • Familiarity with PHP and/or MYSQL languages
  • Basic understanding of accounting methodologies
  • 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 One, SQL, PHP, Python, and other drag and drop / analytic reporting tools

Statistical analysis

Core Competencies: * Problem Solving/Analysis
  • Attention to Detail/Organization
  • Technical Capacity
  • Communication Proficiency
  • Time Management
  • Integrity/Trustworthiness
  • Creativity & Data Architecture
  • Ethical Financial Practices
  • Innovation (forward thinking/enhanced processes)
  • Documentation
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.

Ensemble

Refer code: 860692. Ensemble - The previous day - 2022-12-08 07:30

Ensemble

Montreal, QC

Share jobs with friends