← Back to jobs

Alltech Consulting Services Logo
SQL Data Analyst

Alltech Consulting Services

 

Montreal, QC, Canada

Posted On: Just posted
Experience: 5+ years
Availability: Hybrid
Openings: 1
Category: SQL Data Analyst
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

You will own the development and maintenance of data reporting and ETL processes.

Responsibilities

  • Develop and maintain dashboards and visualizations in Power BI using SQL sources.
  • Build and maintain OLAP Cubes and Excel reports leveraging SQL, Excel Power Query, and Power Pivot (DAX).
  • Develop ETL processes using APIs, SSIS, and Python.
  • Collaborate with cross-functional teams to ensure project deadlines are met.

Required Skills

  • 5+ years of experience as a SQL Developer or similar role.
  • Expertise in SQL DB architectures and writing complex T-SQL queries within the Microsoft ecosystem.
  • Strong knowledge of Data Warehousing concepts.
  • Proficiency with Microsoft SQL Server and Admin Studio.
  • Hands-on experience with Microsoft Power BI and Microsoft Excel Power Query/Power Pivot (DAX).
  • Experience developing ETL using SSIS and Python.
  • Familiarity with PowerShell scripting.

Preferred Skills

  • Experience with Splunk.

Education

Bachelor's degree

Related Jobs

No related jobs found

← Back to jobs