Sr. Database Developer

Energy Trust of Oregon•Portland, OR

4h•Hybrid

About The Position

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.

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, is preferred.
Experience in R scripting is preferred.
Azure DevOps experience preferred.

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