Circular Materials · 5 hours ago
Senior Analyst, Data Insights & Optimization - Remote Canada
United States
Full-time
Remote
Mid, Senior Level
$80K/yr - $96K/yr
5+ years expCircular Materials is a national not-for-profit producer responsibility organization that supports producers in meeting their extended producer responsibility obligations across Canada. The Senior Analyst, Data Insights & Optimization will translate complex data into actionable insights, design and maintain Power BI dashboards, and support optimization initiatives through data-driven recommendations.
Environmental Services
Responsibilities
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)
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
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
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
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
Qualification
Required
Post-secondary education / Bachelor's degree in a relevant field such as Engineering, Economics, Business, or a related discipline
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
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
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
Preferred
Experience working in Agile or iterative delivery environments
Prior experience in the recycling industry, producer responsibility, utilities, public sector, or other regulated/reporting-heavy environments
Company
Circular Materials
National not-for-profit producer responsibility organization that serves, represents and supports producers in building more efficient recycling systems.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase