Talent.com
Senior Analyst, Data Insights & Optimization Canada
Senior Analyst, Data Insights & Optimization CanadaCircular Materials • Ottawa, Ontario, Canada
Senior Analyst, Data Insights & Optimization Canada

Senior Analyst, Data Insights & Optimization Canada

Circular Materials • Ottawa, Ontario, Canada
19 days ago
Job type
  • Full-time
Job description

OVERVIEW

Reporting to the Manager Data Insights & Optimization the Senior Analyst Data Insights & Optimization is a hands-on expert in translating complex data into clear actionable insights through high-quality business intelligence products. This role is focused on designing building and maintaining enterprise-grade Power BI dashboards powered by curated data from the organizations data warehouse.

You must be fluent in SQL and experienced working with dimensional models in modern data warehouse environments. You bring advanced Power BI skills (data modeling DAX Power Query performance optimization) and can independently take a dashboard from concept to production. With a strong continuous improvement mindset and comfort working in Agile teams you proactively streamline processes automate recurring workflows and help standardize best practices for reporting and analytics across the organization.

The ideal candidate must demonstrate successful cross-functional collaboration to understand business questions build trusted metrics and optimize decisions related to performance cost risk and the circular economy.

This is a salary paid position requiring residency in Canada.

RESPONSIBILITIES

Business Intelligence Solution Design & Delivery

  • Design build and maintain robust Power BI dashboards reports and semantic models that support operational financial regulatory and strategic decision-making.
  • Work end-to-end : requirements gathering data exploration data modeling dashboard design user acceptance training and production rollout.
  • Develop and optimize SQL queries against the data warehouse to source transform and validate the data feeding BI products.
  • Implement and maintain Power BI best practices (star-schema modeling DAX measures row-level security documentation and performance tuning).

Data Warehousing & Data Quality

  • Partner with Data Engineering and other technical teams to ensure data warehouse tables views and models meet reporting and analytics needs.
  • Profile and validate data to identify quality issues gaps and inconsistencies; work with stakeholders to resolve them.
  • Contribute to the definition of standardized governed metrics and KPIs ensuring consistency across reports and dashboards.
  • Insights Analysis & Optimization

  • Translate business questions into analytical approaches leveraging the data warehouse and BI tools to deliver clear actionable insights.
  • Build recurring and ad-hoc analytical views that highlight trends variances and drivers behind key performance indicators.
  • Support optimization initiatives (e.g. improving program performance cost efficiency service levels) through scenario analysis root-cause exploration and data-driven recommendations.
  • Continuous Improvement & Ways of Working

  • Champion a continuous improvement mindset : identify opportunities to streamline reporting processes reduce manual effort and increase automation.
  • Contribute to standard templates reusable data models and visual design guidelines that improve speed and consistency of BI delivery.
  • Work within Agile ways of working (sprints backlogs stand-ups) providing transparent updates on progress risks and dependencies.
  • Stakeholder Engagement & Enablement

  • Collaborate with stakeholders to clarify requirements co-design mock-ups and iterate on dashboards based on feedback.
  • Present insights in a clear business-friendly way tailoring depth and technical detail to executive operational and technical audiences.
  • Develop and deliver training materials (how-to guides demos knowledge-base content) to help business users self-serve and better understand BI tools and metrics
  • QUALIFICATIONS

    Education

  • Post-secondary education / Bachelors degree in a relevant field such as Engineering Economics Business or a related discipline.
  • An equivalent combination of education and experience may be considered.
  • Experience

  • 5 years of progressive experience in data analytics business intelligence or a related field with a strong focus on dashboard development and reporting.
  • Proven track record designing building and maintaining Power BI dashboards and data models with minimal supervision.
  • Strong proficiency in SQL for querying transforming and validating data in a data warehouse environment.
  • Hands-on experience working with modern data warehouses (e.g. AWS Redshift Snowflake Azure Synapse or similar) and dimensional modeling (star / snowflake schemas).
  • Experience optimizing BI solutions for performance including query tuning model design and Power BI performance best practices.
  • Experience working in Agile or iterative delivery environments is preferred.
  • Prior experience in the recycling industry producer responsibility utilities public sector or other regulated / reporting-heavy environments is an asset
  • Knowledge / Competencies / Skills

  • Advanced Power BI skills including data modeling DAX Power Query row-level security and dashboard UX design.
  • Strong SQL skills with the ability to write efficient maintainable queries and troubleshoot performance issues.
  • Solid understanding of data warehousing concepts dimensional modeling and data governance.
  • Continuous improvement mindset : actively looks for ways to simplify automate and standardize processes and analytics assets.
  • Innovative and curious : brings creative ideas for new metrics visualizations and ways to deliver insights.
  • Excellent communication skills capable of simplifying complex data and analytics findings for non-technical stakeholders.
  • Strong analytical and critical thinking skills with high attention to detail and data quality.
  • Comfortable working in a fast-paced ambiguous environment managing multiple priorities and deadlines.
  • Collaborative team player who builds strong relationships with technical and business partners and contributes to a positive inclusive culture.
  • WORKING CONDITIONS

  • All CM employees work 40 hours per week remotely from a home office environment.
  • PAY TRANSPARENCY

    Expected Compensation :

  • An annual base salary in the range of $80000 to $96000.
  • The salary range listed complies with the Ontario Employment Standards Act andreflectsa potential base salary range for this salaryofferedwillbedeterminedwithin the rangeand willdependonfactors such asthecandidatesunique qualificationsrelevantexperienceworklocationand expected contributions.
  • Job Vacancy Reason

  • This position is anewrole.
  • Artificial Intelligence

  • AIis not usedduringourhiring processes.
  • Applicant andInterviewee Communication

  • We thank all applicants for their interest. However only those under consideration will be contacted.
  • Applicantswho have beeninterviewed will be informed whether a hiring decision has been made within 45 days of their final interview.
  • Record Retention

  • Job posting records and associated application formswill beretainedfor at least three years.
  • ABOUT CIRCULAR MATERIALS

    Circular Materials is a national not-for-profit producer responsibility organization (PRO) that supports producers in meeting their extended producer responsibility (EPR) obligations across Canada. Created by producers for producers Circular Materials develops implements and supports effective and efficient recycling programs to advance innovation deliver improved environmental outcomes and drive value across the recycling supply chain. Our full-service offerings include collection management promotion and education and reporting.

    Together we are advancing the circular economy where materials are collected recycled and can be returned to producers for use as recycled content in new products and packaging. As we develop enhanced recycling systems across Canada we work to ensure more materials are looped into the circular economybenefitingboth people and the environment.

    Learn more at .

    Circular Materials is an equal opportunity employer seeking team members with a diversity of thought skills experiences culture and ethnicityto help us achieve our purpose of accelerating a circular economy for people and the planet. As a national organizationoperatingacross Canada our goal is to build a workforce that reflects the diversity of the many provinces and territories where we do business.

    Our inclusive hiring practices aim to foster a culture where all employees feela strong senseof belonging. We are proud of our recent diversity survey results which showed that :

  • 51% of Circular Materials employees identify as women.
  • 53% of Circular Materials employees identify as visible minorities.
  • 97% of employees believe Circular Materials fostersa strong senseof belonging for employees of all backgrounds.
  • 95% of employees recommend Circular Materials as an inclusive workplace.
  • We welcome applications from candidates of all backgrounds including women Indigenous Peoples (First Nations Inuit and Métis) persons with disabilities racialized individuals and members of part of our commitment to reconciliation Circular Materials is working to advance Indigenous representation and partnerships within our organization and across our acknowledge that Circular Materialsoperateson the traditional territories of diverse Indigenous Nations and we recognize the importance of respecting Indigenous rights governance and contributions in the workplace and beyond.

    Circular Materials supports reasonable requests for accommodationin accordance withall applicable provincial accessibility standards. Requests for accommodation will be provided by Circular Materials through the recruitment and / or assessment processes upon contacting .This email is only used for accommodation requests.

    Required Experience :

    Senior IC

    Key Skills

    Databases,Data Analytics,Microsoft Access,SQL,Power BI,R,Tableau,Data Management,Data Mining,SAS,Data Analysis Skills,Analytics

    Employment Type : Full-Time

    Experience : years

    Vacancy : 1

    Monthly Salary Salary : 80000 - 96000

    Create a job alert for this search

    Senior Analyst Data Insights Optimization Canada • Ottawa, Ontario, Canada

    Similar jobs
    Senior Analytics Engineer - ottawa

    Senior Analytics Engineer - ottawa

    TekRek • ottawa, on, ca
    Full-time
    TekRek has partnered with a fast growing firm specializing in AI enablement and data optimization.Our client works with some of the top tier technology firms in Silcom Valley.With rapid growth and ...Show more
    Last updated: 30+ days ago • Promoted
    Data Analyst

    Data Analyst

    TELUS Digital • ottawa, on, ca
    Full-time
    Be a part of a transformational journey with innovative talent and leading-edge technologies.We’re a customer-driven and product-minded team within TELUS DIGITAL, responsible for key Artificial Int...Show more
    Last updated: 15 days ago • Promoted
    Senior Data Analyst

    Senior Data Analyst

    Lumentum Operations LLC • Ottawa
    Full-time
    Senior Data Analyst page is loaded## Senior Data Analystlocations : Canada - Ottawa (Terry Fox)time type : Full timeposted on : Posted Yesterdayjob requisition id : 20251445It's fun to work in ...Show more
    Last updated: 17 days ago • Promoted
    Senior Business Analyst - ottawa

    Senior Business Analyst - ottawa

    Centrilogic • ottawa, on, ca
    Full-time
    Centrilogic is a leading IT consulting firm serving clients across all industry verticals and the government sector.We specialize in delivering modernization projects, leveraging Microsoft technolo...Show more
    Last updated: 2 days ago • Promoted
    M&A (Analyst / Senior Analyst / Associate)

    M&A (Analyst / Senior Analyst / Associate)

    Harris Computer • Toronto, Ottawa, Montreal (Administrative Region)
    Full-time
    Preference for Toronto, Ottawa or Montreal, but open to remote candidates (within North America).Harris’ public safety portfolio is looking for an M&A professional to help support our acquired grow...Show more
    Last updated: 14 days ago • Promoted
    Senior Business Analyst

    Senior Business Analyst

    Raise • gatineau, qc, ca
    Full-time
    Location : Calgary, Alberta (100% Remote).They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our Client is a market leading financia...Show more
    Last updated: 6 days ago • Promoted
    Senior Data Analyst

    Senior Data Analyst

    Canadian Forces Morale and Welfare Services - CFMWS • Ottawa, ON, Canada
    Full-time
    CFMWS - WHERE PURPOSE MEETS PASSION!.At Canadian Forces Morale and Welfare Services (CFMWS), we’re more than just a workplace. we’re a proud community dedicated to supporting Canadian Armed Forces ...Show more
    Last updated: 2 days ago • Promoted
    Remote Data Architect - Modernize Enterprise Data

    Remote Data Architect - Modernize Enterprise Data

    Orangutech • Ottawa H2B, ON, Canada
    Remote
    Part-time
    A public service organization is seeking an experienced Database Architect for a future opportunity.This role focuses on leading assessments and modernizing the enterprise data ecosystem.Candidates...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Analyst, Customer Success — Forecasts

    Senior Data Analyst, Customer Success — Forecasts

    SurveyMonkey • Ottawa
    Full-time
    A leading survey platform company located in Ottawa is seeking a Senior Data Analyst to shape customer experience and success. The ideal candidate will lead forecast reporting, design scalable repor...Show more
    Last updated: 17 days ago • Promoted
    Senior Intelligence Analyst

    Senior Intelligence Analyst

    Office of the Superintendent of Financial Institutions Canada • Ottawa
    Full-time +1
    Senior Intelligence Analyst Office of the Superintendent of Financial Institutions Canada •Ottawa, Ontario, Canada.National Security Sector Intelligence. Persons residing in Canada and Canadian citiz...Show more
    Last updated: 1 hour ago • Promoted • New!
    Tier I SOC Analyst - ottawa

    Tier I SOC Analyst - ottawa

    CyberClan • ottawa, on, ca
    Full-time
    Tier I SOC Analyst - Job Description.Established in 2006, CyberClan’s carefully selected team of experts are capable of solving complex cyber security challenges – keeping data secure and businesse...Show more
    Last updated: 19 days ago • Promoted
    Senior Business Analyst – DocuSign CLM - ottawa

    Senior Business Analyst – DocuSign CLM - ottawa

    MethodHub • ottawa, on, ca
    Full-time
    Senior Business Analyst – DocuSign CLM.Contract Lifecycle Management (CLM) solutions.The role partners with Legal, Procurement, Sales, Compliance, and IT teams to streamline contract processes, imp...Show more
    Last updated: 2 days ago • Promoted
    Analyst, Settlement and Structured Transactions - ottawa

    Analyst, Settlement and Structured Transactions - ottawa

    Brookfield Renewable • ottawa, on, ca
    Full-time
    Brookfield Renewable, as one of the core businesses under Brookfield Corporation, is one of the world’s largest owners, operators, and developers of renewable power, with $125 billion of power asse...Show more
    Last updated: 19 days ago • Promoted
    Data Analyst - ottawa

    Data Analyst - ottawa

    TELUS Digital • ottawa, on, ca
    Full-time
    Be a part of a transformational journey with innovative talent and leading-edge technologies.We’re a customer-driven and product-minded team within TELUS DIGITAL, responsible for key Artificial Int...Show more
    Last updated: 15 days ago • Promoted
    Senior Data Analyst, Customer Success

    Senior Data Analyst, Customer Success

    Tree Trust • Ottawa
    Full-time
    SurveyMonkey is the world’s most popular platform for surveys and forms, built for business—loved by users.We combine powerful capabilities with intuitive design, effectively serving every use case...Show more
    Last updated: 17 days ago • Promoted
    Data Analyst : AI-Driven Insights & Azure SQL Specialist

    Data Analyst : AI-Driven Insights & Azure SQL Specialist

    Xplore Inc. • Ottawa
    Full-time
    A leading broadband company in Canada is seeking a Data Analyst to enhance reporting and analytics.The role includes developing automated reports, writing SQL queries, and supporting data engineeri...Show more
    Last updated: 16 days ago • Promoted
    Senior Business Analyst - ottawa

    Senior Business Analyst - ottawa

    Raise • ottawa, on, ca
    Full-time
    Location : Calgary, Alberta (100% Remote).They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our Client is a market leading financia...Show more
    Last updated: 6 days ago • Promoted
    Senior Compensation Analyst - ottawa

    Senior Compensation Analyst - ottawa

    Telecon • ottawa, on, ca
    Full-time
    Bien que ce poste soit principalement en télétravail, il nécessitera une présence au bureau 1 à 2 jours par semaine dans nos locaux de Montréal pour la collaboration en équipe et les réunions • •.Tel...Show more
    Last updated: 2 days ago • Promoted