Senior SQL & Data Systems Analyst — Optimize Data Pipelines

Highbrow LLC; Toronto; Hybrid; CAD 120,000 - 150,000; Full time

Job summary

A leading technology consulting firm in Toronto is seeking a Senior SQL Business Systems Analyst with over 10 years of experience in business analysis. The candidate will analyze data processes, implement data products, and ensure data quality. Experience with SQL and NoSQL databases, alongside skills in Java and big data tools, is desirable. A strong educational background is required. This position involves hybrid work (2 days/week onsite) and offers an opportunity to work with cutting-edge technologies.

Qualifications

• 10+ years of relevant experience as a Business Analyst.
• Must be an experienced user with relational SQL and NoSQL databases.
• Ability to write SQL queries.

Responsibilities

• Analyze current data processes and recommend improvements.
• Work directly with team to understand analysis and design needs.
• Implement data products curated by the Chief Data Office.
• Ensure data quality and integrity across various sources.
• Optimize data pipelines for performance and scalability.
• Provide technical support for escalated incidents.
• Develop detailed solution designs.
• Build designs that leverage existing reusable components.

Skills

Business Analysis

SQL

Power BI

Java

Spring

Hadoop

HDFS

ADLS

ADF

Spark

Kafka

Databricks

Python

Education

Undergraduate Degree

Job description

A leading technology consulting firm in Toronto is seeking a Senior SQL Business Systems Analyst with over 10 years of experience in business analysis. The candidate will analyze data processes, implement data products, and ensure data quality. Experience with SQL and NoSQL databases, alongside skills in Java and big data tools, is desirable. A strong educational background is required. This position involves hybrid work (2 days/week onsite) and offers an opportunity to work with cutting-edge technologies.