Data Analyst

Pacer Group; Edmonton; On-site; CAD 60,000 - 100,000; Full time

Job summary

An innovative company is seeking a skilled Data Engineer to design and maintain scalable data pipelines that handle vast amounts of data both on-premises and in the cloud. The role involves utilizing various technologies, including Azure, AWS, and GCP, while ensuring best practices in DevOps are integrated into the workflow. Ideal candidates will have a strong background in data warehousing and experience with querying data using Microsoft Transact-SQL. Join a forward-thinking team where your expertise will drive impactful data solutions and contribute to the company's growth in the data landscape.

Qualifications

• Experience designing and maintaining scalable data pipelines.
• Proficient in querying data using Microsoft Transact-SQL.

Responsibilities

• Develop and maintain data pipelines for large data volumes.
• Integrate DevOps practices into the development workflow.

Skills

Data Pipeline Development

Data Warehousing

Microsoft Transact-SQL

DevOps Practices

Object-Oriented Programming

Scripting Languages (R, Python, Java, C++, Scala)

Tools

SSIS

Azure

AWS

GCP

Job description

Design, develop, and maintain scalable data pipelines to ingest, transform, and store large volumes of data both on-premises (SSIS etc.) and in the cloud (Azure, AWS, GCP)

Experience with data marts, data warehousing, BI tools, etc

Experience working with querying data with Microsoft Transact-SQL Server

Experience integrating DevOps practices to the development workflow using CI/CD best practices

Experience with object-oriented/object function scripting languages such as R, Python, Java, C++, Scala, etc.