WIT Scientist/Database Programmer II

Brief Description

Position Summary

• Performs moderate engineering tasks with standard techniques.
• This position will focus on the application of digital technology (databases and programming) to projects across all of LRE Water’s service areas, supporting the development of client-facing analytical tools, numerical and spreadsheet models, data visualization tools and data management systems.
  
  

Essential Functions

Technical

• Environmental data collection and analysis including but not limited to, streamflow, water quality, groundwater monitoring, GIS data and biological surveys.
• Provide data collection and processing support including writing scripts for automation and leveraging of APIs, as well as manual and scripted. manipulation of data in spreadsheets and text files of varying formats.
• Transfer data between formats to make it more appropriate for analysis and reporting.
• Execute SQL programming tasks to support building, maintaining and automating relational database systems (using PostgreSQL and plpgSQL).
• Under direction of the lead database programmer, build new PostgreSQL database servers, databases, tables, views and functions (using pgAdmin, dBeaver, or similar open source client tools).
• Under direction of the lead database programmer, update existing PostgreSQL database content (tables, views, functions, etc) in response to client requests.
• Create and maintain documentation for processing, systems architecture and access credentials, including creation and maintenance of entity relationship diagrams.
• Implement testing and review procedures to ensure consistency and conformity of data.
• Work with various team members to support their data and database needs.
• Other duties as assigned.
  
  

Project Management

• Understand the scope of services as outlined in project contract and identifies when/if client requests are out of scope, communicating with supervisor accordingly.
• Monitors project deadlines as it relates to deliverables within one’s responsibilities.
• Complete work products and procedures in time allotted.
• Prepare status updates on assigned tasks.
  
  

Business Development

• Connect locally with relevant networks to build a network of professional connections. Participate in presentations where applicable.
• Provide technical support for proposal development.
  
  

Leadership / Management

• Oversee team onsite
• Demonstrate continuous effort to improve operations, decrease turnaround times, and provide a high quality of customer service.
• Possess a desire for lifelong learning.
  
  

Financial Acumen

• Understands accurate timekeeping and the importance for project performance and budgets. Assist management with monitoring due dates and utilization of resources with the goal of project profitability.
• Understands project budget and how to manage within it.
• Understands how much time is available to complete each project.
  
  

Client Service

• Interact professionally both internally and externally. Communicate with clients as designated by the PM and assist with coordinating schedules with client.
  
  

Educational And Other Requirements

Years of Experience

• 2 years.
  
  

Licensure/Certification

• Valid Driver's License, EIT (if applicable), and task specific.
  
  

Degree

• Bachelor's degree and/or equivalent experience.
  
  

Software Capability

• Engineering software, Microsoft Suite, Google Earth, Company Software (ERP, CRM, HRM etc.), arcGIS and programming where applicable.
• Familiarity with relational databases required.
• Familiarity with the PostgreSQL database platform preferred.
• SQL programming experience preferred.
• Python and/or R programming experience preferred.
• General experience with GIS and spatial data manipulation preferred.
• Familiarity with React and JavaScript for web programming helpful.
  
  

Total Compensation

The starting range for this position is $34.86 - $54.86 per hour depending upon years of experience and education. Pay is negotiable for a higher level of experience. LRE Water reserves the right to pay more or less than the posted salary range depending on experience. LRE Water also distributes bonuses and 401(k) contributions based on annual company profitability.

Employer paid benefits increase total compensation by approximately 20%. Additionally, LRE Water supports training and professional development activities for all staff and offers discretionary bonus opportunities as recognition for performance, earning a professional credential, speaking engagements or publication.

Flexible/Hybrid Work Options

LRE Water offers a hybrid work environment that promotes flexibility and encourages work/life balance for our employees. This role will be based out of our Denver office, with the option to work from home one day per week.

Travel Requirements

Although rare, some travel opportunities may be available to visit satellite offices across the United States.

Equal Employment Opportunity

LRE Water is dedicated to the principles of equal employment opportunity and promotes a work environment that does not discriminate against employees or job applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, marital status, genetics, ancestry, or status as a protected veteran. LRE Water validates the right to work using E-Verify.

Disability Accommodations

If you need assistance or reasonable accommodation to complete an application on our website, please contact employment@lrewater.com. As a reminder, we do not accept applications by email.

Physical Demands and Work Environment

The physical demands described here are representative of those that must be met by a staff member to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the functions. Reasonable accommodation may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the staff member is regularly required to talk or listen. The staff member frequently is required to use hands or finger, handle, or feel objects, tools or controls. The staff member is occasionally required to stand; walk; sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The staff member must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.

Professional Development

LRE Water values professional development and continuous improvement, such as:

• Unlimited advancement into project and client management roles
• Working towards and obtaining professional registrations
• External technical training courses
• Internal training sessions (Lunch & learns, spring seminar, etc.)
• “On the job” field and/or project training
• Professional registration continuing education activities
• Conferences
• Mentoring
• Project management
• Business & client development
• Professional societies & organizations leadership activities (e.g., committee & board activities)
• Internal committees/leadership activities
• Communication skills (e.g., public speaking, presentations, technical writing)
  
  

Other Information To Consider

• The job description is only a summary of the typical functions of the job, not an exhaustive or comprehensive list of all possible job responsibilities, tasks, and duties. The responsibilities, tasks, and duties of the jobholder might differ from those outlined in the job description and other duties as assigned might be part of the job.
• This job description does not constitute an employment contract; the employment relationship between the organization and the staff member is an at-will relationship.
  
  

This position has no deadline to apply.