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.
Senior Analytics Engineer
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 recruitment and screening process, including screening, assessing or selecting applicants where applicable. These tools help us review applications efficiently, but they do not replace human decision-making.