El Paso Electric Company is a regional energy provider engaged in generation, transmission, and distribution services. They are seeking a Data Analyst-Assoc to lead the design and support of BI applications, collaborate with business leaders, and manage large data sets for actionable insights.
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. Interview subject matter experts, plan and conduct individual interviews with experts to gain valid information and data needed for analysis and process improvement
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
Knowledge of statistical techniques and concepts (regression, descriptive statistics, statistical tests, and proper usage, etc.)
Prepares, audits, and coordinates monthly, quarterly, and annual reports, schedules, and exhibits
Prepares 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
Coordinates acquisition and maintenance of financial, load research and cost-of-service data
Interprets the Company’s tariffs, and instruct others of their need, use, and applicability
Designs rates for existing and proposed rate classes
Calculates jurisdictional and class revenue requirements
Performs jurisdictional and class cost of service studies
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 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
Qualification
Required
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
Develop, test, validate and refine models to optimize customer experiences, revenue generation, operational effectiveness, marketing success and other business outcomes
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
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 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
Understanding of and ability to use programming languages for analytics modeling, like Python, R or SAS
Assist in the development of data warehousing 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
Effective verbal and written communication skills
Ability to research and prepare written reports, analyze and interpret data
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
Knowledge of computerization techniques for problem solving and data analysis required
Ability to assist in performing the peak load, energy sales, and customer forecasting function, analyzing information, preparing forecast reports and meeting deadlines is required
Must have a demonstrated 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
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
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
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
Knowledge of statistical techniques and concepts (regression, descriptive statistics, statistical tests, and proper usage, etc.)
Prepares, audits, and coordinates monthly, quarterly, and annual reports, schedules, and exhibits
Prepares 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
Coordinates acquisition and maintenance of financial, load research and cost-of-service data
Interprets the Company's tariffs, and instruct others of their need, use, and applicability
Designs rates for existing and proposed rate classes
Calculates jurisdictional and class revenue requirements
Performs jurisdictional and class cost of service studies
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 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
Preferred
Master's degree in business analytics or an advanced computer programming field, statistics, mathematics, engineering, computer science, economics, or management of information systems preferred
Benefits
El Paso Electric (EPE) first began serving its customers on August 30, 1901.
