Enterprise Data Architect

Job Description

Job Description

Position: Enterprise Data Architect

Reports to: Data & Automation Manager

Compensation*: Competitive starting salary $133,900 – $167,800 commensurate with skills and experience, Full Pay Range: $133,900 - $184,700

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.

*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

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 for 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 Program Manager would be expected to report to the office on a quarterly basis, at minimum.

Under the general supervision of the Data and Automation Manager, the Enterprise Data Architect is responsible for shaping and executing the organization’s data architecture strategy to enable trusted, secure, and effective use of data in support of Energy Trust’s business objectives.

The Enterprise Data Architect translates business priorities into a coherent enterprise data architecture, defining standards for data models, integration, and analytics across transactional and analytical systems. Working closely with staff across the organization and with external technical and delivery contractors, the Enterprise Data Architect establishes a shared vision for how data is structured, integrated, and governed to improve data quality, decision-making and reporting.

In addition to strategic leadership, the Enterprise Data Architect performs hands-on architecture and design work, including developing conceptual, logical, and physical data models, designing data integration patterns, and contributing directly to key data initiatives. An essential responsibility of this position is owning and working closely with a variety of database-focused projects, processes, tools and systems that accommodate the organization's large, complex datasets (including, but not limited to utility customer information, weather data, financial data, aggregated reporting datasets, and data warehouse ETL processes).

The role balances pragmatism with best practices - implementing standards that fit Energy Trust’s current business model while remaining scalable for future growth. The Enterprise Data Architect acts as both a thought partner and a builder, ensuring that data solutions are well-designed, documented, and sustainable, and that teams across the organization can confidently use data as a strategic asset.

This individual works as part of the IT team and uses proven management, analytic, technical, communication, and collaborative problem-solving skills to help maximize the capabilities and use of the Energy Trust’s business system. This role serves as an integral part of the IT Department and, as such, may be called upon to perform other IT duties.

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

• Define and support data governance practices in collaboration with the Data Governance Committee, 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 data architecture documentation standards and create and maintain documentation of Energy Trust data assets 

•Collaborate with database developers in performing 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 strongly influence technical architecture, considering current and future applications 

•Create and maintain documentation of database application design and architecture 

•Evaluate and make recommendations on business solutions based on knowledge of the organization’s enterprise data architecture goals and objectives

•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

SUPERVISORY RESPONSIBILITY

This position has no supervisory responsibilities.

Requirements

•Bachelor's degree in computer science or related discipline from an accredited college or university or equivalent professional experience in the information technology field. 

• 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 

• Demonstrated ability to perform hands-on data architecture and design work, not just advisory or oversight functions 

• 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 MS SQL Server Management Studio, 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 Microsoft Dataverse or other cloud data architecture 

• Must have used source control tools such as Git to deliver products 

• 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 business stakeholders and IT leaders to gather requirements and design solutions 

• Ability to document architectures, standards, and patterns clearly and concisely 

• Experience in an Agile development methodology. Experience using Application Lifecycle Management (ALM) tools – Azure DevOps experience preferred. 

• Strong analytical skills coupled with good written and verbal communications 

• Ability to interact with a diverse workforce and be comfortable working in culturally diverse settings and groups 

The above information is designed to outline the 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. 

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

· 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

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 accommodations throughout the application, interviewing and employment process. If you require a 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.

*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 earnings potential for this position with sustained high performance.