Data Analyst / Business Intelligence Analyst

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
• Strong 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