DATA ANALYST-ASSOC (5370-Economic Research Dept)

REGULATORY POLICY AND RATES

Bachelor’s degree in in statistics, mathematics, engineering, computer science, economics or management of information systems and successful completion of Data Analytics certification required. * **Master’s degree in business analytics or an advanced computer programming field, statistics, mathematics, engineering, computer science, economics, or management of information systems preferred.

Industry knowledge relative to supporting data analytics processes. Demonstrated skills in Power Bi including dashboarding, R (R Studio, ggplot, tidyverse), and data modeling is required. Experience using Oracle, Excel, and SQL. Practiced knowledge of data mining, machine learning, statistics, and the ability to functionalize findings for internal customer use. Experience developing and deploying analytics solutions on a cloud platform. * Experience extracting and managing both structured and unstructured data from Demonstrated ability to research new intelligence solutions

Develop, test, validate and refine models to optimize customer experiences, advance the utilization and acceptance of data analytics with minimal or no supervision Must possess advanced Business Intelligence skills. Lead analytics workstream on one or more projects at a time PowerBI and SQL for accessing and wrangling data experience required. Understanding of relational database management systems (RDBMS), data modeling, and data warehousing Using business intelligence tools, create dashboards, visualizations and/or and offer recommendations that are practiced, actionable, and have material impact, in addition to being well supported by analytical models and data Understanding of and ability to use programming languages for analytics modeling, like Python, R or SAS. Assist in the development of data warehousing solutions existing platform Ability to research and prepare written reports, analyze and interpret data Ability to maintain a strong sense of propriety concerning confidential Knowledge of computerization techniques for problem solving and data analysis required. Ability to assist in performing the peak load, energy sales, and customer knowledge with other members of the Load Research and Data Analytics team. Ability to attend training seminars and classes, both in-town and at out of Responsible for leading the design and support of BI applications and architecture utilizing Microsoft Power BI. Responsible for project workstreams and participate in multidisciplinary analytics project teams. individual interviews with experts to gain valid information and data needed for analysis and process improvement. Manage the mining of various large data sets for actionable insights and analysis. Locate new data sources, analyze statistics, and implement quality Find new uses for existing data sources. Leverage tools like R, Power BI, Python, , and SQL to conduct statistical Identify gaps and process improvement opportunities and present solutions to standardize, partnering with IT to design and implement solutions. Craft and construct visually engaging, creative, and easy-to-use data Prepares schedules consistent with regulatory filing requirements. Prepare testimony and exhibits for self and/or EPE witnesses, regulatory Coordinates acquisition and maintenance of financial, load research and cost-of-service data. Performs short term and long-term revenue projections and variance analysis. Performs research and analysis resulting in applicable rate structures, which comply with regulatory mandates and Company objectives and anticipated effects of implementation. Assists with special projects as required. Complies with all applicable Company policies, procedures and code of include employment, safety and environmental standards and regulations. Conduct data analyses supporting weather normalization of energy sales, Lead in the development of programming code to automate internal and Assist in review and audits to ensure accurate data, reports, schedules and 460,000 customers in a 10,000-square mile area of the Rio Grande Valley in west Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against complaint or charge, (b) in furtherance of an investigation, proceeding, consistent with the contractor’s legal duty to furnish information.