DATA ANALYST-ASSOC (5370-Economic Research Dept)

El Paso Electric Company•El Paso, TX

4d•$70,100 - $95,774

About The Position

This position is within the Regulatory Policy and Rates department, specifically in Economic Research. The role involves developing, testing, validating, and refining models to optimize customer experiences, revenue generation, operational effectiveness, marketing success, and other business outcomes. The analyst will also assist in developing and executing a strategic plan to advance the utilization and acceptance of data analytics with minimal supervision. Key responsibilities include leading analytics workstreams, using business intelligence tools to create dashboards and reports, understanding relational database management systems, data modeling, and data warehousing. The role requires proficiency in programming languages for analytics modeling such as Python, R, or SAS, and assisting in the development of data warehousing solutions. The analyst will evaluate new system capabilities and push conventional thinking to drive change and innovation. Strong communication skills are essential for preparing written reports, analyzing and interpreting data, and maintaining effective working relationships. The position also involves assisting in performing peak load, energy sales, and customer forecasting functions, analyzing information, preparing forecast reports, and meeting deadlines. A willingness to share technology and specialized knowledge with the team is important. The role requires attending training seminars and classes. Essential job functions include leading the design and support of BI applications and architecture utilizing Microsoft Power BI, managing project workstreams, collaborating with business leaders to identify and track key metrics, mining large data sets for actionable insights, locating new data sources, and implementing quality procedures. The analyst will leverage tools like R, Power BI, Python, and SQL for statistical modeling, identify gaps and process improvement opportunities, and present solutions. Crafting visually engaging data delivery solutions such as dashboards and reports is also a key function. Knowledge of statistical techniques and concepts is required. The role involves preparing, auditing, and coordinating monthly, quarterly, and annual reports, schedules, and exhibits, consistent with regulatory filing requirements. Preparing testimony and exhibits for regulatory filings and responding to information requests are also part of the duties. The analyst will coordinate the acquisition and maintenance of financial, load research, and cost-of-service data, interpret Company tariffs, and instruct others on their use. Designing rates for existing and proposed rate classes, calculating jurisdictional and class revenue requirements, and performing jurisdictional and class cost of service studies are also included. Performing short-term and long-term revenue projections and variance analysis, as well as research and analysis for applicable rate structures that comply with regulatory mandates and Company objectives, are key responsibilities. Assisting with special projects, complying with Company policies and governmental regulations, conducting data analyses supporting weather normalization of energy sales, derivation of load factors, and calculating demand components are also part of the role. Leading the development of programming code to automate reporting requirements and assisting in review and audits to ensure data accuracy are also essential. The company, El Paso Electric (EPE), is a regional energy provider serving approximately 460,000 customers in west Texas and southern New Mexico.

Requirements

Bachelor’s degree in statistics, mathematics, engineering, computer science, economics or management of information systems and successful completion of Data Analytics certification required.
0-3 or more years of experience.
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 multiple sources.
Ability to guide colleagues in the appropriate techniques from various systems.
Must be able to troubleshoot and resolve errors when performing systematic updates.
Demonstrated ability to research new technology and develop business cases to support enterprise wide business intelligence solutions.
Must possess advanced Business Intelligence skills.
PowerBI and SQL for accessing and wrangling data experience required.
Understanding of relational database management systems (RDBMS), data modeling, and data warehousing.
Understanding of and ability to use programming languages for analytics modeling, like Python, R or SAS.
Knowledge of computerization techniques for problem solving and data analysis required.
Must have a demonstrated a willingness to share technology and specialized 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 town locations required.

Nice To Haves

Master’s degree in business analytics or an advanced computer programming field, statistics, mathematics, engineering, computer science, economics, or management of information systems preferred.
Ability to assist in the development and execution of a strategic plan to advance the utilization and acceptance of data analytics with minimal or no supervision.
Ability to guide colleagues in the appropriate techniques from various systems.
Ability to research new technology and develop business cases to support enterprise wide business intelligence solutions.
Ability to evaluate new system capabilities to determine a fit within the existing platform.
Ability to push conventional thinking to drive change and innovation.
Ability to maintain effective working relationships with officers, managers, fellow employees, and the general public.
Ability to maintain a strong sense of propriety concerning confidential matters.
Ability to assist in performing the peak load, energy sales, and customer forecasting function, analyzing information, preparing forecast reports and meeting deadlines is required.
Demonstrated a willingness to share technology and specialized 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 town locations required.

Responsibilities

Develop, test, validate and refine models to optimize customer experiences, revenue generation, operational effectiveness, marketing success and other business outcomes.
Assist in the development and execution of a strategic plan to advance the utilization and acceptance of data analytics with minimal or no supervision.
Lead analytics workstream on one or more projects at a time.
Using business intelligence tools, create dashboards, visualizations and/or other advanced analytics reports to adequately tell the business narrative and offer recommendations that are practiced, actionable, and have material impact, in addition to being well supported by analytical models and data.
Assist in the development of data warehousing solutions.
Evaluate new system capabilities to determine a fit within the existing platform.
Push conventional thinking to drive change and innovation.
Research and prepare written reports, analyze and interpret data.
Maintain effective working relationships with officers, managers, fellow employees, and the general public.
Maintain a strong sense of propriety concerning confidential matters.
Assist in performing the peak load, energy sales, and customer forecasting function, analyzing information, preparing forecast reports and meeting deadlines.
Share technology and specialized knowledge with other members of the Load Research and Data Analytics team.
Attend training seminars and classes, both in-town and at out of town locations.
Lead the design and support of BI applications and architecture utilizing Microsoft Power BI.
Manage project workstreams and participate in multidisciplinary analytics project teams.
Collaborate with business leaders to identify, track, and share key metrics.
Manage the mining of various large data sets for actionable insights and trends through the development of metrics, dashboards, and deep dive analysis.
Locate new data sources, analyze statistics, and implement quality procedures.
Find new uses for existing data sources.
Leverage tools like R, Power BI, Python, and SQL to conduct statistical modeling.
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 delivery solutions including dashboards, scorecards, infographics, and reports that enable users to be more productive and better informed.
Prepare, audit, and coordinate monthly, quarterly, and annual reports, schedules, and exhibits.
Prepare schedules consistent with regulatory filing requirements.
Prepare testimony and exhibits for self and/or EPE witnesses, regulatory filing requirements and associated responses to requests for information.
Coordinate acquisition and maintenance of financial, load research and cost-of-service data.
Interpret the Company’s tariffs, and instruct others of their need, use, and applicability.
Design rates for existing and proposed rate classes.
Calculate jurisdictional and class revenue requirements.
Perform jurisdictional and class cost of service studies.
Perform short term and long-term revenue projections and variance analysis.
Perform research and analysis resulting in applicable rate structures, which comply with regulatory mandates and Company objectives and anticipated effects of implementation.
Assist with special projects as required.
Comply with all applicable Company policies, procedures and code of ethics as well as all applicable governmental laws and regulations to include employment, safety and environmental standards and regulations.
Conduct data analyses supporting weather normalization of energy sales, derivation of load factors and calculating demand components.
Lead in the development of programming code to automate internal and external reporting requirements.
Assist in review and audits to ensure accurate data, reports, schedules and presentations.
Perform other related tasks that are not included above but are within the context of the duties defined.