Job Overview

We are seeking a Data Analyst to join our team in Ottawa, ON. This role focuses on supporting day-to-day reporting, dashboard development, and data analysis for internal and client-facing projects. The ideal candidate is comfortable working with structured data, building reports, and collaborating with stakeholders to translate business needs into clear, data-driven insights. This position offers hands-on experience across multiple projects in a collaborative consulting environment.

Duties

- Collect, clean, and validate data from sources such as SQL databases and Excel files
- Build and maintain dashboards using Power BI or Tableau for business reporting
- Analyze data to identify trends, anomalies, and opportunities for improvement
- Work with team members and stakeholders to gather reporting requirements and define KPIs
- Prepare recurring reports and assist in automating routine data tasks
- Support data modeling and basic data transformations for reporting purposes
- Ensure accuracy and consistency of data across reports and dashboards
- Document data sources, definitions, and reporting processes
- Provide clear summaries of findings to both technical and non-technical audiences

Experience

- 1–3 years of experience in a Data Analyst or similar role
- Experience working with SQL for querying and data extraction




- Experience building dashboards using Power BI or Tableau
- Solid Excel skills (pivot tables, lookups, formulas)
- Basic understanding of data modeling and reporting structures
- Familiarity with business analysis concepts and working with stakeholders
- Exposure to Python or R is an asset, but not required
- Ability to communicate insights clearly and work in a team environment

Education

- Diploma or Degree in Data Analytics, Computer Science, Engineering, Business Intelligence, or a related field

Nice to Have

- Experience working with ETL processes or data pipelines
- Exposure to cloud platforms such as Azure, AWS, or Google Cloud
- Microsoft Power BI Certification (PL-300) or similar
- Experience improving or automating reporting processes

Work Requirements

- Must be legally authorized to work in Canada
- Ability to work in a hybrid environment (Ottawa area)
- Security clearance is an asset, depending on project requirements

Pay

$75,000.00-$90,000.00 per year

Benefits

- Company pension
- Dental care
- Flexible schedule
- On-site parking
- RRSP match
- Work from home

Experience

- Microsoft SQL Server: 2 years (preferred)
- Power BI or Tableau: 1 year (required)
- data analysis: 2 years (preferred)

Work Location

Hybrid remote in Kanata, ON

📌 Data Analyst (Ottawa)
🏢 Talantir
📍 Ottawa