Prince William County Service Authority Looking for Data Technician II at Woodbridge, VA  Full Time

Perform advanced data creation, update, and maintenance using the Service Authority’s Asset Registry workflows. Serve as senior data technician and assist, mentor, and review the work of team members within the department of Enterprise Asset Management (EAM). Perform a myriad of progressive technical tasks in support of EDM, Records, and / or GIS Administration programs assisting with varying technical projects using industry recognized best practices.

• Possess all items listed in the Data Technician I Job Description.
• Demonstrate basic understanding of line of business (processes and workflows) for various SA divisions as designated.
• Respond to internal and external customer requests for mapping products, gather customer requirements and prepares cartographic and records information for delivery.
• Create complex spatial and tabular visualizations and inform visualizations in SA’s apps and dashboards (i.e., well-constructed summary reporting via appropriate graphing, cartography (map products), and tableau dashboard summaries).
• Develop spatial database tables for testing, analysis or map creation.
• Use agile methodology for sprint cycles.
• Conduct software testing as related to EAM software development.
• Identify and trace water and sewer networks (i.e., identify areas affected if a valve is shut down).
• Identify OFI’s and draft associated PDCA documents for key work processes.
• Configure editing templates and MXDs to auto populate information for various tasks.
• Perform tasks assigned in continuous improvement process (Kaizen – GIS Web App Improvement Cycle).
• Create quality control inspection and testing plans for other divisions for structured and unstructured data.
• Conduct software training individual and/or group classes.
• Demonstrate the following project lead/management skills and abilities:
  • Lead specific tasks and delegate activities within a project life cycle;
  • Identify risks and dependencies in projects, and between operational tasks and ongoing projects;
  • Work independently to breakdown tasks in a project life cycle into activities, schedules (i.e., plan durations), etc.; and
  • Lead and facilitate collaborative, productive, and efficient project group meetings.

• Perform, improve, and document full production key business process.
• Develop SLAs and SOPs for GIS Production processes.
• Administer ArcGIS Data Reviewer (i.e., develop checks, run tests, enable extensions, create databases).
• Participate in record review meetings (i.e., offer ideas, suggestions, findings).
• Review and adjust CAD files (i.e., adjusting their projection) as needed by department.
• Consult updated Utility Standards Manual as reference material for GIS editing.
• Validate GIS or CMMS data against business logic related to collection and distribution networks (i.e., tee main size, sewer flow direction is wrong).
• Identify and document system-wide data inconsistencies for review.
• Write simple scripts using Python and PSQL that perform a single task.
• Demonstrate knowledge of database design best practices including how to design for the three degrees of cardinality.
• Set up a versioning workflow in the test database to test tools and new workflows.

• Develop SLAs and SOPs for records processes.
• Perform complex records revisions.
• Adjust, improve and document task management tools and workflows related to records processes.
• Develop SOP and SLAs for Records processes.
• Perform CIP related records work.
• Perform records projects and process creation and improvement related to vertical assets.

• Configure database clients successfully (Oracle: Instant/Full).
• Perform installations and configurations of ArcGIS desktop software.
• Use Oracle Apex (i.e., setup); SQL Developer, TOAD, SQLPlus, PyWin; and LucidChart, Visio, GitHub (i.e., diagramming).
• Publish varying services using ArcGIS Server.
• Share online content using ArcGIS Pro or ArcMap to ArcGIS Online or ArcGIS Portal.
• Conduct advanced data analysis (i.e., spatial and tabular analysis).
• Conduct QAQC of data from CWX records to determine workload and issues.
• Conduct analysis generating decision-making information between systems.
• Write and develop simple scripts using Python and PSQL that perform a single task.
• Create and/or refine existing graphs and charts using Tableau.
• Demonstrate knowledge of database design best practices including how to design for the three degrees of cardinality.
• Set up a versioning workflow in the test database to test tools and new workflows.
• Develop SOPs and SLAs for GIS Admin processes (Kaizen, and Web Application Development and Maintenance).

• Associate’s degree in Geography, GIS, Engineering, Computer Science (or related field) or four years of relevant experience (i.e., GIS, CAD, GPS).
• At least two years of relevant experience.
• Demonstrate knowledge of geodatabase versioning workflows and the ability to learn and demonstrate SDE versioning data flows.
• Demonstrate knowledge of EAM’s data quality management plan and the flow of data from the GIS Database to the master data repository and /or GIS App data repository.
• Or combination of education and experience as described above.

• Bachelor’s Degree in Geography, GIS, Engineering, Computer Science (or related field).

Special Requirements:

• This position may require some travel (including for training, conferences, meetings, or other work-related needs).Must have access to reliable transportation for such travel.

Reporting to this Position:

• None

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Physical demands: The work is mostly sedentary with periods of light physical activity. Typical positions require workers to stand for short periods; lift and carry up to 20 pounds; climb stairs, bend, reach, hold, grasp, and turn objects; and operate computer or typewriter keyboards. The work requires the ability to speak normally and to use normal or aided vision and hearing.
• Work environment: Primary work is performed indoors in a standard office setting. The noise level in the work environment is usually moderate. Work is subject to frequent interruptions.

The qualifications listed above are intended to represent the minimum skills and experience levels associated with performing the duties and responsibilities contained in this job description. The qualifications do not express absolute employment or promotional standards. They are general guidelines that should be considered along with the job related selection or promotional criteria.