DATA ANALYST-ASSOC (5370-Economic Research Dept)

Summary: 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. Responsibilities: - 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 Required Qualifications: - 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 Qualifications: - Master's degree in business analytics or an advanced computer programming field, statistics, mathematics, engineering, computer science, economics, or management of information systems preferred Required Skills: Power BI, R R Studio, R ggplot, R tidyverse, Data modeling, Oracle, Excel, SQL, Data mining, Machine learning, Statistics, Cloud platform analytics deployment, Relational database management systems (RDBMS), Data warehousing, Python, SAS, Business Intelligence, Statistical modeling, Regression, Descriptive statistics, Statistical tests, maintain effective working relationships, research and prepare written reports, Effective verbal and written communication