Search jobs > Montreal, QC > Data analyst

Data Analyst

Veterans Lighting. Inc. dba Veterans Electrical Solutions
Montreal, QC, Canada
$36K a year (estimated)
Full-time

Vtech Solution Inc is looking for a Data Analyst to support their Marketing & Communications (Marcom) reports by optimizing SQL codes, building ETL solutions, and maintaining data pipelines.

This role collaborates with data specialists, architects, and project teams to ensure data quality and integration.

In this role you can expect to have the responsibilities :

  • Develop, maintain, and optimize SQL codes.
  • Build ETL solutions in Databricks and SSMS for Marcom reports.
  • Review and develop code used by department data analysts.
  • Integrate data from multiple sources, ensuring compliance with regulations and standards.
  • Maintain data pipelines to process and transform raw data.
  • Identify and fix technical issues with redundancy.
  • Support data analysts with data knowledge and debugging.
  • Collaborate with various specialists to design and document data integration flows.
  • Troubleshoot SQL jobs, document work, and execute deployments.
  • Design and implement data models to support business needs.
  • Perform root cause analysis for data issues.
  • Assist stakeholders in accessing necessary data.
  • Ensure data quality through monitoring and validation.
  • Create or update complex Power BI datasets.
  • Improve Power BI dataset performance.
  • Write codes in DAX and Power Query.

This role comes with the following benefits :

  • Dental care
  • Extended health care
  • Paid time off

This role requires you to have :

  • Minimum of 5 years in data management and analysis.
  • 5 years experience with SQL for RDBMS like Azure SQL and MS SQL Server.
  • 2 years experience with Databricks.
  • 2 years experience with Power BI (including DAX, Power Query).
  • Experience with data warehouses in star and snowflake schema.
  • Experience with data modeling and release management.

You would benefit from having :

  • Experience managing Marketing data (e.g., Google Analytics, SAP, Eloqua).
  • Experience working in large organizations.
  • Experience using GIT versioning.

The position involves a hybrid work setup in Montreal and requires 2 years of experience in marketing data analysis, data analytics, Azure Databricks, and Power BI.

J-18808-Ljbffr

18 days ago
Related jobs
Bell
Montreal, Quebec

The team consists of BI experts for analyzing data, capacity planning management for sourcing and maintaining data, and data scientists for building algorithms, including AI/ML solutions. Manipulating large & complex datasets Statistical software and data-mining tools and methods; such as SAS, SPSS,...

CB Canada
Canada

The Select Group is seeking a Data Analyst for their top telecommunication client. For this role, the Analyst will join a team that manages the data lakes within the Google Cloud. ...

Vantage Data Centers
Montreal, Quebec

Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and large enterprises. Developing and operating across North America, EMEA and Asia Pacific, Vantage has evolved data center design in innovative ways to deliver dramatic ...

Vivendi Universal
Montreal, Quebec

As part of the game production team, and working under the supervision of the Global Director of Data Science and Analytics, the successful candidate will work closely with relevant parties to collect, clean, analyze and automate the data-exploitation process. Additionally, the candidate will collab...

Barco
Montreal, Quebec

This role will require a deep understanding of business data analysis, data visualization, data modelling and workspace governance. DATA ANALYST CINEMA – MICROSOFT POWER BI. The Data Analyst will be responsible for designing, developing, and deploying business analytics dashboards using Microsoft BI...

FocusGroupPanel
Laval, Quebec
Remote

Remote Work From Home Data Entry Clerk for Entry Level Position. You enjoy data entry work and can perform the work from your home or location of choosing (remote work from home job). ...

American Express Global Business Travel
Canada

Liaise with data development and business teams such as Revenue Management teams to enhance the understanding and use of data and analytics capabilities. Experienced in Insight/Data/MI Analyst. The position of Marketplace Optimization Analyst sits within the Air and Ground Transportation Team and is...

Air Inuit
Montreal, Quebec

Advanced expertise in dimensional data models, database design and development, data mining, segmentation techniques, data warehouses, batch processing and reporting techniques. Contributes to the IT efficiency of organizational activities by designing, managing, maintaining and developping data str...

Stripe
Canada
Remote

Business Intelligence Engineering, Data Engineering, Data Analysis or Data Science roles, building data pipelines and analyzing large datasets to solve problems. Data Science at Stripe is a vibrant community where data analysts, data scientists and engineers learn and grow together. You will work wi...

data.ai
Canada
Remote

We are looking for an outstanding Junior Data Analyst interested in working in the hot space of app store data and analytics to join our phenomenal Data Science team at data. I work closely with Product Managers to help understand the efficacy of released product features and collaborate with Data A...