Senior Analytics Engineer

Raymond James

Vancouver

On-site

CAD 105,000 - 120,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Flexible workstyles
Competitive compensation
Health Benefits
RRSP Matching Program
Employee Stock Purchase Plan
Paid Time Off
Tuition Reimbursement

Job summary

Raymond James Ltd. is seeking an experienced Senior Analytics Engineer to design and build scalable cloud data pipelines and semantic models that enable trusted analytics across the organization.

You will work within the Enterprise Data team to transform complex source data into reliable assets and support reporting and self-service analytics. The role covers data-product lifecycle from requirements to deployment, using Microsoft Fabric or Databricks, Spark, SQL, and dbt, with emphasis on data

Qualifications

  • 6+ years in data engineering, analytics engineering, BI, or related role.
  • 3+ years building production data solutions on Microsoft Fabric/Azure Synapse, Databricks, or comparable cloud platforms.
  • Strong hands-on PySpark and SQL, including pipelines and transformations.
  • Experience designing dimensional and semantic models for enterprise analytics.
  • Experience with dbt, CI/CD, automated testing, and source control.

Responsibilities

  • Translate business and analytical needs into scalable data solutions.
  • Design, build, deploy, and support batch and near-real-time data pipelines in Microsoft Fabric using Spark and SQL.
  • Integrate, cleanse, and model data into governed silver and gold layers, data marts, and semantic models.
  • Optimize Spark and SQL workloads for performance and reliability.
  • Apply modern engineering practices: source control, testing, CI/CD, monitoring, and recovery.
  • Implement data governance, lineage, metadata, security, privacy, and governance controls.
  • Enable agentic analytics and NL-to-SQL through semantic models with guardrails.

Skills

Advanced SQL
Cloud data platforms
Microsoft Fabric
Databricks
PySpark
Spark SQL
dbt
CI/CD
Data modeling
Power BI
Data governance
Security & privacy
Git

Education

Bachelor’s or Master’s in CS/IS
Equivalent practical experience

Tools

Microsoft Fabric/Azure Synapse
Databricks
Power BI
dbt
Git
CI/CD tooling

Job description

At Raymond James, we develop, we collaborate, we decide, we deliver, and we improve together

Raymond James Ltd. is Canada's leading independent investment dealers offering high quality investment products and services to Canadians seeking customized solutions to their wealth management needs.

How does the role impact the organization?

We are seeking an experienced Senior Analytics Engineer reporting to the Manager, Reporting and Analytics within the Enterprise Data team. This role will design and build scalable cloud data pipelines, curated data products, and business-ready semantic models that enable trusted analytics across the organization.

The Senior Analytics Engineer will help the organization become more data-driven by transforming complex source data into reliable, governed, and reusable analytical assets. The role spans the full data-product lifecycle, including requirements analysis, source profiling, pipeline engineering, dimensional and semantic modeling, testing, documentation, deployment, and operational support. Working across the cloud data platform, the engineer will create high-quality data products that support reporting, self-service analytics, natural-language-to-SQL experiences, and future agentic analytics use cases.

What will your role be responsible for?
  • Partner with stakeholders to translate business and analytical needs into scalable data solutions.
  • Design, build, deploy, and support batch and near-real-time data pipelines in Microsoft Fabric using Spark, SQL, and platform-native capabilities.
  • Integrate, cleanse, and model data from diverse sources into governed silver and gold layers, dimensional models, data marts, and semantic models.
  • Optimize Spark and SQL workloads for performance, reliability, and scalability.
  • Apply modern engineering practices including source control, testing, code review, CI/CD, monitoring, and recovery.
  • Implement data quality, lineage, metadata, security, privacy, and governance controls.
  • Use dbt, where appropriate, to create tested, documented, and reusable transformations.
  • Enable agentic analytics and natural-language-to-SQL through well-governed semantic models, validation, and guardrails.
  • Maintain technical documentation and operational runbooks.
  • Mentor team members and contribute to enterprise data architecture, engineering standards, and continuous improvement.
What can you expect from us?

Our most important investment is in people. Upon eligibility, Raymond James Ltd offers flexible workstyles, a competitive compensation and benefits package. Our benefits range from Health Benefits, RRSP Matching Program, Employee Stock Purchase Plan, Paid Time Off, Volunteer Days, Discretionary Bonuses, Tuition Reimbursement and many more! We also support internal promotion and community involvement.

What do we expect from you?
  • Advanced SQL skills, including complex queries, window functions, CTEs, performance tuning, incremental processing, and data-quality reconciliation.
  • Strong hands-on experience with modern cloud data platforms, preferably Microsoft Fabric or Databricks, with practical knowledge of lakehouse and medallion architectures.
  • Advanced Apache Spark, PySpark and/or Spark SQL experience processing large datasets and troubleshooting distributed workloads.
  • Exposure to streaming semantics in Spark such as structured streaming, declarative pipelines and materialized lake views.
  • Experience building production-grade data pipelines, including orchestration, parameterization, dependency management, monitoring, alerting, retries, and operational support.
  • Strong data-modeling expertise across normalized, dimensional, and lakehouse patterns, including star schemas, slowly changing dimensions, semantic models, and business-ready silver/gold data products.
  • Experience with Git-based development, automated testing, CI/CD, and deployment across development, test, and production environments.
  • Knowledge of data governance, cataloguing, lineage, access control, privacy, and secure handling of sensitive data.
  • Working knowledge of Power BI semantic models is an asset; dbt experience, including modeling, testing, documentation, and incremental materializations, is preferred.
  • Exposure to agentic analytics, generative AI for data, or natural-language-to-SQL is preferred, with awareness of semantic grounding, evaluation, hallucination risk, access controls, and human validation.
  • Strong analytical judgment, attention to detail, communication, and client focus, with the ability to explain technical trade-offs, manage competing priorities, collaborate effectively, and take ownership through production support.
Education and experience:
  • Bachelor’s and/or master’s degree in computer science, data/software engineering, information systems, or a related field preferred; equivalent practical experience considered.
  • 6+ years of experience in data engineering, analytics engineering, business intelligence, or a related role.
  • 3+ years building production data solutions using Microsoft Fabric/Azure Synapse, Databricks, or comparable cloud data platforms.
  • Strong hands-on experience with PySpark and SQL, including data pipelines, transformations, performance optimization, and troubleshooting.
  • Experience designing dimensional and semantic models for enterprise analytics.
  • Experience with dbt, CI/CD, automated testing, and source control.
  • Experience in financial services is an asset.
  • Experience delivering data products in an Agile
  • Relevant cloud/data certifications are an asset.
We encourage our associates at all levels to:
  • Grow professionally and inspire others to do the same
  • Work with and through others to achieve desired outcomes
  • Make prompt, pragmatic choices and act with the client in mind
  • Take ownership and hold themselves and others accountable for delivering results that matter
  • Contribute to the continuous evolution of the firm
Salary Range:

$105,000 - 120,000 annually, in addition to competitive performance bonuses/incentives.

Actual compensation will be determined based on skills, experience, internal equity, and other job requirements.
This posting is for an existing vacancy.

At Raymond James – we honor, value, respect the uniqueness, experiences, and backgrounds of all of our Associates. When associates bring their best authentic self, our organization, clients and communities thrive, it is part of our people-first culture. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.
Here at Raymond James we demonstrate our commitment to ensuring equal opportunities for all candidates. To request accommodations, candidates are instructed to contact Human Resources via email at recruitment@raymondjames.ca. By reaching out to this email address, candidates can communicate their specific requirements and discuss the necessary accommodations they may need to participate fully in the recruitment process.

We may use automated or AI-enabled tools to support parts of our recruitmentand screening process, including screening, assessing or selecting applicants where applicable. These tools help us review applications efficiently,but they donot replace human decision-making.

Raymond James Ltd. is a member of the Investment IndustryRegulatory Organization of Canada (IIROC) and of the Canadian Investor ProtectionFund (CIPF). Customers' accounts are protected by the Canadian Investor ProtectionFund within specified limits. A brochure describing the nature and limits ofcoverage is available upon request or at . 3Macs, MacDougall,MacDougall & MacTier and Raymond James Correspondent Services are divisions ofRaymond James Ltd. Raymond James Ltd. is an integrated financial services firm. Itssubsidiaries, Raymond James Investment Counsel Ltd., Raymond James FinancialPlanning Ltd., Raymond James Trust (Canada) and Raymond James Trust (Québec) Ltd.are not members of the IIROC or the CIPF. Please consult each subsidiary's webpagesfor applicable corporate, regulatory or membership information. www.cipf.ca

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Manager, Marketing Intelligence and Effectiveness
Senior Manager, Marketing Intelligence and Effectiveness

Raymond James Ltd. • Toronto

Hybrid
CAD 120,000 - 140,000
Flexible workstyles
Health benefits
RRSP matching
+5
Senior Associate, Privacy
Senior Associate, Privacy

Raymond James Financial • Toronto

Hybrid
CAD 65,000 - 75,000
Flexible workstyles
Health benefits
RRSP matching
+5
Associate, Application Support
Associate, Application Support

Raymond James Financial • Vancouver

On-site
CAD 60,000 - 70,000
Health Benefits
RRSP Matching Program
Employee Stock Purchase Plan
+4
Talent Acquisition Specialist
Talent Acquisition Specialist

Raymond James Financial • Toronto

On-site
CAD 75,000 - 85,000
Health Benefits
RRSP Matching Program
Employee Stock Purchase Plan
+4
Administrative Assistant
Administrative Assistant

Raymond James Financial • Calgary

On-site
CAD 45,000 - 50,000
Health Benefits
RRSP Matching Program
Employee Stock Purchase Plan
+5
Securities Associate
Securities Associate

Raymond James Financial • Vancouver

On-site
CAD 50,000 - 60,000
Health benefits
RRSP matching
Employee stock purchase plan
+4
Client Access Support Associate
Client Access Support Associate

Raymond James Financial • Vancouver

On-site
CAD 50,000 - 55,000
Flexible workstyles
Health benefits
RRSP Matching Program
+5
Advisor, Internal Audit
Advisor, Internal Audit

Raymond James Financial • Vancouver

On-site
CAD 94,000 - 104,000
Health Benefits
RRSP Matching Program
Employee Stock Purchase Plan
+4
Manager, Information Compliance Risk Management (ICRM)
Manager, Information Compliance Risk Management (ICRM)

Raymond James Financial • Toronto

On-site
CAD 105,000 - 120,000
Health Benefits
RRSP Matching Program
Employee Stock Purchase Plan
+4
Portfolio Advisory Associate
Portfolio Advisory Associate

Raymond James Financial • Toronto

On-site
CAD 68,000 - 73,000