Forecasting Solutions Analyst
Houston, TX 77056 US
Job Description
We are looking for an individual who is dynamic, energetic, innovative, passionate and curious about commercial market trends. Apply today if you have advanced Microsoft Excel experience using formulas, IF Statements, and pivot tables and want to put your analytical skills to work. The purpose of this role is to mitigate risks deriving from retail electric customer load and identify insights from market and customer data. In this role, you will support pre-deal activities including load data acquisition, quality assurance, analysis, forecasting, and providing subject matter expertise to the Commercial & Industries Pricing and Sales teams. Preference will be given to solutions-oriented candidates who thoroughly understand deregulated electric market load data fundamentals and can identify, create, and deliver improvements to pre-deal load forecasting processes and platforms.
- Support the pre-deal load data processing queue
- Support improving the customer experience by delivering the cleanest, most efficient, most accurate forecasts possible
- Procure historical load data and utility account attributes (e.g., service point location, profile class, rate class and meter type), and assist with maintenance and improvement of data acquisition through automation
- Set up, evaluate, and process account and usage data using existing validation and estimation tools based on established guidelines and standards
- Review completed deals for accuracy and potential issues based on established guidelines and standards
- Support the creation and maintenance of internal documentation
- Support the post-deal maintenance of customer account attributes and load data
- Support the development, improvement, and execution of platform, system, and process testing
- 1-3 years of experience, this position will be a high visibility position and will be presented to Director, VP, and CFO level individuals
- Bachelor’s degree required. Quantitative field (Economics, Engineering, Math, etc.) highly preferred
- Must have patience and does not get frustrated by roadblocks
- Experience working with large amounts of data and helping formulate insights from the data mining
- Advanced Microsoft Excel, using SUMIF(S) formula, Pivot tables and IF statements
- Experience with build-out structures, and presentable reports
- Experience with dynamic modeling (basically making Excel models self-sufficient for the end user)
- Retail energy industry experience preferred
- Advanced or better knowledge of MS Excel
- Problem-solving, strong analytical and statistical skills
- Understands the energy load properties, usage, demand, load factor, voltage, losses, and read cycle and deregulated market design
- Experience handling and managing issues with large quantities of electric usage data
- Ability to extract, manage, and analyze large data sets, perform data manipulation and make load adjustments
- Work with utility companies to comply with industry standards
- Knowledge of Oracle or Microsoft SQL· Familiarity with scripting languages and statistical packages (Python, SAS, R, or similar) preferred
- Excellent training provided. The client is always willing to coach a future new hire
- Enjoy your weekends off!
- Stable client and experienced leader in the industry
- Weekly Pay Periods
- Direct Deposit Options
- This company values entrepreneurship, in an ever-changing environment that is always looking for growth
- Fast-paced work environment
- Long-term contract opportunity
- When you work as a contract /temp employee through Resource Staffing, you are eligible to enroll in medical, dental, and vision insurance, as well as 401K, direct deposit, and our referral bonus program!
Meet Your Recruiter
