Senior Analytics Engineer (Vancouver)

Senior Analytics Engineer (Vancouver)

22 Nov
|
Raymond James
|
Vancouver

22 Nov

Raymond James

Vancouver

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 advantages 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.

Educ

📌 Senior Analytics Engineer (Vancouver)
🏢 Raymond James
📍 Vancouver

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior analytics engineer (vancouver) / vancouver

Subscribe to this job alert:

Get the latest job offers by email for: senior analytics engineer (vancouver) / vancouver