Senior Analytics Engineer (Winnipeg)

Senior Analytics Engineer (Winnipeg)

22 Nov
|
Raymond James
|
Winnipeg

22 Nov

Raymond James

Winnipeg

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. 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. 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. 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. flexible workstyles, Our benefits range from Health Advantages, 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. 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. 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. 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. Power BI semantic models is an asset; experience, including modeling, testing, documentation, and incremental materializations, is preferred. 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. Bachelor’s and/or master’s degree in computer science, data/software engineering, information systems, or a related field preferred; 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 . PySpark and SQL , including data pipelines, transformations, performance optimization, and troubleshooting. dbt, CI/CD, automated testing, and source control . is an asset. Experience delivering data products in an Agile Relevant cloud/data certifications are an asset. 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

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

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 (winnipeg) / winnipeg

Subscribe to this job alert:

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