Data and Automation Manager

Energy Trust of Oregon; Portland (OR); Hybrid; USD 133,000 - 213,000; Full time

Benefits offered by this job

Health/dental/vision insurance

401(k) with company contribution

TriMet pass

Flexible work options

Career advancement opportunities

Job summary

Energy Trust of Oregon is seeking a Data and Automation Manager to design and implement enterprise-wide data strategies, analytics, and automation. Under the IT Manager, you will lead a team responsible for data warehouses, ETL, reporting, and AI-driven tools.

The role emphasizes governance, cross-functional collaboration, and scalable solutions to improve data quality and reduce manual effort. Portland-based with hybrid options; open to candidates in Oregon/Washington, quarterly office

Qualifications

• Bachelor’s degree in information technology or related field, or equivalent experience.
• 10+ years in data management or automation with cross-functional impact.
• 3+ years of leadership and people management experience.
• Experience with data engineering, ETL, BI, and enterprise reporting.
• Experience with governance for self-service analytics and AI tools.

Responsibilities

• Lead and mentor data, automation, and reporting technologists.
• Develop roadmaps for data, automation, low-code/no-code apps, and AI initiatives.
• Collaborate with infrastructure and architecture to align platforms and standards.
• Oversee data warehouse, ETL processes, and data structures for analytics.
• Govern AI-driven automation and establish governance frameworks.

Skills

Data management

Automation

Leadership

SQL

Power Platform

AI tools

Governance

ETL

Education

Bachelor's degree in information technology

Equivalent professional experience

Tools

Microsoft Dataverse

Fabric

Power BI

SSIS

ETL platforms

Job description

Position: Data and Automation Manager

Reports to: IT Manager

Compensation: Competitive starting salary $133,400 – $173,400 commensurate with skills and experience, Full Pay Range: $133,400 - $213,300

Energy Trust is committed to pay equity. Energy Trust is committed to fair employment practices and non-discrimination, including pay equity for all employees. We do not discriminate based on protected class (race, sex, veteran status, disability, age, color, religion, national origin, marital status, sexual orientation) in the payment of wages or screen applicants on the basis of their current or past compensation. We determine salary by completing a review of your application materials to evaluate your related education, experience, and training.

*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. The full pay range is included to show the potential earnings for this position with sustained high performance.

Employment Classification: Full Time, Exempt

Anticipated Start Date: As soon as possible, position is open until filled.

Office Location: Portland Metro Area, Oregon, USA

BACKGROUND

About Energy Trust of Oregon

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.

Our Vision

Clean, affordable energy for everyone.

Our Commitment to Diversity

We recognize the lack of diversity in our industry, and we actively seek to address it with our hiring and retention practices as well as our values. We believe every person and their lived experience is integral to building a vibrant culture and delivering effective services to all customers we serve. We are committed to the principles of diversity, equity and inclusion, and we encourage candidates with diverse backgrounds and experience to apply.

Our Location

Energy Trust provides a range of work location options, including remote, hybrid and in-office work. This position will represent Energy Trust in public settings and potentially at community events. We are open to candidates who live throughout Oregon and Washington. The Data and Automation Manager is expected to report to the office on a quarterly basis, at minimum.

What We’re Looking For:

Under the general direction of the IT Manager, the Data and Automation Manager is responsible for designing and implementing enterprise-wide solutions, processes, and standards for data management, processing, reporting, and analytics. This role also drives the streamlining of workflows through effective automation, proactively identifying opportunities across the organization to reduce manual effort, improve data quality, and optimize overall business operations.

The Data and Automation Manager leads the data and automation team and is accountable for delivering scalable, reliable data management and process automation solutions, ensuring they align with organizational strategy and business objectives. This includes oversight of data platforms such as data warehouses, transactional systems data, reporting and analytics systems, low-code/no-code applications, and AI driven tools. The role also establishes governance frameworks for data, reporting, automation, and AI to ensure consistency, security, and responsible use across the organization.

This position is expected to report to the Portland office quarterly at a minimum for all staff and other in-person meetings.

What You’ll Do:

• Lead, mentor, and supervise a team of data, automation, and reporting technologists, fostering a culture of collaboration, innovation, and continuous improvement.
• Set team goals; assign and prioritize work, manage workloads; and conduct performance evaluations in alignment with organizational objectives.
• Partner with Infrastructure, Business Systems, and the Enterprise Architect to align platforms, architecture, standards, and delivery approaches across IT.
• Develop, maintain, and communicate a roadmap for data, reporting, automation, low code no code applications, and AI initiatives.
• Lead staff in partnering with business units to proactively identify, assess, prioritize, and deliver processes improvement and automation opportunities.
• Oversee the design and maintenance data warehouse systems, ETL processes, and data structures for reporting and analytics.
• Oversee the development and management of low code/no code applications, workflows, and integrations.
• Oversee the development and management of AI-enabled automations and AI agents, ensuring appropriate oversight and responsible use.
• Collaborate with IT leadership, the Operations Management Team, and users to establish AI and automation platform governance that meets the needs of the business while ensuring appropriate support, training, culture, guard rails, and risk management is in place.
• Provide vision and oversight for governance of enterprise reporting and analytics platforms.
• Create guidance on appropriate platforms for automation and clear communications for data and automation staff.
• Contribute to and help implement Energy Trust’s Data Strategy, including activities such as use-case development, SWOT analysis, data governance, policy creation, and related initiatives.
• Perform other job-related duties as assigned.
• Perform all functions of the job in a safe manner.

SUPERVISORY RESPONSIBILITY

Supervises and directs the work of IT professionals, including employees and contractors

What You’ll Need:

• Bachelor’s degree in information technology or related field, or equivalent professional experience.

• 10 years of experience in data management, automation, or related technical domains, including responsibility for enterprise or cross-functional solutions.

• 3 years of demonstrated leadership in job or functional role, including people management or technical leadership.

• Demonstrated experience in managing data engineering, ETL, process automation, business intelligence, or enterprise reporting platforms.

• Experience managing governance for self-service user-facing tools like reporting, low code no code, or AI.

• Experience managing or leading technical teams.

• Experience with tools such as SQL, SSIS, ETL platforms, BI/reporting tools, automation tools, Power Platform, or similar tools.

• Experience with modern data and applications platforms such as Microsoft Dataverse, Fabric, or equivalent enterprise platforms.

• Familiarity with AI tools, including Microsoft Copilot or comparable AI solutions.

• Familiarity with governance frameworks and best practices.

• Experience in triaging requests for priority, establishing criteria.

• Experience tracking metrics or KPIs.

• Leadership and mentoring in data, automation, and reporting best practices.

• Ability to work effectively in a collaborative, team-based environment, and the ability to document work for easy understanding for both technical and non-technical users.

What You’ll Get:

• 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
• Great colleagues and culture
• Flexibility to work from home and/or an office space at the Portland, OR location.
• Work from home laptop provided.

Read more about our benefits here.

APPLICATION INSTRUCTIONS:

Please submit a cover letter and resume on Energy Trust’s website

All offers of employment are conditional pending the successful completion of a background check (which may include employment verification, education verification, criminal history, motor vehicle record) and reference checks.

Don’t meet every single requirement? Studies have shown that candidates from certain demographics are less likely to apply to jobs unless they meet every single qualification—for example, women and People of Color. At Energy Trust we are dedicated to building a diverse, inclusive and authentic workplace—if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply. You may be the right candidate for this or other roles.

Energy Trust of Oregon is committed to providing equal employment opportunity for all persons regardless of race, color, religion (including religious dress and grooming practices), sex, sexual orientation, gender, gender identity, gender expression, age, marital status, national origin, ancestry, citizenship status, pregnancy, medical condition, genetic information, mental and physical disability, political affiliation, union membership, status as a parent, military or veteran status or other non-merit based factors. We will provide reasonable accommodation throughout the application, interviewing, and employment process. If you require reasonable accommodation, contact us. Energy Trust of Oregon is an E-Verify employer. This policy is applicable to all phases of the employment relationship, including hiring, transfers, promotions, training, terminations, working conditions, compensation, benefits, and other terms and conditions of employment.

Energy Trust is committed to pay equity. Energy Trust is committed to fair employment practices and non-discrimination, including pay equity for all employees. We do not discriminate based on protected class (race, sex, veteran status, disability, age, color, religion, national origin, marital status, sexual orientation) in the payment of wages or screen applicants on the basis of their current or past compensation. We determine salary by completing a review of your application materials to evaluate your related education, experience and training.