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 setting.
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

#J-18808-Ljbffr

📌 Data Analyst / Business Intelligence Analyst (Quebec City)
🏢 NorthBridge Analytics
📍 Quebec City