The Railroad Commission of Texas is the 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 holidays
• Telework options for eligible positions
• Flexible work schedules
• Retirement pension with match
• 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 Railroad Commission of Texas seeks a Data Analyst V to perform highly advanced (senior-level) data analysis and data research work in the Information Technology Services Division. Work involves conducting detailed analysis of and extensive research on data, providing results, and monitoring and implementing data quality. May supervise the work of others. Works under limited supervision, with moderate 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.

Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.

Interprets results to identify significant differences in data.

Identifies and interprets data patterns and trends and assesses data quality.

Cleans and prunes data to discard irrelevant information.

Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.

Guides the selection of data management tools, and the development of standards, usage guidelines, and procedures for those tools.

Defines, develops, and implements data standards.

Develops data quality measures, analyzes data quality results, and implements necessary changes to ensure data quality improvement.

Develops software applications or programming to use for statistical modeling and graphic analysis.

May develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.

May perform quality assurance and serve as a subject matter expert on data integrity, extraction, and compilation.

May supervise the work of others.

Performs related work as assigned.

Position may require some travel.

State Classification Title: Data Analyst V

State Classification #: 0654

Salary Group: B26

Military Occupational Specialty Codes (MOS):
Army – 25B, 35F, 35G, 352N
Navy – CT, CTN, 682X, 681X
Coast Guard – IS

Marine Corps – 0239, 2652, 8848
Air Force – 1N0X1,61AX, 65WX1N1X1

Additional military crosswalk information may be found at http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf

Minimum Qualifications

Bachelor’s degree from an accredited four-year college or university, preferably with major coursework in in Data Analytics; Data Science; Business Analytics; Computer Science; Computer Information Systems; Management Information Systems; Accounting; Finance; Mathematics; Statistics; Economics, or a related field.

Three (3) years experience in data analysis, research, compilation, and/or reporting work.

Valid Texas Driver's License and good driving record.

Experience and education may substitute for each other on a year for year basis.

Preferred Qualifications

5+ years of professional information technology experience and responsibility developing and maintaining Oracle 11G and 12C Business Intelligence reporting environments.

5+ years' professional experience in systems analysis and design work.

5+ years' professional experience with SQL based reporting tools.

2+ years experience working the data visualization tools including Microsoft Power BI or similar tool.

Knowledge and experience working with data models, star schemas, and Facts & Dimensions.

Professional experience and proficiency with Oracle Business Intelligence.

Ability to work cooperatively in a team environment.

Knowledge, Skills, and Abilities

Knowledge of Oracle 11G and also 12C Systems (For example WebLogic, Oracle Forms, OLAP, SOA)

Knowledge of, and professional experience and proficiency with, Oracle Business Intelligence.

Knowledge of, and professional experience and proficiency with Microsoft Power BI.

Knowledge, proven skills and ability in designing and developing Business Intelligence reports.

Knowledge, proven skills and ability in SQL and/or PL/SQL.

Knowledge of State of Texas Public Information Request requirements.

Knowledge of current industry standards associated with configuration management technologies and development methodologies.

Experience overseeing projects and development of high-volume scalable environments.

Experience overseeing standardized quality assurance procedures.

Experience with upgrade/migration of older environments to current platforms.

Experience working on Business Intelligence teams in high-volume production environments

Skill in complex problem solving and critical thinking.

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 confidential data.

Skill in the use of a computer and applicable software, in analyzing problems and devising effective solutions, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.

Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others.

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 position available. Official transcripts, DD214 or DD1300, copies of license/certifications, or other minimum requirement validations will be requested at the time of the job offer.

THE RAILROAD COMMISSION OF TEXAS ONLY ACCEPTS ONLINE APPLICATIONS FOR THIS POSTING. Résumés are not accepted in place of completed applications.

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.