RRC - Programmer V

Please paste the following URL into a browser to view the entire job posting in the CAPPS Career Section: https://capps.taleo.net/careersection/ex/jobdetail.ftl?job00045772 You may apply to the job directly through the CAPPS Career Section. It is not necessary to apply both through Work In Texas and CAPPS Career Section 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?vAJI6M7g73-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 SDKs, 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 SDKs, 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 upda e 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 APIs: 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 APIs 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 APIs. 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 Bachelors degree in computer science or computer information systems and a masters 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