Business Intelligence (BI) Consultant - Bilingual

ROSS; Montreal; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A business intelligence consultancy in Montreal is seeking a consultant with a minimum of 5 years of experience in business intelligence and strong skills in data architecture and analysis. The role requires bilingual proficiency in French and English, extensive travel (70%-80%), and the ability to work independently. Candidates should have excellent problem-solving and communication skills. This position offers a challenging opportunity in a vibrant working environment.

Qualifications

• Minimum 5 years of BI technical experience.
• Very strong skills in data architecture, modeling, and mining.
• Knowledge of Data Warehouse/Mart concepts preferred.

Responsibilities

• Translate client’s business requirements into technical solutions.
• Provide consulting support for product installation and implementation.
• Complete application testing and quality assurance.

Skills

Business Intelligence (BI)

Data architecture

Data modeling

Data mining

Java

SQL

Excellent problem-solving skills

Communication skills

Tools

Oracle

DB2

Microsoft SQL Server

Informatica

Cognos

Job description

For almost two decades, our client has helped corporations transform their operational data into actionable information. Their Business Intelligence platform gives businesses solutions to all of their query, reporting, and advanced analytical needs, and distributes insight to users via web, wireless and voice. With thousands of satisfied customers and over 500 technology and integration partners, our client has been proven to be one of the best, most complete solutions for business intelligence.

This position is based out of Montreal and therefore you must be bilingual in French and English. Extensive travel (approx 70%–80%) may be required, including travel to the US. Therefore you must be entitled for a TN Visa (eligible to Canadian citizens) or have another work visa for the US.

Responsibilities

• Understand and translate client’s business requirements into workable technical solutions.
• Provide billable consulting support to achieve account objectives and production success. Services may include: product installation and implementation, enhancement, integration or audit to meet customer business requirements.
• Complete all levels of application testing and q/a.
• Prepare all required documentation (specifications, design, system, training, user).
• Ensure up-to-date knowledge in industry business and technology solutions, through self‑motivated approach to continuous learning.
• Provide presentations, internally and/or with clients, as required.
• Mentor other consultants as required.
• Other duties as assigned.

Qualifications

• Minimum 5 years BI (business intelligence) technical experience.
• Very strong data architecture, data modeling, data mining skills (e.g., dimensions, metadata, etc.).
• Data Warehouse/Mart knowledge and experience is preferred, including knowledge of common industry approaches such as star schema and ‘corporate information factory’.
• Strong Java skills for integration and customizations.
• Knowledge of and experience with:
  • databases including one or more: Oracle, DB2, Microsoft SQL Server, Informix, Sybase
  • Windows and Unix
  • client server and web based environments
  • connectivity issues, infrastructure and protocols
  • one or more of: BEA Weblogic, Websphere, J2EE, web development
  • Business Intelligence development experience and programming experience (SQL, Visual Basic, C, C++); Web/Internet experience (JAVA, HTML, ASP, XML, XSL, JavaScript)
  • Demonstrated excellent problem‑solving skills.
  • Excellent written, verbal and interpersonal communication skills.
  • Ability to work independently and with a team.

Nice to Have

• Consulting experience with external clients, in competitive situations (independent software vendor company or Big4 consulting).
• ETL software (any flavour such as Informatica, AbInitio, etc.).
• Experience with BI products and tools (e.g., Cognos, Teradata, Peregrine, spss, g5, Hyperion, SAS, MicroStrategy, Business Objects, Information Builders, Angoss, CRM, etc.).

If you’re not interested, but know someone who is, please help a current or former colleague in their career development by referring them. In addition, we’re happy to give you a $750 referral fee. Click https://www.getROSS.com/referral_fee.php for more details.

Apply online.