Job Details

Position

Enterprise Data Architect

Reports To

Data & Automation Manager

Compensation

Competitive starting salary $133,900 – $167,800. Full pay range: $133,900 - $184,700. Compensation is based on experience, skill set, certifications, and a pay‑equity assessment.

Employment Classification

Full Time, Exempt.

Start Date

As soon as possible; position open until filled.

Office Location

Portland Metro Area, Oregon, USA.

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 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 actively seek to address it through hiring and retention practices that reflect our values. We are committed to the principles of diversity, equity, and inclusion and encourage candidates from all backgrounds and experiences 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 possibly at community events. Candidates may live throughout Oregon and Washington; the Program Manager would report to the office on a quarterly basis at a minimum.

What We're Looking For

Under the general supervision of the Data and Automation Manager, the Enterprise Data Architect will shape and execute the organization's data architecture strategy to enable trusted, secure, and effective use of data in support of Energy Trust's business objectives.

What You'll Do

• Define and support data governance practices, including data quality, stewardship, security, and appropriate use of data assets.
• Define and maintain the organization's enterprise data architecture vision and roadmap, aligned with business priorities.
• Establish and implement data architecture standards, including data modeling conventions, integration patterns, metadata practices, and reference architectures.
• Implement documentation standards and maintain documentation of Energy Trust data assets.
• Collaborate with database developers on hands‑on data architecture and design work for key initiatives, including data warehouses, integrations, and analytics platforms.
• Design and deliver conceptual, logical, and physical data models for transactional, analytical, and reporting systems.
• Create technical designs utilizing best practices and influence technical architecture for current and future applications.
• Maintain a strong working knowledge of business functions and operational processes and how data is generated, used, and reported across the enterprise.
• Assess emerging technologies, platforms, and tools related to data architecture, analytics, and integration, and recommend adoption where appropriate.

Supersive Responsibility

This position has no supervisory responsibilities.

Requirements

What You'll Need

• Bachelor's degree in computer science or related discipline or equivalent professional experience.
• Minimum 7 years of progressive experience in data architecture and data engineering.
• Strong experience designing enterprise data architectures across transactional and analytical systems.
• Ability to develop and maintain conceptual, logical, and physical data models.
• Expertise in defining and applying data standards, naming conventions, and reference architectures.
• Understanding of data governance concepts, including data quality, metadata, stewardship, and lifecycle management.
• Proficiency with relational databases and SQL; familiarity with Microsoft Dataverse or other modern cloud data platforms.
• Advanced experience in MS SQL Server database administration using SSMS and T‑SQL programming.
• Expertise in Microsoft SQL Server SSRS and SSIS development.
• Experience using Microsoft Fabric and Purview for data analytics and governance.
• Experience with source control tools such as Git.
• Collaboration with data engineers, developers, technical analysts, and business analysts to implement architectural designs.
• Strong analytical thinking to balance ideal architecture with pragmatic constraints such as cost, staffing, and timelines.
• Experience guiding data modernization or migration efforts from legacy systems to improved architectures.
• Experience partnering with internal and external stakeholders to gather requirements and design solutions.
• Ability to document architectures, standards, and patterns clearly and concisely.
• Experience in an Agile development methodology; Azure DevOps experience preferred.
• Strong analytical, written, and verbal communication skills.
• Ability to interact with a diverse workforce and be comfortable working in culturally diverse settings.

Benefits

• Health/dental/vision insurance.
• Employer‑sponsored and paid life/disability insurance.
• 401(k) with company contribution of 6% after 90 days.
• 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 at the Portland office.
• 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 are conditional upon successful completion of a background and reference check.

EEO Statement

Energy Trust of Oregon is committed to providing equal employment opportunity for all persons regardless of race, color, religion, sex, sexual orientation, gender identity, age, marital status, national origin, citizenship status, pregnancy, medical condition, genetic information, mental and physical disability, union membership, or other non‑merit based factors. We will provide reasonable accommodations throughout the application process. Energy Trust of Oregon is an E‑Verify employer.

Pay Equity Statement

Energy Trust is committed to pay equity and fair employment practices. We do not discriminate on the basis of protected class in payment of wages or in screening applicants based on compensation history.