Business Intelligence Analyst

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.
Additionally, you will enjoy:
• 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

Any offered salary is determined based on internal equity, internal salary ranges, market data/ranges, applicant’s skills and prior relevant experience, certain degrees and certifications (e.g. JD/technology), for example.

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.

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.