Senior Data Analyst (Canada, Remote)
Remote - Canada
|Contract
Our client is a well-established financial services firm, operating in a data-intensive environment where accurate, timely reporting underpins critical decisions across their investment and wealth management functions. As the organization continues to grow and modernize its analytics capabilities, they're looking to add two technically strong Data Analysts to the team.
This is a hands-on, technical Data Analyst role that sits at the intersection of data engineering and decision-making. You'll partner closely with business stakeholders, BI/reporting teams, and technology partners to turn ambiguous business questions into reliable metrics and clean, auditable datasets, but you'll also own a meaningful slice of the pipeline itself.
A core part of the job is writing stored procedures to transform and move data as it flows from third-party vendor sources through the Medallion architecture layers, so you'll need to be genuinely comfortable in T-SQL and confident working across bronze, silver, and gold. The work is Microsoft-stack-first; what matters is that you're strong in T-SQL and Power BI and know your way around the Microsoft ecosystem.
You're a strong fit if you have 7+ years in an analytics role within some financial services industry experience, you take ownership of data quality from source to report, and you're just as comfortable writing the transformation logic as you are explaining the resulting numbers to a non-technical stakeholder.
There are two openings. Each is a 6-month contract to start, with a strong likelihood of renewal. Both positions are fully remote within Canada. Only candidates currently residing in Canada will be considered.
Mandatory Requirements:
This is a hands-on, technical Data Analyst role that sits at the intersection of data engineering and decision-making. You'll partner closely with business stakeholders, BI/reporting teams, and technology partners to turn ambiguous business questions into reliable metrics and clean, auditable datasets, but you'll also own a meaningful slice of the pipeline itself.
A core part of the job is writing stored procedures to transform and move data as it flows from third-party vendor sources through the Medallion architecture layers, so you'll need to be genuinely comfortable in T-SQL and confident working across bronze, silver, and gold. The work is Microsoft-stack-first; what matters is that you're strong in T-SQL and Power BI and know your way around the Microsoft ecosystem.
You're a strong fit if you have 7+ years in an analytics role within some financial services industry experience, you take ownership of data quality from source to report, and you're just as comfortable writing the transformation logic as you are explaining the resulting numbers to a non-technical stakeholder.
There are two openings. Each is a 6-month contract to start, with a strong likelihood of renewal. Both positions are fully remote within Canada. Only candidates currently residing in Canada will be considered.
Mandatory Requirements:
- 7+ years of experience in a Data Analyst or Engineer role, ideally within investment, wealth management, or financial services.
- Strong T-SQL skills, including writing and maintaining stored procedures to transform and move third-party vendor data across Medallion layers, plus complex querying, performance considerations, and working across multiple datasets.
- Hands-on, working knowledge of Medallion architecture.
- Hands-on ETL experience.
- Strong Power BI proficiency, including authoring DAX measures, building dashboards and reports, and working closely with BI/reporting teams.
- Grounding in the Microsoft data stack, whether modern Azure data services or a more traditional Microsoft environment (e.g., SSIS, SSRS).
- Strong analytical skills: ability to interpret complex datasets, spot issues, and explain findings clearly to non-technical stakeholders.
- Practical experience shaping and preparing data for reporting and analysis: joins, transformations, reconciliations, and KPI logic.
- Demonstrated experience defining and documenting metrics, calculations, and reporting requirements so outputs are repeatable and auditable.
- Experience with Azure data services such as Azure Data Factory, Azure Data Lake, Synapse Analytics, or Azure Databricks.
- Hands-on dimensional modelling experience — designing star schemas and fact/dimension tables, not just exposure to the concepts.
- Production experience with dbt for managing transformations, with version-controlled, documented, peer-reviewed models.
- Experience building automated data validation and anomaly-detection workflows in Python (e.g., pandas).
- Familiarity with data quality monitoring frameworks or automated validation workflows.
- Background and reference checks will be required before the start date if you are selected as the winning candidate.