Business Intelligence Analyst

CLEAResult is seeking a Business Intelligence Analyst to support analytics, reporting, and system integrity for its Online Home Energy Assessment and Online Marketplace platforms. The role partners with program, marketing, and IT stakeholders to analyze performance, maintain data and platform accuracy, and deliver reporting and insights.

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

Requirements:

• 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
• 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
• Bachelor's degree or 3-5 years of relevant work experience
• Excellent written, verbal, and interpersonal communication skills
• Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support
• Experience with Magento or similar CMS/e-commerce platforms preferred
• Experience with UAT design and execution for system/platform changes preferred
• Knowledge of residential building science principles preferred
• with preference given to work in energy efficiency or a related field