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.

• 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 database development experience throughout the full software development lifecycle. • Demonstrated expertise in MS SSIS. • Expertise in Microsoft SQL Server SSRS. • Advanced experience in MS SQL Server database administration using MS SQL Server Management Studio, and T-SQL programming • Experience in PowerShell scripting. • Experience developing code utilizing data security best practices. • Familiarity with tools or platforms such as Fabric, Data Lakes, and Dataverse, including an understanding of related data workflows, is preferred. • Experience in R scripting is preferred. • Adept at providing software-related customer support and training to a non-technical user base. • Ability to work in a team environment and the ability to document work for easy understanding. • Must have used source control tools such as git to deliver products. • 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. • Must be able 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 The above information is designed to outline the major 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.
• 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 APPLICATION INSTRUCTIONS: Please submit a cover letter and resume on Energy Trust’s website www.energytrust.org/About/careers. 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. www.energytrust.org