Financial Data Analyst
- Kirkland, QC, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- 0–2 years of experience.
- Posting language
- English
- Posted
Original job description
About the role
Join our Finance BI team as an early-career analyst who’s as comfortable with a trial balance as with a SQL query. You’ll learn our Microsoft Fabric platform (SQL and Python notebooks, Power BI) on the job and grow into our Finance Data & Automation Analyst role. You’ll start by running and checking existing processes, then build new ones with a senior colleague reviewing your work.
What you’ll do
- Support month-end close: run the refresh checklist, tie outputs to the trial balance, and chase down breaks
- Write SQL or Python data-quality checks and investigate what they find
- Maintain Power BI and Excel reports and answer data questions from regional finance
- Build small tables, notebooks and measures under senior review
- Keep runbooks and the data dictionary current
What you’ll bring
- A bachelor’s or master’s degree in accounting, finance, information management or computer science (completed or completing by your start date)
- 0–2 years of experience. Internships, part-time jobs and class projects count
- Accounting basics: double entry, accruals, trial balance to financial statements, reconciliations
- SQL (joins, grouping) and Python pandas basics
- A dashboard you’ve built in Power BI or Excel; comfort with lookups and pivot tables
- Care with numbers, the habit of asking when unsure, and clear written English
Nice to have
- CTEs or window functions in SQL
- DAX, Fabric lakehouse experience or a PL-300 certificate
- Git, PySpark or Jupyter/Fabric notebooks
- Power Query
- CPA exam subjects passed
- Consolidation, intercompany or FX translation knowledge
- Experience using AI tools while checking every result against the source
- A class or personal project you can demo
- Mandarin Chinese
More about this job
Responsibilities
Support month-end close by running refresh processes, reconciling outputs to the trial balance, and investigating data issues. Maintain finance reports and documentation, respond to regional finance data questions, and develop small data assets and checks under senior review.
Requirements
Applicants must have or be completing a degree in accounting, finance, information management, or computer science, with 0–2 years of experience; internships and projects count. They should understand core accounting concepts, have basic SQL and Python pandas skills, and have built a Power BI or Excel dashboard.
Skills
- Accounting
- Financial Reconciliation
- SQL
- Python
- Pandas
- Power BI
- Excel
- Data Quality
- Data Analysis
- Microsoft Fabric
- Data Visualization
- Power Query
- DAX
- Git
- PySpark
- Written Communication
Visa sponsorship
Not detected in the job text
Categories
- Finance & Accounting
- Data & Analytics
- Technology
Keywords
- Finance Business Intelligence
- Microsoft Fabric
- SQL
- Python
- Pandas
- Power BI
- Excel
- Month-End Close
- Trial Balance
- Double-Entry Accounting
- Accruals
- Financial Statements
- Reconciliations
- Data Quality Checks
- Data Analysis
- Data Dictionary
- Runbooks
- Dashboards
- DAX
- Power Query
- Fabric Lakehouse
- PL-300
- Git
- PySpark
- Jupyter Notebooks
- CPA
- Consolidation
- Intercompany Accounting
- Foreign Currency Translation
- Artificial Intelligence