Enterprise Data Architect

Role Overview

• 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

Tech Stack

• Azure
• Cloud
• MS SQL Server
• SQL
• SSIS

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