RRC - Programmer V

Job Description

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/.

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

The Information Technology Services (ITS) Division is seeking a talented and motivated Programmer/Developer to join our team. As a Programmer/Developer, you will be responsible for designing, developing, and implementing solutions using your conventional programming skills on ESRI's suite of software products. The ideal candidate will have a strong background in software development, with a desire to learn how to program and work with spatial data to solve complex problems.

Job duties involve, building web applications with JavaScript, C#, Python, or .NET, creating, and modifying web services, working with the ESRI ArcGIS SDK's, and consuming other RESTful APIs. Additional tasks include migrating data from Oracle to SQL Server, automating workflows with Python scripting, and working with geodatabases to manipulate spatial data, manage versioning, and create database objects. Responsibilities also include programming using the .NET or Python SDK's, APIs, and assisting with ESRI server upgrades.

The candidate will also be ensuring compliance with applicable policies, administrative codes, and statutes, updating a permit database, and some independent prioritizing of their assignments. They will perform highly complex (senior level) programming and application development work. Work involves coordinating the input and manipulation of data to create, maintain, display, update, and produce accurate maps and other representation of data.

Work is performed under the supervision of the GIS Manager & Data Reporting/Data Science Manager, with direction from the GIS Lead, along with the Chief Data Officer, with considerable latitude for the use of initiative and independent judgment. This is the opportunity for an excellent and seasoned programmer and developer to learn to work with GIS and more complicated Spatial data.

Essential Job Duties

• Performs highly advanced (senior level) computer programming work. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. Employees at this level may independently perform the most complex programming work and review and evaluate programming efforts concerning system requirements.
• Database: Work with your knowledge of Oracle Databases or Microsoft SQL for the storage and management of spatial data. Craft queries to update or retrieve data including spatial data and ensure data integrity, performance, security, and scalability. Develop geospatial databases, manipulate spatial data, manage versioning, create and modify triggers, and understand database sequences.
• Automation and Scripting: Automate data workflows using the latest Python 3.x scripting and C# for data processing, data transactions, and spatial analysis
• API's: Use or create within a Service Oriented Architecture (SOA) framework, automating real-time data interfacing and exposing GIS Web Services via the ArcGIS REST API. Work with MuleSoft API's and integrate GIS with other applications including SalesForce.
• GIS Application and Web Development: Design, develop, and maintain GIS applications using ArcGIS Pro, ArcGIS Online, and ArcGIS Enterprise. Implement geoprocessing tools, custom widgets, and extensions with ArcGIS Pro SDK for .NET using Microsoft VS 2022. Build and maintain compelling and engaging GIS apps with ArcGIS Maps SDK for JavaScript.
• Spatial Data Integrations: Digitize and maintain spatial databases of relevant information, document procedures (SOPs), support documentation of interfaces (Interface Control Documents-ICDs), validate data for accuracy and completeness, complete approved metadata forms, and produce maps of the resulting information. Integrate spatial data from various sources and formats including shapefiles, remote sensing and equipment data results, GPS data, and other external datasets.
• GIS Data formats: Expand the use of GIS data formats including GeoJSON, personal GeoDatabases, Shapefiles, KML, GeoTIFF, and Open Standards for storing GIS Data.
• Geospatial Analysis: Creates and modifies maps, graphs, or diagrams using geographic information system (GIS)tools and techniques. Perform complex geospatial analysis using ESRI geoprocessing tools to support business decisions and provide valuable insights to stakeholders.
• GIS Technical Support: Provide 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 in GIS functions and provide direction to others.
• Performs related work as assigned.

For Military Crosswalk information, please visit: Military Crosswalk for Occupational Category - Information Technology (texas.gov)



Qualifications:

Minimum Qualifications

• Bachelor's degree in computer science or computer information systems.
• 6+ years' of Software Programming and development experience in languages including C#, VB.NET, Java, or JavaScript within a web development framework using object-oriented programming.
• 4+ years' experience working with databases, such as Oracle, SQL Server, or Postgres SQL.
• 4+ years' experience creating, writing, and consuming RESTful API's.
• 2+ years' experience working with Python or other object-oriented scripting language.
• Valid Texas Driver's License and good driving record.
• Education and experience may be substituted for one another on a year per year basis.

Preferred Qualifications

• Bachelor's degree in computer science or computer information systems and a master's degree in geography or geographic information systems technology.
• Experience working with geodatabases, Spatial data or PostGIS or focusing on geospatial data manipulation and versioning is a plus.
• 7+ years of GIS-related Programming experience in languages including C# and JavaScript within a web development framework.
• 5+ years' programming experience using Environmental Systems Research Institute (ESRI) GIS products including ArcGIS Pro, ArcGIS Online, and ArcGIS Enterprise.
• 5+ years' experience with Python preferred using Python v>3.8+.
• 4+ years ArcGIS Server web services, ArcGIS API for JavaScript, ArcPy, etc. preferred.
• Experience with cloud-based platforms (e.g., AWS, Azure) and serverless computing very desireable
• Experience working with the ArcGIS Pro Pipeline Referencing or Utility Map library and functions is a huge plus
• ESRI Technical Certification (e.g., ESRI ArcGIS Desktop Entry, ESRI ArcGIS Developer Associate).
• Experience in oil, gas, or pipeline regulatory functions.
• 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, 8AM - 5PM with occasional flexible hours, weekends.
• Position requires occasional overnight travel.

Work Hours and Telework: Standard office hours for Commission employees are 8:00 a.m. to 5:00 p.m., Monday through Friday. Our agency offers alternate schedules for employees, as long as it does not adversely affect operations and service levels, and standard hours of operation are maintained. The Commission may also offer telework based on the agency's approved Telework Plan. Alternate work schedules and telework 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.

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 for 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.