- Soho Square Solutions
- Montreal, QC
- Full-Time
- 6 days ago
Finance Business & Data Analyst.
Before you go
Before you leave us, sign up for our email alerts
We don't do job spam, just the best digital jobs delivered straight to your inbox.
Finance Business & Data Analyst: our view in 3 lines...
- The Role:This role is for a hands-on analyst who writes and tests SQL rules that check the quality of finance and tax data.
- The Person:The person will write, test and deploy data quality rules written in SQL, translate finance requirements into SQL logic, map source datasets and dependencies, and help build exception dashboards for data quality KPIs.
- Requirements:The ideal candidate has 4+ years of experience writing SQL queries, experience in a finance setting, and a track record of turning business requirements into technical logic.
About the role
Finance Business & Data Analyst (SQL) | Montréal, Hybrid | 12-Month Contract
Soho Square Solutions is hiring a Finance Business & Data Analyst for a global bank’s Financial Data Office in Montréal. This is a hands-on SQL role inside Finance.
You’ll write the SQL behind hundreds of data quality rules for the Finance and Tax systems. You’ll take a business description of a data quality check, work out the source tables and dependencies, write the query, and take it through simulation and UAT before it goes to production.
What you’ll do
- Write, test and deploy SQL-based Data Quality Rules (DQRs) for finance and tax data
- Translate finance business requirements into SQL logic
- Map source datasets, table relationships and dependencies
- Test rules in simulation and UAT before production release
- Work with UK and international teams on data architecture questions
- Help build exception dashboards for data quality KPIs
What you bring
- 4+ years of experience writing SQL queries yourself. Maintaining or reviewing someone else’s SQL won’t be enough.
- Experience in a finance setting such as accounting, financial reporting, regulatory reporting, tax, treasury or product control
- A track record of turning business requirements into technical logic
- Bachelor’s degree in Computer Science, Finance, Information Management or a related field
- English required. French is a plus.
Nice to have
- Knowledge of data quality dimensions such as accuracy, completeness and timeliness
- Power BI or Tableau, advanced Excel, Alteryx or ETL
- Collibra or other metadata tools, Jira or Azure DevOps
Details
- 12-month contract
- Downtown Montréal. Hybrid with 3 days a week in the office, including a Monday or Friday.
#SQL #DataQuality #FinanceJobs #MontrealJobs #BusinessAnalyst #Hiring

