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

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

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturedata engineeringdata modelingdata governancerelational databasesSQLT-SQLdata analyticsdata modernizationAgile development

Soft Skills

analytical thinkingcommunicationcollaborationdocumentationproblem-solvingstakeholder engagementadaptabilityleadershiporganizational skillsinterpersonal skills

Certifications

Bachelor's degree in computer sciencedata governance certificationsdata architecture certifications