Additional Info

Support a cloud-based data ecosystem with appropriate security and accessibility

Creates and reviews database schema designs and scripts

Database performance monitoring and tuning

Build, test, and maintain database pipelines

Create data validation and quality tools

Ensure compliance with data governance and security policies

Maintain data dictionary and data specifications

Analyzes complex business needs presented by the user community and/or clients and
recommends technical solutions.

Perform liaison duties between users, operations, and programming personnel in the
areas of database design, modifications or trouble shooting.

Collaborates in creating information technology solutions to support and meet
organization objectives using the latest industry-standard technology and practice.

Implement procedures for maximum efficiency and cost containment.

Ensure users/customers are provided professional, courteous, and timely support and
service.

Stays abreast of technology trends and regulations to ensure effectiveness and data
compliance.

Performs other related duties assigned by management.

This position requires an individual who works with considerable collaboration and flexibility in a complex day-to-day environment. The ability to create software development plans and reasonable deadline estimations. Strong attention to detail, accuracy, professional discretion, and sensitivity to confidential information; a record of effective teamwork and relationship building across a stakeholder network is required.

Technical Know How
• Technically fluent in Microsoft’s Structured Query Language (SQL), including query optimization, architecture optimization, and index creation.
• Experience in the use of Azure SQL.
• Experience creating scripts in Python.
• Version control or source code management using GIT.
• Maintain project work plans.
• Investigate, evaluate, and select tools and methods for improving productivity and data quality throughout the life cycle.

Problem solving and appropriate decision making are required in every element of this position. Key duties involve independent judgment regarding analysis of issues and actions required to support day-to-day research and evaluation administration. Actions are governed by broad objectives, professional ethics, university procedures and/or business acumen.

This individual is required to be proficient and conscientious when representing NSWERS and its member organizations. Operational review of desired objectives is often necessary to ensure the research and evaluation administration of the data is accurate. This individual should be mission-driven and deeply committed to the values of NSWERS.

Determined within a relatively short period of time

N/A

This position will be expected to collaborate with individuals and their projects. The ability to advocate ideas, identify and address obstacles is expected, along with the judgment to seek supervision and/or input from others when necessary. This position must have the ability to work as a member of a team, as well as independently, in a complex environment, and with respect for confidential and sensitive information. The candidate should be an optimistic, positive, resilient, insightful, and performance-driven decision maker, problem solver, and consensus builder.

This position reports to the Assistant Director for IT Applications Development and receives moderate, indirect supervision.

No

Office

The noise level in the work environment is usually moderate and there may be frequent interruptions as staff conduct business in cubicles, walled office space and conference rooms.

The employee is required to occasionally travel to and participate in meetings and conferences which may require the ability to drive a motor vehicle and/or stay overnight.