Business Intelligence Analyst

CLEAResult Consulting Inc.

United States

On-site

USD 63,000 - 94,000

Full time

12 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical Insurance
Dental Insurance
Vision Insurance
401(k) matching
Paid vacation
Volunteer time
Recognition program
Employee assistance program
Training courses

Job summary

CLEAResult Consulting Inc. seeks a Business Intelligence Analyst in the Portland, OR area to join the analytics, reporting, and system integrity team for the Online Home Energy Assessment and Online Marketplace platform.

You will partner with program management, marketing, and IT to translate business questions into analysis, monitor platform performance, and ensure data accuracy across systems driving customer interactions.

Qualifications

  • Ability to be a business thought partner, using data analytics to improve program and marketplace performance.
  • Strong analytical and problem-solving skills with understanding of sales, pricing, and program data.
  • Experience with Power BI or similar reporting tools.
  • Experience designing BI solutions for program, marketplace, or sales data.
  • Experience with Magento or similar CMS/e-commerce platforms.
  • Experience with UAT design and execution for system changes.
  • Deep experience with data quality assessment and improvements.
  • Ability to work across multiple platforms and projects.
  • Knowledge of residential building science principles (preferred).
  • Bachelor's degree or 3–5 years of related experience (energy efficiency preferred).
  • Excellent written, verbal, and interpersonal communication skills.

Responsibilities

  • Partner with program, marketing, and IT stakeholders to meet data/reporting needs; be the primary contact for data issues.
  • Monitor transactions and trends; analyze user behavior to identify improvements in recommendations.
  • Create Power BI reports/dashboards to visualize trends; contribute to monthly/quarterly reporting.
  • Conduct ad hoc queries and analysis for teams; support seasonal analyses for content updates.
  • Assist marketing with data pulls and automation of engagement campaigns; inform follow-up offers.
  • Maintain documentation for recommendation tile logic and update content/logic as needed.
  • Manage data quality and integrity of marketplace/program systems; handle sales/discount data cleanup.
  • Forecast product sales across all transactions and discount code usage.
  • Design and lead UAT procedures for system changes to ensure data/reporting accuracy.
  • Provide knowledge transfer and training on reporting functionality and data logic.

Skills

Power BI
Data analysis
Stakeholder collaboration
Problem solving
Data quality

Education

Bachelor's degree

Tools

Magento
CMS

Job description

At CLEAResult, we lead the transition to a sustainable, equitable, and carbon-neutral energy-efficient future for our communities and our planet. We do that by creating a people-first culture built on trust, accountability, and transparency; where every employee – regardless of position, role, or identity is treated with respect and given an equal chance to thrive.

Benefits
  • Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours
  • 401(k) with company match
  • Paid vacation, sick, personal and parental leave time
  • Paid Volunteer Time: giving back to our communities is important to us
  • Employee Recognition Program – convert your recognition points into gift cards
  • Employee Assistance Program – offers benefits to help you manage daily responsibilities
  • Access to on-demand training courses to advance further in your career
Job Description

Ideally seeking candidates in the Portland, OR area to have the ability to commute to the office for monthly team and client meetings.

We are seeking a Business Intelligence Analyst to join the team responsible for the analytics, reporting, and system integrity behind our Online Home Energy Assessment and Online Marketplace platform. In this role, you will partner with program management, marketing, and IT stakeholders to understand data and reporting needs, monitor platform performance, and maintain the accuracy of the systems and content that drive customer interactions. You will translate high-level business questions into analysis and reporting, pulling data from multiple systems to evaluate home assessment recommendation logic, marketplace pricing trends, and program performance. In this role you will present findings that help management ensure the platforms deliver value to clients and homeowners and will coordinate with multiple initiative managers across our local team.

Primary Responsibilities
  • Proactively partner with program, marketing, and IT stakeholders to ensure data and reporting needs are met, serving as the primary point of contact for data and reporting issues.
  • Monitor Assessment and Marketplace transactions and trends, analyzing user behavior to identify improvement opportunities in recommendation content or logic.
  • Create Power BI reports and dashboards that visualize Assessment and Marketplace trends for management, and contribute to monthly and quarterly reporting deliverables.
  • Conduct ad hoc queries and analysis for program and marketing teams, including seasonal analysis to support timely updates to Assessment content.
  • Support marketing with data pulls and automation of Assessment re-engagement campaigns, applying knowledge of survey logic and customer grouping to inform follow-up offer recommendations.
  • Maintain reference documentation for current recommendation tile logic, and manage content and logic updates within the platform to ensure accuracy.
  • Manage the ongoing data quality and integrity of marketplace and program systems, including sales records, discount code data, and data clean-up and sync requests.
  • Forecast product sales across all transactions and discount code usage on the marketplace.
  • Design and lead UAT procedures for Marketplace and Assessment system changes to validate data and reporting accuracy before deployment.
  • Provide knowledge transfer and training to other team members on core reporting functionality and data logic.
Education, Experience and Skills
  • Ability to be a business thought partner, finding ways to use data analytics to improve program and marketplace performance.
  • Strong analytical and problem-solving skills with an understanding of sales, pricing, and program data.
  • Experience with Power BI or similar reporting/analytical applications.
  • Experience designing business intelligence solutions for program, marketplace, or sales data.
  • Experience with Magento or similar CMS/e-commerce platforms preferred.
  • Experience with UAT design and execution for system/platform changes preferred.
  • Deep experience with data quality assessment and implementing solutions to improve data quality.
  • Demonstrated ability to work across different platforms and applications, participate in multiple projects, and solve technical and business problems.
  • Knowledge of residential building science principles preferred.
  • Bachelor's degree or 3-5 years of relevant work experience, with preference given to work in energy efficiency or a related field.
  • Excellent written, verbal, and interpersonal communication skills.
Target Compensation :

$80,000/annual

DOT Requirements

If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations.

Compensation Range
  • $62,700.00 - $94,100.00
  • Currency
  • USD
  • Type
  • Salary
Equal Opportunity Employer

As an Equal Opportunity Employer, we are committed to ensuring equal employment opportunities for all job applicants and employees.Employment decisions are based upon job-related reasons regardless of an applicant’s race, color, religion, national origin, marital status, age, sex, gender identity, sexual orientation, status as a qualified individual with a disability or protected veteran, or any other protected status.

The above job description and job requirements are not intended to be all inclusive.CLEAResult retains the right to make changes or adjustments to job descriptions and/or requirements at any time without notice.

CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students. Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. Successful hires must pass pre-employment checks.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Residential Energy Auditor
Residential Energy Auditor

CLEAResult • Bridgeville

On-site
USD 26,000 - 39,000
Medical, Dental, and Vision Insurance
Company-paid health care concierge
401(k) with company match
+5
Energy Advisor
Energy Advisor

CLEAResult • United States

Remote
USD 27,000 - 38,000
Medical, Dental, Vision Insurance
401(k) with company match
Paid vacation, sick, personal and par­
+4
IES Program Specialist
IES Program Specialist

CLEAResult • United States

Remote
USD 49,000 - 55,000
Medical, Dental, and Vision Insurance
401(k) with company match
Paid vacation, sick, personal and Par*
+4
Bilingual (English/Spanish) Energy Services Program Specialist
Bilingual (English/Spanish) Energy Services Program Specialist

CLEAResult • Utah

Remote
USD 50,000 - 56,000
Health Insurance
401(k) Match
Paid Leave
+4
Bilingual (English/Spanish) Energy Services Program Specialist
Bilingual (English/Spanish) Energy Services Program Specialist

CLEAResult • Oregon

Remote
USD 49,000 - 66,000
Medical, dental, and vision
401(k) with company match
Paid vacation, sick, personal, and Par
+4
Residential QA&QC Specialist
Residential QA&QC Specialist

CLEAResult • City of White Plains (NY)

On-site
USD 33,000 - 49,000
Medical, Dental, and Vision Insurance
401(k) with company match
Paid vacation, sick, personal and parE
+4
Community Outreach Specialist & Home Energy Advisor (Central Oregon)
Community Outreach Specialist & Home Energy Advisor (Central Oregon)

CLEAResult • Oregon

Hybrid
USD 75,000 - 85,000
Health insurance
Health care concierge service
401(k) with company match
+4
Energy Technician II
Energy Technician II

CLEAResult • North York

On-site
USD 25,000 - 34,000
Health insurance
401k with company match
Paid vacation
+5
Residential Energy Auditor
Residential Energy Auditor

LE0005 CLEAResult Consulting Inc. • Bridgeville

On-site
USD 26,000 - 39,000
Medical, Dental, and Vision Insurance
401(k) with company match
Paid vacation, sick, personal and Par­
+4
Energy Rating Specialist
Energy Rating Specialist

CLEAResult • United States

Remote
USD 64,000 - 88,000
Medical, Dental, and Vision Insurance
401(k) with company match
Paid vacation, sick, personal and par­
+4