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
Data Analyst / Business Intelligence Analyst employer: NorthBridge Analytics
Join our dynamic team in Ottawa, ON, where we prioritise a collaborative work culture that fosters innovation and professional growth. As a Data Analyst, you'll enjoy hands-on experience with diverse projects, flexible scheduling, and comprehensive benefits including a company pension and RRSP match. Our commitment to employee development ensures you have the resources and support needed to thrive in your career while contributing to impactful data-driven insights.
