RRC - Data Analyst V

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.

Job Description

The Railroad Commission of Texas (RRC) seeks a senior Data Analyst to perform highly advanced (senior-level) data analysis and documentation supporting the agency’s Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). Work is data-centric: profiling and mapping data, documenting source-to-target (S2T) transformations, analyzing root causes of data defects, defining data quality controls, and creating dataflow/lineage documentation across SQL Server, Oracle, and mainframe/legacy sources.

The analyst collaborates with product owners, SMEs, DBAs, ETL engineers (SSIS/ADF/Informatica), and reporting teams (Power BI/SSRS) to translate business needs into requirements, specifications, and testable acceptance criteria, ensure accurate and timely extracts/loads, and support audit-ready reporting. Work is performed under limited supervision with considerable latitude for initiative and independent judgment.

This position will be responsible for data analysis and documentation in the implementation of multiple inter-related projects (including implementation of software applications in Software as a Service (SaaS) or Commercial off the Shelf (COTS), migration of data from the mainframe to the new systems and building a Data Warehouse). Assessment of existing Mainframe Transformation business analysis processes, implementation of any necessary improvements to these processes, and monitoring/enforcement of the processes to ensure deliverables and materials are produced and maintained in accordance with newly established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. Make assignments and tracks work of other team members or completes individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.

Essential Job Functions

• Assess and improve program analysis/process standards (with emphasis on data mapping, lineage, and reconciliation); monitor adherence and quality.
• Elicit and document data and reporting requirements (KPIs, filters, aggregations, cadence, delivery channel) and translate into functional/data specifications.
• Produce and maintain data profiling results, Source to Target mapping documents, business rules, transformation logic, and data dictionaries for ETL/ELT (SSIS/ADF/Informatica) between SQL Server/Oracle and legacy/mainframe sources.
• Create and maintain end-to-end dataflow and lineage diagrams (current-state and future-state) covering staging, integration, and presentation/reporting layers.
• Define and execute data quality controls (row-count checks, checksums/hashes, referential integrity, threshold/exception reports) and drive root-cause analysis for data issues.
• Partner with ETL and app teams on incremental/CDC strategies, load windows, and performance considerations; validate loads and reconcile with sources.
• Support reporting and analytics deliverables (Power BI/SSRS): field definitions, semantic model requirements, and validation of calculations/filters against business rules.
• Plan and facilitate UAT for data changes and reports (test scenarios, expected results, sign-offs); coordinate remediation of defects and re-tests.
• Contribute to cutover/runbooks for data migrations; track issues/risks and maintain auditable documentation in SharePoint/Confluence/Azure DevOps.
• Performs related work as assigned

For Military Crosswalk information, please visit: https://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 information systems, computer science, business, or a related field.
• 10+ years of progressive experience as a Data Analyst on enterprise IT projects, including hands-on requirements, data mapping, profiling, lineage, and documentation responsibilities; experience may be concurrent.
• Planning, developing, and implementing projects or maintenance activities.
• Experience may have occurred concurrently.
• Experience and education may be substituted for each other on a year-for-year basis.

Preferred Qualifications

• Experience with the RBDMS platform.
• Experience dealing with regulatory processes; for example: permitting, inspection, and/or licensing.
• Experience with process improvement strategies and methodologies.
• Experience with test planning and implementation strategies, particularly user acceptance testing.
• Proven ability to lead change and design more efficient processes.
• Proven ability to resolve conflict and deal with challenging situations.
• Advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, and reconciliation; fluency with ERD/relational modeling, normalization, keys, and indexing.
• Demonstrated experience working with ETL/ELT teams and artifacts (SSIS, ADF, and/or Informatica): reading/writing S2T specs, documenting transformations, validating loads.
• Proven ability to define data quality rules and execute reconciliation/exception analysis; deliver root-cause findings and corrective actions.
• Strong technical writing skills and proficiency with Visio/diagramming; experience maintaining auditable artifacts in SharePoint/Confluence/Azure DevOps.
• Experience facilitating UAT for data/reporting deliverables (test design, execution tracking, sign-off).
• Oil & gas/regulatory domain experience and/or familiarity with RBDMS data models.
• Experience bridging mainframe/hierarchical data (e.g., VSAM/IMS) into relational structures and documenting the mappings.
• Exposure to Power BI/SSRS (semantic modeling concepts, DAX basics, report validation) and Snowflake or Azure analytics services.
• Familiarity with MuleSoft/GoAnywhere and file-based integrations, including scheduling, controls, and reconciliation.
• Experience with process improvement methods and change management for data-centric projects; prior leadership of analysis standards.
• Scripting for analysis/automation (e.g., Python or PowerShell) and experience with data catalog/lineage tools.

Knowledge, Skills, and Abilities

• Knowledge of Business / Data Analysis and Project Management Processes (BABOK/PMBOK) and the DIR Project Delivery Framework.
• Knowledge of systems and procedures used to evaluate a third-party vendor’s performance.
• Knowledge of Agile methodologies, including build planning, sprint planning, and sprint execution processes and activities.
• Knowledge of large-scale IT operations and information technology industry trends.
• Knowledge of technology modernization implementation from legacy/mainframe systems into modern technologies.
• Knowledge of change management best practices for technology related initiatives including training and communication.
• Knowledge of user acceptance testing methods and strategies.
• Knowledge of work simplification methods.
• Skill in the coordination of business / data analyst activities, analysis and documentation of business processes, elicitation of requirements, development of process improvement, planning and execution of integration and user acceptance testing, support of development training and implementation material.
• Skill in coordinating and solving problems.
• Skill in managing user expectations and satisfaction.
• Skill in analyzing complex business / data environments and policies to develop effective and innovative solutions.
• Ability to lead diverse activities while maintaining a high degree of efficiency in achieving the commission goals through consistent, effective assessment and implementation of improvements.
• Ability to exercise sound judgment in making critical decisions; to analyze complex information and develop plans; to interpret complex data; to effectively demonstrate negotiation and facilitation skills; to communicate effectively; and to plan, assign, and/or supervise the work of others.
• Ability to respond effectively in high priority, high pressure, or highly visible situations (e.g. elected official, Legislative, or Executive requests) when necessary and meet changing demands, priorities, and timelines.
• Ability to communicate complex technical information clearly and concisely, both orally and in writing, to diverse audiences.
• Ability to analyze systems and procedures; to write and revise standards and procedures; and to handle multiple projects.
• Ability to maintain working relationships with internal/external stakeholders.
• Ability to take initiative and work independently.
• Ability to work effectively on a team as a member and leader.

Miscellaneous Requirements:

• Ability to work a consistent schedule such as Monday-Friday, 8AM – 5PM Central Time with occasional flexible hours, after hours, weekends, and holidays.

Note: Salary will be determined based on education and experience.

• 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=enRemarks:  
• 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 an 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.