Analyste de données

FOP Consultants; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

A Canadian consulting company is seeking motivated data analysts for a full-time position in Montreal. The role involves cleaning and analyzing datasets, ensuring data quality, and designing database architecture. Candidates should have a relevant degree and 3-7 years of experience, with strong analytical skills and proficiency in SQL. Bilingualism in French is essential.

Qualifications

• Three to seven years of experience in data analysis.
• Experience with OLAP and OLTP data models.
• Strong skills in structuring data and correcting errors.

Responsibilities

• Clean and prepare data for analysis.
• Design and develop database architecture.
• Document user requirements.
• Ensure data integrity and confidentiality.
• Structure data for system usability.

Skills

Analytical skills

Data cleaning

Database architecture design

SQL proficiency

Communication in French

Education

Bachelor's or Master's degree in Computer Science or related field

Tools

SQL

SSRS

SSIS

Business Objects

Job description

Get AI-powered advice on this job and more exclusive features.

English will follow

About us :

We are a Canadian consulting company that provides engineering and science consulting services in the Pharmaceutical, Biopharmaceutical, Agrifood, Cosmetics, Medical Devices and Information and Communication Technologies sectors. We work closely with our clients to provide a tailor-made service that meets their needs and operational requirements. Thanks to our competent and qualified staff, FOP CONSULTANTS has as mission to serve clients in North America and elsewhere in the world.

Brief description of the position :

In order to meet the needs of its clients in the IT sector, FOP CONSULTANTS is looking for data analysts motivated to carry out assignments. The main tasks will include collecting, cleaning, analyzing and interpreting datasets to identify trends, generate insights, and help businesses make informed decisions.

Main responsibilities :

• Clean and prepare data to ensure its quality and reliability for analysis;
• Establish and document user requirements;
• Design and develop database architecture;
• Ensure the integrity, availability, usability, and confidentiality of data;
• Structure data to facilitate its use by various systems.

Qualifications :

Bachelor’s or Master’s degree in Computer Science, Management Information Systems or any other related field;

Three (3) to seven (7) years of experience in data analysis;

Strong analytical and synthesis skills to structure data, ensure integrity, correct errors, and determine the best methods to address client challenges;

Extensive experience with analytical (OLAP) and transactional (OLTP) data models and tools for their utilization;

Proficiency in SQL, SSRS, and SSIS technologies and tools;

Ability to contribute during product development to ensure the usability of generated data;

Capable of designing, building, modifying, integrating, testing, and implementing data models and database management systems;

Ability to communicate effectively in French, both orally and in writing;

Proficiency in Business Objects or other reporting tools, an asset.

Location : Montreal, Quebec, Canada

Number of positions available : 2 positions

Salary : To be discussed

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

Business Consulting and Services

J-18808-Ljbffr