Data Analyst, It

2 weeks ago


Montréal, Canada Studentcare Full time

**Who we are**:
ASEQ|Studentcare is the Canadian leader in health, dental and travel insurance for students across Quebec and Canada. We offer university and college students group insurance plans and other non-insurance products such as Student Assistance Programs (SAP) and telemedicine at attractive costs. Our objective is to make insurance easy and simple so that students can make informed decisions about their health and finances.

**Brief job description**:
The Data Analyst plays a crucial role in supporting business operations by designing and implementing data extraction, transformation, and loading procedures (ETL) using tools such as DTS, SSIS, or other tools. They are skilled at breaking down complex data sets, verifying data integrity through analysis, and creating reports for internal and external stakeholders. Additionally, the Data Analyst should have expertise in data modeling and be able to document processes, as well as have experience as a SQL developer. They may also need to interact with clients and suppliers to plan, execute, or resolve data transfer or integrity issues.

**Key duties and responsibilities**:
**The key responsibilities include, but are not limited to**:
Plan and execute Data INGEST and EXTRACT procedures, analysis routines, and reporting.

Import and process data from clients, including preliminary validation, and post-import analyses
Report on and resolve (or escalate) all data conflicts and/or errors.
Extract and export data to clients.

**Design and build ETL processes for new clients**: Gather requirements and model ETL solution architecture; work with development teams as required to execute on design and implementation.

**Finance Support**: Help finance teams interpret reports based on ingested / transformed data.

**Maintain and improve data structures**: Update processes as requirements change, optimize existing gaps in
data analyses and improve on methodology by using modern data modelling techniques such as dimensional
modeling and normalization.
Prepare ad-hoc reports as requested by internal stakeholders.
Manipulate ad-hoc data with Excel or scripts to assist other teams with data needs.

**Skills and qualities sought**:
Experience in data analysis, data manipulation, data architecture, database support (junior) and SQL query optimization
Expertise in data modelling
Be able to document data processes using Confluence
Strong problem solving skills
Ability to analyze and optimize data structures for efficient querying and data storage
Familiarity with data visualization tools such as Tableau or Power BI
Effective communication skills

**Requirements**:
DEC in Information technology or equivalent.
Excellent knowledge of, and experience with, Transact-SQL or other SQL language
Knowledge of MS SQL server (2014 / 2016 / 2019) and the Microsoft stack
Experience with DTS (SQL 2000) and/or SSIS (SQL 2014 +)
Good knowledge of French and English languages, both written and spoken: MANDATORY

**Work Conditions**:
Full-time, permanent



  • Montréal, Canada Atlantis IT group Full time

    **JD**: **Role - Data Analyst - Snowflake** **Location-Montreal, QC** **Duration - Contract** Role Description: Key Skills: Snowflake Thanks & regards, Jack **Apptoza Inc.** Phone: (678)-869-5418 Ext 5003

  • Data Analyst

    3 days ago


    Montréal, Canada Sanimax Full time

    Your professional transformation starts here Are you full of great ideas? Do you dream of building a greener future as part of a company that values your skills and opinions? Are you looking for a flexible employer that will give you the opportunity to grow within the company? This job is for you! As part of our ongoing growth, we seek a highly motivated...

  • Data Analyst

    6 days ago


    Montréal, QC, Canada Zortechsolutions Full time

    JD Data Analyst profile should be of level II with 3-5 Yrs. in PL/SQL, Python, Data export to pdf, TOPD, SQL and Data importing into UAT sites. Dealing with AWS S3, SFTP sites and BISCOM for data storage and Data Transfer. Scripting, root cause analysis and development of fixes during testing phase. Validating data and coordinating GO-Live activities...

  • Data Analyst

    4 weeks ago


    Montréal, QC, Canada Noverka Conseil Full time

    At Noverka, our values illustrate who we are and define our convictions: Human, Transparent, Passionate. We are driven by innovation and success, both in our relationships and in our practices. Finding the right job for the right person is what we do best! Our client, an insurance organization is looking for a Data Analyst. Job description : The Data...

  • Systems analyst

    7 days ago


    Montréal, Canada Fed IT Full time

    Are you looking for a new professional challenge? Systems analysis no longer holds any secrets for you? Do you want to join a company that combines high standards, performance and kindness? So take 5 minutes to read this ad, your future may be at the bottom of this offer! First of all, let me introduce myself, I am Earvin from the Fed IT recruitment firm in...

  • Systems analyst

    4 weeks ago


    Montréal, Canada Fed IT Full time

    Are you looking for a new professional challenge? Systems analysis no longer holds any secrets for you? Do you want to join a company that combines high standards, performance and kindness? So take 5 minutes to read this ad, your future may be at the bottom of this offer! First of all, let me introduce myself, I am Earvin from the Fed IT recruitment firm in...


  • Montréal, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...

  • Systems analyst

    4 weeks ago


    Montréal, QC, Canada Fed IT Full time

    Are you looking for a new professional challenge? Systems analysis no longer holds any secrets for you? Do you want to join a company that combines high standards, performance and kindness? So take 5 minutes to read this ad, your future may be at the bottom of this offer! First of all, let me introduce myself, I am Earvin from the Fed IT recruitment...

  • Data Analyst

    6 days ago


    Montréal, Canada Jetravail agence de placement Je Travail Placement Agency Full time

    Alright we are Recruiting Data Analyst. - Helping travelers online with low cost personalized advertising - Increase performance, creator feedback. - Responsibilities: Collect, organize and interpret statistical information to help colleagues and clients use it make decisions. Ather and scrutinize data using specialist tools to generate information that...


  • Montréal, QC, Canada Fed IT Full time

    Hello, I'm Clémence, recruitment and business development consultant at FED IT, a recruitment agency specializing in IT professions. I work on two types of recruitment: temporary and permanent. All our consultants are IT experts who speak your language and work in your environment. We cover the full range of IT professions: development, business...

  • Lead Data Analyst

    7 days ago


    Montréal, Canada ROI ADS LLC Full time

    **Join ROI Ads, LLC as a Lead Data Analyst and Shape the Future of Digital Marketing!** Are you passionate about data and the power it holds to drive strategic decisions? Do you have a knack for transforming complex datasets into meaningful insights? If so, we have an exciting opportunity for you! **ROI Ads, LLC**, a leading digital marketing company, is...

  • Data Analyst

    3 days ago


    Montréal, Canada MindGeek Careers Full time

    **Title: Data Analyst - User Journey** As a Data Analyst - User journey, you have a crucial role in extracting meaning from the mountain of data that our products generate. To do so, you will create advanced dashboards, build reports, dig into the data, and analyze trends. Working with a large-scale data lake platform that ingest billions of requests per...

  • Data Analyst

    4 weeks ago


    Montréal, Canada Vault Credit Corporation Full time

    **Get to Know Vault Credit Corporation** Vault is a non-bank private lending company offering a wide array of financial services such as mortgage, leasing and lending products. Vault has a devoted team of experts with years of experience in both financial services and real estate. We are dedicated to delivering products and services that meet the diverse...


  • Montréal, Canada International Air Transport Association (IATA) Full time

    Employment Type: Fixed Term Contract Contract Duration: Until Dec-2025 At IATA, we speak for the airlines of the world, serving and supporting over 300 of them across all continents. We are passionate and knowledgeable about the aviation industry, and we strive to make it safer, smarter, more sustainable and more inclusive. We celebrate diversity and...

  • Data Analyst

    6 days ago


    Montréal, Canada Intelcom Full time

    Ride the next mile with us! - We are seeking a Data Analyst - Sales Enablement to join our Sales team, reporting to the Commercial Strategy & Marketing Director. Your contribution will enable more effective decision-making, directly impacting our sales strategies, account health, and contributing to the overall sales growth and success. As part of the...

  • Data Analyst

    4 weeks ago


    Montréal, Canada Intelcom Full time

    Prêt à relever le défi? We are seeking a Data Analyst - Sales Enablement to join our Sales team, reporting to the Commercial Strategy & Marketing Director. Your contribution will enable more effective decision-making, directly impacting our sales strategies, account health, and contributing to the overall sales growth and success. As part of the...


  • Montréal, Canada NTT Data Services Full time

    Chez NTT DATA, nous savons, qu’avec les bonnes personnes à bord de notre équipe, tout est possible. La qualité, l'intégrité et l'engagement de nos employés sont des facteurs clés qui permettent la croissance et la présence sur le marché de notre entreprise. En embauchant les meilleures personnes et en les aidant à s’épanouir...

  • Data Analyst

    3 days ago


    Montréal, Canada Lightspeed Commerce Full time

    **What you'll be responsible for**: - Interpret large amounts of financial data that provide insight to the business through scalable and repeatable reports - Manage data accuracy requests from other departments and Ad-Hoc requests from senior leadsership - Perform data quality analysis and system performance checks across different systems (ERP, CRMs,...


  • Montréal, Canada Canadian National Railway Full time

    At CN, we work together to move our company—and North America—forward. Be part of our Information & Technology (I&T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and...


  • Montréal, Canada Desjardins Full time

    As a data analyst, you collect, process, analyze and use data that comes through different channels. You extract, describe, analyze and interpret the data needed to make informed business decisions. You provide guidance and support to clients for analytics solution mandates that involve using data and designing reports adapted to business needs. You use your...