RRC - Data Analyst III - Oil & Gas - Administrative Compliance

Job Description

The Railroad Commission of Texas (RRC), recognized as a worldwide leader in the regulation of oil and gas exploration and production, seeks a Data Analyst III to provide data analysis, data management, and research work in the Oil & Gas Division. Major responsibilities include analyzing, maintaining, and enhancing divisions' existing databases, resources, and tools. Creating and reporting KPIs to stakeholders. Performing data cleanup and transformation, including migration of data from existing databases to new databases. Coordinating and communicating as needed with RRC's Information Technology Services Division. Works under general supervision, with limited latitude for the use of initiative and independent judgment.

Essential Job Duties

• Understand and utilize RRC applications to compile and query data.
• Map existing processes and ways to improve them for business users.
• Analyzes data using standard statistical tools, methods, and techniques.
• Consults with internal and external customers to identify user needs.
• Interprets results to identify gaps in data, processes, or applications.
• Cleans and prunes data to discard irrelevant information.
• Create meaningful reports and dashboards for daily/ weekly/ monthly reviews at various levels.
• Assists in developing methods for mitigating data issues by creating and testing User Cases.
• Assists in preparing technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.
• Assists in identifying and interpreting data patterns and trends, and assessing data quality.
• May develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
• May establish and maintain standard work procedures governing the appropriate use of data.
• Performs related work as assigned.
• This position may require some travel.

For Military Crosswalk information, please visit: Military Crosswalk for Occupational Category Planning, Research, and Statistics

Minimum Qualifications

• Graduation from an accredited fouryear college or university with major coursework in Data Science, Business Analytics, Computer Science, Computer Information Systems, Management Information Systems, Mathematics, Statistics, Finance, Geology, Engineering, or a related field.
• Two years (2) of professional experience in process mapping, querying data, data analysis, data management, research, compilation, and reporting work.
• Experience with Cloud and Mainframe applications, SQL, Python, Snowflake, VBA Script, Power BI, CoPilot.
• Ability to work 8:00 AM 5:00 PM Monday through Friday, with occasional flexible hours.
• Experience and education may substitute for each other on a yearforyear basis.

Preferred Qualifications

• Experience querying and analyzing data in SQL, Snowflake, Power BI, MS Excel, and MS Access.
• Experience with Mainframe and Cloud applications, ESRI ArcGIS.
• Experience in creating and/or testing User Cases.
• Experience in regulatory operations.
• Knowledge of the Railroad Commission's rules, policies, and procedures.

Knowledge/Skills/Abilities

• Knowledge of statistics and analyzing data sets; of running queries, report writing, and presenting findings; of data models, database design development, data mining, and segmentation techniques; and of record keeping, including security procedures for handling, protecting, and distributing data.
• Knowledge of professional office procedures and protocol.
• Skill in the use of a computer and applicable software, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.
• Skill in communicating effectively verbally, in writing, and through visual aids.
• Skill in organizing information.
• Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail.
• Ability to plan and coordinate projects.
• Ability to work independently and on a team.
• Ability to maintain professional appearance and demeanor.
• Ability to discern colors and read diagrams, charts, maps, and reference materials.
• Ability to work MondayFriday, 8:00 AM 5:00 PM with occasional flexible hours and weekends.

Additional Information

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 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 Prescreening Questionnaire to be considered for the posting. To complete the Prescreening Questionnaire, go to CAPPS to register or log in: https://erphcmprd.cpa.texas.gov/psc/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?FOCUS=Applicant

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.