Sr. Database Developer

Energy Trust of Oregon•Portland, OR

1d•Hybrid

About The Position

Energy Trust of Oregon is an independent nonprofit organization dedicated to energy efficiency and renewable energy development, serving customers in Oregon and SW Washington. The organization is recognized as one of the 100 Best Nonprofits to Work For in Oregon, with a vision for clean, affordable energy for everyone. Energy Trust is committed to diversity, equity, and inclusion, actively seeking to address the lack of diversity in the industry. The company offers various work location options, including remote, hybrid, and in-office work, and this position may involve representing Energy Trust in public settings and community events. The Senior Database Developer, under the general supervision of the Data and Automation Manager, is responsible for managing the development and deployment of data processing systems and interfaces to support business processes. This role focuses on database development, 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, supporting strategic database vision and technical decisions, completing proof of concept projects for architectural changes, and providing technical guidance to the IT team to ensure consistency and best practices in database implementations. This individual is an integral part of the IT team, utilizing analytical, technical, communication, and collaborative problem-solving skills to maximize the capabilities and use of Energy Trust’s business system, and may perform other IT duties as assigned. The position requires reporting to the Portland office quarterly at minimum for staff and in-person meetings.

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 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.
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.
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.

Nice To Haves

Familiarity with tools or platforms such as Fabric, Data Lakes, and Dataverse, including an understanding of related data workflows.
Experience in R scripting.
Experience using Application Lifecycle Management (ALM) tools – Azure DevOps experience.

Responsibilities

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.

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