Operations Analyst

Jobtailor; Portland (OR); On-site; USD 70,000 - 95,000; Full time

Job summary

Jobtailor in Portland, OR seeks a data analyst to support marketing analytics and data visualization. You will build and maintain Power BI dashboards, analyze marketing campaigns, and present insights to leadership and technical teams.

The role requires 2–4 years of data analysis experience, strong SQL/Power BI skills, and the ability to work with large datasets. Collaboration across stakeholders is essential, with opportunities to influence marketing operations.

Qualifications

• 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.
• 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.

Responsibilities

• Create and maintain engaging self-service visualizations, reports, and dashboards in Power BI, ensuring data quality standards.
• Prepare and present data insights targeted to leadership, business stakeholders, and technical subject matter experts.
• Collaborate with stakeholders to understand information needs and deliver solutions aligned to business goals.
• Perform exploratory data analysis to understand utility/value of data sets and apply domain knowledge to interpretation.
• Contribute to prioritization of bug/feature development by describing risks/impacts for business and technical audiences.
• Educate marketing teams on data reporting best practices and available tools.
• Develop understanding of marketing business processes and their relation to organizational functioning.
• Provide recommendations on marketing operations and processes.
• Identify data gaps and champion solutions from definition to execution.
• Document processes in a standard operating procedure format.
• Facilitate stakeholder meetings to identify problems and analyze root causes.
• Perform other job-related duties as assigned.

Skills

Data Analysis

Power BI

SQL

Marketing Analysis

Interpersonal Communication

Team Collaboration

Education

Bachelor's degree or equivalent

Tools

Power BI

SQL

Excel

SharePoint

MS Office Suite

R

R Shiny

Power Automate

Job description

• 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.

Core Competencies

Demonstrates expertise in data analysis and visualization, particularly using Power BI and SQL, while effectively communicating insights to diverse stakeholders. Proven ability to support marketing operations through data-driven recommendations and process improvements.

Highest-signal resume keywords

• Data Analysis
• Power BI
• SQL
• Marketing Analysis
• Interpersonal Communication

ATS Optimization Keywords

Hard Skills

• Data Visualization
• Statistical Analysis
• Technical Analysis
• Operations Analysis
• Business Analysis
• Excel
• SharePoint
• R
• R Shiny
• Power Automate

Soft Skills

• Detail Orientation
• Analytical Aptitude
• Written Communication
• Verbal Communication
• Team Collaboration

Industry Keywords

• Marketing
• Energy Industry
• Continuous Improvement
• Process Development
• Data Systems

Tools & Technologies

• Power BI
• SQL
• Excel
• SharePoint
• MS Office Suite