At a Glance
- Tasks: Collect and analyse data, build dashboards, and support reporting for exciting projects.
- Company: Dynamic consulting firm in Ottawa with a collaborative culture.
- Benefits: Competitive salary, flexible schedule, pension plan, and work-from-home options.
- Other info: Join a hybrid team with opportunities for growth and learning.
- Why this job: Gain hands-on experience in data analytics and make impactful contributions to real-world projects.
- Qualifications: Experience with SQL, Power BI or Tableau, and strong Excel skills.
The predicted salary is between 99000 - 121000 $ per year.
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
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 in Ottawa employer: Talantir
O2E Brands is an exceptional employer that champions a dynamic and innovative work culture, perfect for those looking to make a significant impact in the marketing landscape. With a focus on employee growth and development, we offer unique opportunities to lead high-performing teams while driving ambitious brand strategies across our franchise portfolio. Located in a vibrant community, our commitment to fostering collaboration and creativity ensures that every team member plays a vital role in achieving our goal of $1.4B in revenue by 2030.
