Job Search and Career Advice Platform

Enable job alerts via email!

Sr. SQL Business Systems Analyst

Highbrow LLC

Toronto

Hybrid

CAD 100,000 - 125,000

Full time

Today
Be an early applicant

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

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.
Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.