Energy Trust of Oregon is hiring a Sr. Database Developer

Position: Senior Database Developer Reports to: Data and Automation Manager Compensation*: Competitive starting salary $116,900 - $150,800 commensurate with skills experience, Full Pay Range $116,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 BACKGROUND 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 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 Senior Database Developer would be expected to report to the office on a quarterly basis, at minimum. What We’re Looking For: Under the general supervision of the Data and Automation Manager, the Senior Database Developer manages the development and deployment of data processing systems and interfaces to support the business process. This role focuses on database development, including translating user stories into well-defined solutions through analysis, coding, testing, and deployment. The Senior Database Developer will act as the technical lead on complex projects involving single and multiple systems’ databases. They will support strategic database vision and technical decisions, complete proof of concept projects for introduction of changes to architecture and provide technical guidance to other members of the Information Technology team to ensure consistency and best practices in our database implementations. This individual works as part of the IT team and uses proven 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 minimum for all staff and other in-person meetings. What You’ll Do: • Analyze the needs of the organization and produce an effective database system by collecting data, analyzing the data, designing algorithms, and implementing code. • Work with other developers, business systems analysts on the team to provide well-recognized solutions to front and back-end business application requirements. • Serve as development DBA including technical leadership for database architecture and SQL development, in collaboration with production DBA’s. • Participate in sizing of user requests and planning for sprints as part of the Agile development process • Code and test new system functionality following established standards and procedures, with deliverables to include code builds and appropriate documentation. • Build and coordinate production deployment packages and implementation plans for scheduled systems enhancements. • Participate in internal testing to identify problems early, perform error and stress scenarios. • Identify and recommend refactoring opportunities where increased automation, performance enhancements, application enhancements and quality enhancements may be incorporated. • Provide analytical support, database support, and maintenance support for data systems. • Leverage experience to lead work in the areas of data extraction, transformation, and load, as well as data mapping. • Run performance testing procedures to ensure the proper operations of a database. • Create and maintain documentation of database systems. • Develop complex software involving all technical aspects of a solution including business rules, integrations, and database design & implementation. • Provide technical leadership through creation of technical standards and mentoring of both internal and contract software developers and end-user subject matter experts in technical approaches. • Using industry best practices, create technical designs and strongly influence technical architecture, considering current and future applications. • Make recommendations for how best to leverage technologies within the architecture. • Working with Analysts, translate business and functional requirements into documented technical specifications. • Monitor industry trends and make recommendations for how best to leverage Microsoft or other new technologies within the architecture. • Respond to end user issues and find solutions within the prioritization framework. • Perform other job-related duties as assigned. • Perform all functions of the job in a safe manner. SUPERVISORY RESPONSIBILITY This position has no supervisory responsibilities.