Responsibilities
- 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
Work Arrangement
Hybrid
Additional Information
- 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.
- 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.
