RRC - GIS Systems Analyst IV

The Railroad Commission of Texas is a state agency with primary regulatory jurisdiction over the oil and natural gas industry; pipeline transport and pipeline safety; natural gas utilities; the LP-gas industry; and surface mining operations. You can find more details about us on the Railroad Commission of Texas' website here https://www.rrc.texas.gov/about-us/.

Benefits

To support our mission to serve Texas, we need great people to join our team. We provide a great working environment along with outstanding benefits, including:

• Generous paid time off, including vacation, sick time, and at least 12 paid holidays per year
• Telework options for eligible positions
• Flexible work schedules
• Retirement pension with a 150% agency match – you can watch this YouTube video that describes this amazing benefit https://www.youtube.com/watch?v=AJI6M7g73-w
• 401(k), 457(b) and Roth
• Health premiums 100% paid for full-time employees
• Tuition Reimbursement
• Wellness and Exercise Leave
• Career development programs/opportunities for advancement
  
  

For a complete list of our total compensation package, please visit our website at https://www.rrc.texas.gov/about-us/jobs/. To view benefits available to all State of Texas employees, visit the Employee Retirement Systems website at https://ers.texas.gov/benefits-at-a-glance.

General Description

Information Technology Services (ITS) in the Geographic Information System (GIS) Division is seeking a talented and motivated GIS Systems Analyst to join our team. As a GIS Systems Analyst, you will be responsible for assessing existing GIS systems, designing new solutions, and ensuring seamless integration and implementation of GIS solutions using ESRI's suite of software products. You will collaborate with cross-functional teams to create spatially enabled applications, conduct geospatial analysis, and enhance our geospatial data management systems. The ideal candidate will have a strong background in GIS technologies, software development, and a passion for leveraging spatial data to solve complex problems.

Job duties involve GIS mapping of Oil, Gas, Pipeline and Alternative Fuel locations; programming and enhance tools in ArcGIS Pro using the .NET framework; upgrade assistance on our GIS Enterprise server; Python automation and scripting for GIS Data manipulation or in support of workflows; creating and modifying ArcGIS Server web services, working with the ESRI JavaScript API, migrating data processes from Oracle to SQL Server, consuming other RESTful API's, creating and using JavaScript to build or update apps, and using the ArcGIS REST APIs.

The candidate will also ensure compliance with applicable policies, administrative codes, and statutes; update a permit database; and independently prioritize their assignments. They will perform highly complex (senior-level) geographic information system work. Work involves coordinating the input and manipulation of geographic information to create, maintain, display, update, and produce accurate maps and other data representations.

Work is performed under limited supervision from the GIS Manager & Data Reporting/Data Science Manager, with direction from the GIS Technical Lead, and with considerable latitude for initiative and independent judgment.

Essential Job Duties

• Performs highly complex (senior-level) computer systems analysis work. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment. Employees at this level may:
• Coordinate with users to identify system requirements, develop functional design specifications to meet requirements, and solve complex operational problems.
• Coordinate, plan, and schedule the installation of or training for new or revised systems and define business process requirements.
• Prepare and define the system's goals, and devise flowcharts and diagrams describing the logical operational steps of programs.
• Performs Geodatabase Systems Analysis: Design, develop, and maintain GIS geodatabase using ESRI ArcGIS software suite (ArcGIS
  

Pro, ArcGIS Online, ArcGIS Enterprise, and database management systems (Oracle Spatial, Azure SQL Server). This includes ensuring

data integrity, security, and quality standards are upheld.

• Perform Spatial Analysis: Spatial analysis to include data modeling and querying to support project objectives.
• Automation and Scripting: Automate data movement workflows using the latest Python 3.x scripting.
• Use or create API's: With a Service Oriented Architecture (SOA) , automate real-time data interfacing by consuming RESTful MuleSoft API's as well as exposing GIS Web Services via the ArcGIS REST API for consumption by other applications, including Salesforce.
• Database: Work with your knowledge of Oracle Databases or Microsoft SQL to store Spatial data, and craft queries to update or retrieve data, including Spatial data, in these databases. Develop geospatial databases to ensure data integrity, performance, security, and scalability.
• Geospatial Analysis: Creates and modifies maps, graphs, or diagrams using Geographic Information System (GIS) and related equipment. Performs complex geospatial analysis using ESRI tools and techniques to support business decisions and provide valuable insights to stakeholders.
• Spatial Data Integrations: Digitizes and maintains spatial databases of relevant information; documents procedures (SOPs); supports documentation of interfaces (Interface Control Documents-ICDs); validates data for accuracy; completes approved metadata forms; and produces maps of the resulting information. Integrate spatial data from various sources and formats, including shapefiles, remote sensing, equipment data results, GPS data, and other external datasets.
• GIS Data formats: Expand your existing knowledge of GIS data formats, including GeoJSON, personal GeoDatabases, Shapefiles, KML, GeoTIFF, and other Open Standards for storing GIS Data.
• GIS Technical Support: Provides administrative and technical assistance related to permitting for the public, agency staff, and government and elected officials; answers questions and explains permit regulations; and provides information regarding permit processing, policies, and procedures.
• May work as a lead worker, providing consulting on GIS functions and direction to others.
• Performs related work as assigned.
  
  

For Military Crosswalk information, please visit: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf

Qualifications

Minimum Qualifications

• Bachelor's degree in computer science, computer information systems, geography, geographic information systems technology, Geomatics, management information systems, or a related field.
• 5 years' experience using Environmental Systems Research Institute (ESRI) GIS products, including ArcGIS Pro, ArcGIS Online, ArcGIS, and Enterprise.
• 5 years' experience in systems analysis, design, and implementation with expert knowledge of geodatabase management, software development, and integration.
• 3 years' experience in geospatial databases (e.g., Oracle Spatial, SQL Server)
• 3 years' experience with cloud-based GIS platforms (e.g., AWS, Azure) and serverless computing.
• 3 years' experience with standard SQL, PL/SQL, Oracle SQL, or T-SQL, and/or Python 3.x
• Valid Texas Driver's License and good driving record
• Education and experience may be substituted for one another on a year-for-year basis.
  
  

Preferred Qualifications

• Bachelor's or Master's degree in geography or geographic information systems technology.
• ESRI Technical Certification (e.g., ESRI ArcGIS Desktop Entry, ESRI ArcGIS Developer Associate).
• 3 years' experience with cloud data warehouse (e.g. Snowflake, Azure SQL Database)
• Knowledge of GIS-based analytics and machine learning techniques.
• Excellent problem-solving skills and attention to detail, as well as strong communication and collaboration abilities.
• Experience in oil, gas, or pipeline regulatory functions.
• Experience working with the ArcGIS Pro, Field Maps, and Survey 123.
• Experience working with Salesforce, Snowflake, and Power BI is preferred.
• Knowledge of the Railroad Commission's rules, policies, and procedures.
  
  

Knowledge, Skills, And Abilities

• Working knowledge and understanding of locational/spatial data systems.
• Proficiency in cartographic principles and data visualization techniques.
• Demonstrate understanding and ability to apply GIS concepts, theories, and principles.
• Ability to write programs and develop user interfaces, menus, and macro-level commands.
• Ability to effectively communicate regulatory information to a variety of audiences (verbal/written).
• Ability to take initiative and work independently.
• Ability to work effectively on a team and collaboratively in a team environment.
• Ability to address issues/concerns in a professional manner.
• Ability to maintain working relationships and communicate technical concepts to non-technical internal/external stakeholders.
• Ability to respond to high-pressure situations and meet changing demands and timelines.
• Ability to learn regulations and standards.
• Proficient in the use of computer systems, utilizing Microsoft Office Suite and database systems.
• Demonstrate excellent organizational, communication, and writing skills.
• Knowledge of office practices; of administrative and technical procedures; and of applicable policies, administrative codes, and statutes.
• Skill in the use of standard office equipment, computers, and computer software.
• Ability to respond to public inquiries in a timely manner; to implement administrative and technical procedures; to interpret applicable laws,
  
  

rules, regulations, policies, and procedures; and to communicate effectively.

• Problem-solving mindset and a passion for using GIS technologies to solve real-world challenges.
  
  

Miscellaneous Requirements

Ability to work Monday-Friday, 8 AM – 5 PM with occasional flexible hours, weekends.

Position requires occasional overnight travel.

Work Environment

Primarily work indoors in an office setting with heating and cooling regulated in a general office environment; noise levels in each work environment range from low to moderate.

Physical Requirements

The physical requirements described here are representative of those required of an employee to successfully perform the essential functions of this job. Ability to reach high and low; open, close, and retrieve files from file cabinets as well as operate the computer keyboard and appropriate office equipment. Must be able to lift, push, pull, and/or carry. The employee is occasionally required to climb or balance, and to stoop, kneel, crouch, or crawl in cramped quarters. Must walk/stand for considerable amounts of time. I have read the aforementioned job description in its entirety and understand its contents. I can perform the essential functions outlined with or without reasonable accommodation under the Americans with Disabilities Act.

Work Hours: Standard office hours for Commission employees are 8:00 a.m. to 5:00 p.m., Monday through Friday. Our agency offers alternative schedules for employees, provided they do not adversely affect operations or service levels and standard hours of operation are maintained. The Commission may also offer telework in accordance with the agency's approved Telework Plan. Alternate work schedules may be discussed with the hiring manager during the interview process.

APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the CAPPS Recruit Prescreening Questionnaire to be considered for the posting. To complete the Prescreening Questionnaire, go to CAPPS Recruit to register or login:  https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en

Remarks

• There is one available position.
• Official transcripts, DD214 or DD1300, copies of license/certifications, or other minimum requirement validations will be requested at the time of the job offer.
• Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa.
• Criminal background checks will be conducted on all final candidates. An applicant who has been convicted of a criminal offense relevant to the position may be disqualified from employment.
  
  

THE RAILROAD COMMISSION OF TEXAS ONLY ACCEPTS ONLINE APPLICATIONS FOR THIS POSTING.

Due to the high volume of applications, we do not accept telephone calls. Only candidates selected to interview will be contacted. Notifications to applicants are sent electronically to the email address you provide.

The Railroad Commission of Texas is an Equal Opportunity Employer and does not

discriminate on the basis of race, color, national origin, sex, religion, age

or disability in employment or in the provision of services.

The Railroad Commission of Texas is a tobacco-free workplace.