Business Analyst

Job summary

Develop and test SQL queries, implement business rules, and support the creation and validation of data quality requirements. Translate business requirements into technical logic and investigate data discrepancies in financial data environments.

Job details

Hi, Job opening for Finance business analyst Finance business analyst 12 months Montreal, QC The strengths and skills that will help you succeed Education Bachelor’s degree in computer science, Information Management, Data Science, Business Administration, Finance, or a related field. Years of Experience 4–6 years of professional experience in: SQL development (writing queries, testing, and rule implementation). Data quality support (assisting in DQR creation and validation). Business analysis (translating requirements into technical logic). Working within financial data environments. Languages English (mandatory). French (a plus). Technical Skills SQL: Strong proficiency in query development and data manipulation. Data Quality Tools: Experience with data validation frameworks or metadata management tools (e.g., Collibra) is an asset. Visualization Tools: Familiarity with Power BI or Tableau for dashboarding. Project Management Tools: Experience with Jira or Azure DevOps. Microsoft Office Suite: Proficiency in Excel (for analysis) and Word/PowerPoint (for documentation). Soft Skills Technical Communication: Ability to translate business needs into technical steps and communicate with both technical and non-technical colleagues. Problem-Solving: Analytical mindset to troubleshoot data discrepancies and identify causes. Collaboration: Ability to work effectively within a global, multi-functional team. Rigour: High attention to detail and a commitment to data accuracy. Adaptability: Ability to manage tasks in a fast-paced, regulatory-driven environment.

What you’ll do

Develop and test SQL queries, implement business rules, and support the creation and validation of data quality requirements. Translate business requirements into technical logic and investigate data discrepancies in financial data environments.

Requirements

Requires a bachelor’s degree in a relevant field and 4–6 years of experience in SQL development, data quality support, business analysis, and financial data environments. Strong SQL skills and English are required; experience with data quality or metadata tools, visualization platforms, and project management tools is an asset.

Listed skills

• Business analysis · Preferred
• Power BI · Preferred
• Tableau · Preferred
• Jira · Preferred
• Microsoft Excel · Preferred
• Problem solving · Preferred
• Cross-Functional Collaboration · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL Development
• Data Manipulation
• Data Quality Validation
• Business Analysis
• Financial Data Analysis
• Data Validation Frameworks
• Metadata Management
• Collibra
• Power BI
• Tableau
• Jira
• Azure DevOps
• Microsoft Excel
• Technical Communication
• Problem-Solving
• Cross-Functional Collaboration

Job areas

• Finance & Accounting
• Data & Analytics
• Technology
• Consulting

More jobs from Soho Square Solutions