Job Closes: 11/10/2024
GENERAL SUMMARY
Manages, reports, analyzes, and visualizes environmental data collected by the organization. Provides data, analyses, visualizations and reports as requested by both internal and external individuals and groups. Provides guidance to other staff for following best practices for collecting, storing, assessing and analyzing data. Generates and communicates data driven solutions and recommendations.
Safety is #1 at the River Authority: We expect every employee: to 1) Strictly follow safety policies, rules, and safe work methods. 2) Promptly correct or report safety hazards or unsafe conditions. Immediately report injuries for prompt diagnosis and treatment. 3) Make regular suggestions for safety process improvements to support continuous safety improvement.
ESSENTIAL DUTIES & RESPONSIBILITIES
The intent of this job description is to provide a representative summary of the major duties and responsibilities performed by employees in this job. Employees may be requested to perform job-related tasks other than those specifically presented in this description.
- Develops and manages new and existing data viewers, visualization reports, infographics and fact sheets. Checks accuracy of data visuals, identifies issues and collaborates with other departments to update and/or modify them.
- Collaborates with all sections of the Environmental Sciences department to ensure data projects are completed accurately and timely. Generates data deliverables in prescribed formats by the Texas Commission on Environmental Quality (TCEQ) and other local and state agencies.
- Serves as a data steward and/or data custodian and participates in departmental and agency wide data management and governance efforts to promote and implement good data management practices.
- Adheres to departmental and agency data management processes and keeps all elements of designated data resources accurate and up to date.
- Edits and updates department databases using Microsoft Structured Query Language (SQL) Server and generates data reports as requested. Conducts data management quality control checks for designated projects.
- Creates and manages task schedules for the Clean Rivers Program data deliverable and monitors the status of scheduled goals. Reviews and comments on Clean Rivers Program administrative documents and standard operating procedures.
- Conducts data quality checks and modifies or updates data as needed. Provides guidance to other departmental staff for following best practices for collecting, storing, assessing, and analyzing data.
- Develops maps, charts and graphics utilizing ArcGIS, PowerBI and other platforms as needed.
- Completes data and map requests for customers as needed.
- Conducts or assists with environmental data analyses as needed.
- Performs related work as required.
SUPERVISORY REQUIREMENTS
- This position does not directly supervise any employees.
MINIMUM QUALIFICATIONS
Required Education and Experience
- An undergraduate degree from an accredited college or university in a STEM field, Data Science, or a related discipline, and six (6) months of progressively responsible experience in environmental data management, analysis, quality assurance, and data delivery; or a related field; or a combination of experience and education that results in the required knowledge, skills, and abilities.
Required Licenses or Certifications
☒ Must have and maintain a valid driver’s license and an insurable driving record.
COMPETENCIES FOR SUCCESSFUL PERFORMANCE OF JOB DUTIES
The requirements listed below are representative of the knowledge, skills and abilities required to successfully perform the essential functions of this position.
Knowledge of:
- SQL Server Management Studio and SQL transactions.
- Computer utilization and techniques for the analysis of environmental data.
- Microsoft Office and ArcGIS, including PowerBI and SharePoint.
- Good data management practices
- Data reporting to state and federal agencies
Skills and Abilities:
- Analyzing and interpreting technical documents, instruction manuals, policies, and procedures
- Communicating orally and in writing to technical and non-technical audiences and stakeholders.
- Problem solving and generating data driven solutions.
- Building power query transformation.
- Developing data collection and data management processes
- Must be able to function in a principle-based organization that has a culture built on character and SARA Core Values of Stewardship, Integrity, and Excellence.
WORK ENVIRONMENT/CONDITIONS AND PHYSICAL DEMANDS
Work Environment and Physical Effort: (check the appropriate box:)
| Physical Effort Requirements |
Work Environment | Sedentary | Medium | Heavy |
Good: Office or similar indoor environment, relatively free from unpleasant environmental conditions or hazards. | ☒ | ☐ | ☐ |
Satisfactory: Occasional exposure to unpleasant environmental conditions and/or hazards. Occasional outside work. | ☐ | ☐ | ☐ |
Disagreeable: Frequent exposure to unpleasant environmental conditions and/or hazards. Majority of work performed outside or with exposure to risk. | ☐ | ☐ | ☐ |
Sedentary: Exerting up to 10 pounds of force occasionally, a negligible amount of force frequently, and/or constantly having to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.
Medium: Exerting up to 35 pounds of force occasionally, up to 20 pounds of force frequently, and/or up to 20 pounds of force constantly having to move objects.
Heavy: Exerting up to 100 pounds of force occasionally, up to 50 pounds of force frequently, and/or up to 20 pounds of force constantly having to move objects.
WORK ENVIRONMENT/CONDITIONS AND PHYSICAL DEMANDS continued
Work Locations: (select one frequency choice for each location listed:)
| Work Environment Locations |
Work Locations: Indicate how often the work requires the employee to be in the following types of environments: | Seldom or Never | Sometimes | Frequently or Often |
Office or similar indoor environment | ☐ | ☐ | ☒ |
Outdoor environment | ☒ | ☐ | ☐ |
Street environment (near moving traffic) | ☒ | ☐ | ☐ |
Construction site | ☒ | ☐ | ☐ |
Confined space | ☒ | ☐ | ☐ |
Vehicle | ☒ | ☐ | ☐ |
Warehouse environment | ☒ | ☐ | ☐ |
Other: (Specify: ) | ☐ | ☐ | ☐ |
Exposures: (select one frequency choice for each exposure listed:)
| Exposures |
Exposures: Indicate how often the work requires the employee to be exposed to the following environmental exposures. | Seldom or Never | Sometimes | Frequently or Often |
Extreme cold (below 32 degrees) | ☒ | ☐ | ☐ |
Extreme heat (above 100 degrees) | ☒ | ☐ | ☐ |
Communicable diseases | ☒ | ☐ | ☐ |
Moving mechanical parts | ☒ | ☐ | ☐ |
Fumes or airborne particles | ☒ | ☐ | ☐ |
Poison ivy, wasps, snakes, and other natural hazards | ☒ | ☐ | ☐ |
Toxic or caustic chemicals or substances | ☒ | ☐ | ☐ |
Loud noises (85+ decibels such as heavy trucks, jack hammers, construction) | ☒ | ☐ | ☐ |
Other: (Specify: ) | ☐ | ☐ | ☐ |
San Antonio River Authority is an Equal Opportunity/Affirmative Action/Pro Disabled and Veteran Employer. We welcome differences in the form of gender, race, ethnicity, disability, geography, socioeconomic status, age, politics, religion, philosophy, sexual orientation, or gender identity.
