Data and Automation Manager

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

Benefits offered by this job

Health/dental/vision

Life & disability insurance

401(k) with 6% match

Transit pass

FSA/HSA

Job summary

Energy Trust of Oregon, Inc. is seeking a Data and Automation Manager to design enterprise-wide data strategies, drive automation, and lead a cross-functional team. You’ll govern data platforms, analytics, and AI-enabled workflows to optimize operations and decision making.

The role reports to the IT Manager and requires collaboration across Infrastructure, Business Systems, and Enterprise Architecture. Portland-based with flexible work options.

Qualifications

• Bachelor’s degree in IT or related field.
• 10+ years of experience in data management, automation, or related domains.
• 3+ years of leadership or technical leadership experience.
• Experience managing data engineering, ETL, BI, or enterprise reporting platforms.
• Experience with governance for self-service reporting, low-code/no-code, or AI.

Responsibilities

• Lead and mentor a team of data, automation, and reporting technologists.
• Set goals, assign work, manage workloads, and conduct evaluations.
• Align platforms and standards with IT and Enterprise Architecture.
• Develop and communicate a roadmap for data, reporting, automation, and AI initiatives.
• Oversee data warehouse, ETL processes, and data structures for analytics.
• Manage low-code/no-code applications, workflows, and integrations.
• Govern AI-enabled automations with responsible use and oversight.
• Collaborate to establish governance for AI and automation platforms.

Skills

Leadership

Data governance

ETL & Data Warehousing

Low-code / no-code

AI automation

SQL / BI tools

Team mentoring

Education

Bachelor’s degree in IT or related field

Tools

SQL

Power BI

ETL tools

Microsoft Dataverse

AI tools

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.

The above information is designed to outline the major functions and position requirements of this job. It does not identify all tasks that may be expected, nor address the performance standards that must be maintained.

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

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 on the basis of 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.