Sr. SQL Business Systems Analyst

Highbrow LLC; Toronto; Hybrid; CAD 100,000 - 125,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

Job Title: Sr. SQL Business Systems Analyst

Job ID: 2024-12858

Job Location: Toronto, ON (2 days/week onsite)

Job Travel Location(s):

# Positions: 1

Employment Type: W2

Duration:Long Term

# of Layers:0

Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers

Key Technology:Business Analysis, SQL, Power BI

Job Responsibilities:

• Analyze current data processes and make recommendations for improvement based on industry trends and professional business knowledge
• Work directly with team to understand analysis and design needs
• Use a variety of data analysis and organization tools to discover the most impactful
• Implement data products curated by our Chief Data Office, as well as custom data models for fit for use.
• Ensure data quality and integrity across various data sources and systems to ensure data accuracy, completeness, and reliability.
• Optimize data pipelines for performance and scalability.
• Provide technical support to promptly resolve escalated incidents/outages.
• Develop and document a detailed solution design, impart your subject matter expertise throughout life cycle.
• Develop system performance and development standards requirements, then develop functional, technical and designs.
• Build design leverages existing reusable components, traces back to business requirements, and that new modules are designed with reusability in mind.
• Keep up to date with the latest industry trends and technologies related to data engineering.

Skills and Experience Required:

Required:

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

Desired:

• Experience with: Java, Spring,
• Experience with big data tools: Hadoop, HDFS, ADLS, ADF, Spark, Kafka, Databricks,
• Experience in Python
• Knowledge of Capital Markets.

Education:

• Undergraduate Degree.