Operations Analyst - Marketing

Energy Trust of Oregon is an independent nonprofit organization dedicated to energy efficiency and renewable energy development. We serve Oregon customers of Portland General Electric, Pacific Power, NW Natural, Cascade Natural Gas and Avista, and SW Washington customers of NW Natural. Year over year, Energy Trust is recognized as one of the 100 Best Nonprofits to Work For in Oregon.

About the role

This position is responsible for providing analytical and process support services for program marketing staff to ensure effective and successful program marketing operations. The Operations Analyst - Marketing will build relationships with marketing staff and other subject matter experts and work as part of a team of analysts to analyze data, generate reports & visualizations, ensure data quality, optimize and monitor marketing campaign performance, promote continuous improvement, track metrics, and support marketing attribution efforts.

This position reports to the Operations Analyst Supervisor and is expected to report to the Portland office quarterly at a minimum, for all-staff and other in-person meetings as scheduled. We are open to candidates who live throughout Oregon and Washington.

Responsibilities

• Support multiple stakeholders within a fast-moving and growing marketing team.
• Support core marketing functions, including creating and reviewing audiences and lists for marketing campaigns, providing input on marketing plans, evaluating and reporting on campaign performance, and validating numbers used in marketing materials.
• Develop and maintain engaging self-service visualizations, reports, and dashboards in Power BI, applying standards for data and report quality.
• Prepare and present data insights targeted to specific audiences, including leadership, business stakeholders, and technical subject matter experts.
• Collaborate with stakeholders to understand their information needs/requirements and deliver solutions aligned to business goals.
• Perform exploratory data analysis to understand utility/value of new and existing data sets.
• Apply domain knowledge to interpret the data.
• Contribute to business systems bug/feature development prioritization by identifying issues and describing their potential risks/impacts for both business and technical audiences.
• Inform and educate marketing teams regarding best practices for uses of data and reporting available to them.
• Develop and maintain an understanding of marketing business processes and how they relate to overall organizational functioning.
• Provide recommendations and input on marketing operations and processes.
• Identify potential process issues and data gaps within the business and champion solutions for them from definition to execution.
• Document existing and new processes in a standard operating procedure format.
• Facilitate meetings with stakeholders to identify business problems and analyze for root causes.
• Perform other job-related duties as assigned.
• Perform all functions of the job in a safe manner.

Requirements

• Bachelor’s degree or equivalent professional experience.
• 2-4 years of professional experience in data analysis, marketing analysis, business analysis, systems analysis, operations analysis, or energy programs. Experience within the energy industry is a plus.
• Experience as a marketing analyst or working with marketing teams is strongly preferred.
• Applied experience using SQL, Power BI, Excel, SharePoint, and MS Office suite. Background in R, app development with R Shiny, or Power Automate is a plus.
• Comfortable working with and analyzing large data sets; interest and skill in data visualization, including producing compelling charts and graphs for varied audiences.
• Detail orientation and statistical, technical, analytical aptitudes.
• Familiarity with continuous improvement or process development practices. Lean experience is a plus.
• Ability to learn and master Energy Trust data systems and reporting tools.
• Must independently manage prioritization and delivery of multiple tasks, incorporating input from stakeholders and teammates.
• Strong interpersonal, written, and verbal communication skills required.
• Successful experience working within multidisciplinary teams.
• Must be able to interact with a diverse and collaborative workforce and be comfortable working in culturally diverse settings and groups.

Benefits

• Health/dental/vision insurance
• Employer-sponsored and paid life/disability
• 401(k) with a company contribution of 6% of your salary after 90 days of employment
• TriMet pass
• Access to health and dependent FSA/HSA accounts
• Generous paid vacation, holidays and sick days
• Paid volunteer hours
• Employee assistance program
• Career advancement opportunities
• Flexibility to work from home and/or an office space at the Portland, OR location
• Work from home laptop provided

Pay

Competitive starting salary of $74,900 - $93,700, commensurate with skills and experience. Full pay range: $74,900 - $112,400. Actual compensation packages are based on several factors that are unique to each candidate, including but not limited to skill set, depth of experience, and certifications in the pay equity assessment to determine equitable salary placement. Candidates should expect compensation offers within the starting compensation range.

Schedule

Full-time, exempt position. This role offers a range of work location options, including remote, hybrid, and in-office work.