Rrc - Critical Infrastructure Division - Data Analyst Ii - Austin Hq

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

Turn data into decisions that matter! As a Data Analyst II, you’ll be at the intersection of data, insight, and action by partnering with internal and external stakeholders to uncover needs, transform complex datasets into meaningful reports, and reveal the stories hidden in the numbers. From cleaning and refining data to identifying trends, resolving data quality issues, and supporting data-driven recommendations, your work will directly influence innovative strategies and better outcomes. If you thrive on problem-solving, collaboration, and using analytics to make an impact, this role offers the opportunity to do just that!

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 II to provide data analysis, data management, and research work in the Critical Infrastructure Division (CID). Major responsibilities include analyzing, maintaining, and enhancing divisions existing databases, resources, and tools. Creating and reporting CID KPIs to stakeholders. Performing data clean-up and transformation, including migration of CID data from existing databases to new databases. Coordinating and communicating as needed with RRCs Information Technology Services Division. Works under general supervision, with limited latitude for the use of initiative and independent judgment.

Essential Job Duties

• Analyzes data using standard statistical tools, methods, and techniques.
• Consults with internal and external customers to identify user needs.
• Compiles and queries data and creates reports.
• Interprets results to identify significant differences in data.
• Cleans and prunes data to discard irrelevant information.
• Assists in developing methods for mitigating data issues and deploys those methods to correct issues.
• 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: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf

Minimum Qualifications

• Graduation from an accredited four-year college or university with major coursework in Data Science, Business Analytics, Computer Science, Computer Information Systems, Management Information Systems, Mathematics, Statistics, GIS, Geology, Engineering, or a related field.
• At least two years (2) of experience in data analysis, data management, research, compilation, and reporting work.
• Experience in Python, VBA Script, and SQL.
• Experience and education may substitute for each other on a year-for-year basis.

Preferred Qualifications

• Experience using and maintaining data in ESRI ArcGIS, MS Access, MS Power BI, and/or IHS Petra.
• Development experience using modern programming languages.
• Experience with Salesforce, Salesforce reports, and /or Salesforce development.
• Experience in oilfield operations.
• Knowledge of the Railroad Commission's rules, policies, and procedures.
• Licensed as a Professional Engineer (P. E.) or Professional Geoscientist (P. G.) in Texas.

Knowledge, Skills, and Abilities

• Knowledge of statistics and analyzing data sets; of running queries, report writing, and presenting findings.
• Knowledge of data models, database design development, data mining, and segmentation techniques.
• Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential information including office procedures and protocols.
• Skilled in the use of computers and applicable software, in analyzing problems and devising effective solutions 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.
• Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; 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 in-office Monday – Friday, 8:00 AM – 5:00 PM with occasional flexible hours and weekends.

Work Hours: 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 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 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.