POSTING:#26-02
OPEN: 11/17/2025
CLOSE: Until Filled
MARKET DATA ANALYST
Data Analyst II-IV
Monthly Salary: $5,000 – $7,500
(Depending on Experience and Qualifications)
(More than one position may be filled from this posting)
GENERAL DESCRIPTION:
The Market Data Analyst will work directly for the Director of Market Data Analytics under the direction of the Chief Executive & Public Counsel of the Office of Public Utility Counsel (OPUC). The Market Data Analyst will be responsible for assisting and gathering information related to the program activities of OPUC’s data analytical team, assisting in the collection, organization, analysis, and preparation of reports and studies of collected market data, assisting in developing agency policy positions and assisting in providing advice and technical assistance to agency staff, working with other governmental agencies, stakeholders, and the general public. This role is essential to advancing OPUC’s mission to represent residential and small commercial consumers in utility matters by strengthening the agency’s capacity to use data to drive policy decisions and advocacy. Works under limited to moderate supervision, with limited to moderate latitude for the use of initiative and independent judgment.
Preferred qualifications include extensive knowledge of Excel and Power Query/ Power BI. Experience with collection and interpretation of data.
Highly preferred qualifications include knowledge of the ERCOT Market and at the Public Utility Commission of Texas (PUCT). Experience with collecting, analyzing and interpreting massive amounts of collected data. Master’s degree in economics, data analytics or a related field. (Education may be submitted for work experience.)
ESSENTIAL JOB DUTIES:
• Assists with the collecting and analyzing of data collected from ERCOT, PUCT, and utility companies.
• Assists with interpreting data analysis results and reporting those results to the Director of Market Data Analytics.
• Assists the data analytic team in producing clear, actionable reports and visualizations based on analysis of ERCOT, PUCT, and utility data.
• Assists in developing and implementing goals and objectives consistent with the agency’s strategic plan and assists in achieving those goals.
• Assists in developing and overseeing the implementation of long-range and short-term plans.
• Assists in developing and implementing techniques for evaluating program activities and functions of the data analytics team and provides recommendations for needed for changes.
• Assists in preparing, both written and verbal, the agency and staff for meetings, hearings, and legislative hearings on OPUC’s data analytics team.
• Assists in monitoring and reporting on performance reports, studies, and specialized projects at PUCT and ERCOT; assists in reviewing filings in utility proceedings; and recommends appropriate agency responses.
• Ability and willingness to work harmoniously and communicate effectively with peers including other agency personnel, industry representatives, and the public.
• Plans and carries out special assignments as requested; performs related work as required.
• Must be dependable in adhering to established work schedule.
• Performs related work as assigned.
MINIMUM REQUIREMENTS:
1. Graduation from an accredited four-year college or university with major course work in economics, data analytics or a related field.
2. Ability to be a dependable member of the data analytical team. Assists in developing and communicating reports on the analysis of the data collected from ERCOT, PUCT, and utility companies.
3. Ability to gather, assemble, correlate, and analyze facts; to devise solutions to problems; to develop, evaluate, and interpret policies and procedures; to communicate effectively; and to assist the Director of the data analytical team in maintaining and meeting teams goals and objectives.
4. Experience with one or more of the following software, coding languages, or platforms needed to perform essential job duties: Python, R, Stata, SQL, Power BI, Tableau, ERCOT MIS. Applicants must provide proof of experience.
PREFERRED QUALIFICATIONS:
1. Knowledge of the ERCOT wholesale electric market and/or the Public Utility Commission.
2. Experience with collection and interpretation of data analytics.
3. Extensive knowledge of Excel and Power Query/Power BI.
HIGHLY PREFERRED QUALIFICATIONS:
4. Direct experience of the ERCOT wholesale electric market and/or the Public Utility Commission.
5. Extensive experience with collection and interpretation of data analytics.
6. Master’s degree in economics, data analytics or a related field. (Education may be submitted for work experience.)
MILITARY OCCUPATIONAL CODES:
The Military Occupational Specialty (MOS) codes applicable to this position can be accessed at: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf
REMARKS:
• Candidates invited to interview may be required to submit a transcript and/or a writing sample.
• The position may require additional work hours including evenings, weekends, and/or holidays to meet critical deadlines.
• OPUC participates in E-verify and will provide to the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization.
• A satisfactory driving record may be required for driving a state or personal vehicle to conduct agency business. Employees may have their driving record evaluated.
• Employees are required to comply with Office policies and provisions outlined in the employee handbook.
• The Office of Public Utility Counsel has a Post-Employment Restriction – details furnished upon request.
APPLICATIONS: Send State of Texas application, college transcripts and references to:
Texas Office of Public Utility Counsel
ATTN: Human Resources
P.O. Box 12397
Austin, TX 78711-2397
Phone: 512-936-7500
Fax: 512-936-7525
Email: hr_opuc@opuc.texas.gov