I am looking to add a Financial Planning and Analysis Analyst on my team, which is responsible for financial planning and analysis at Source Power and Gas. We are based in Sugar Land, TX in the Town Center development. Source is the US subsdidiary of ERM power, which is a publicly listed company in Australia. You can learn more about Source and ERM Power here: http://www.spgenergy.com/ and https://www.ermpower.com.au/

If you would like to apply, just send your resume to kjordan@spgenergy.com. Here is an excerpt from the job description, and I can email you a full job description if you are interested in more fully exploring this opportunity.



ESSENTIAL DUTIES
Reporting and analysis

• Serve as the primary quantitative financial analyst for the company defining the company's financial situation by completing quantitative analyses.
• Analyze and explain variances between actual and forecasted results.
• Perform ad-hoc reporting and analysis, as requested by senior management.
• Implement and maintain business intelligence tools and dashboard reports.
• Develop and maintain financial models and analyses to support new commercial strategies and changes to existing commercial strategies.
• Evaluate new forecasting approaches and new model development
• Support senior leadership and operations with in-depth analysis for gross margins by line of business and utility.

Maintain and improve existing forecasting processes

• Manage the continuous financial forecasting process, including periodic updates to the existing Excel based model for new sales, new products, changes to markets, market conditions, and new market entry.
• Evaluate optional plans by identifying potential outcomes and returns.
• Analyze and explain forecast sensitivities around key assumptions.
• Analyze and explain variances between forecast versions.
• Perform analytics on incremental forecasts based on updated inputs and assumptions. This may include re-writing parts of the Excel model from time to time.
• Validate model inputs against actual tariffs, rates, and settlements.
• Manage the analytical process to determine historical trends and averages, and update to forecasting model assumptions accordingly.
• Communicate analysis findings to risk, accounting, sales, IT, and other relevant departments to update any assumptions used for monthly accruals, pricing models, or commercial strategies.

Migrate the forecasting process into a relational database tool

• Assist with the design of a database replacement for the Excel based forecasting model. The likely system will be built in Microsoft SQL server.
• Participate with IT in implementing and testing the new database forecasting model.
• Continually monitor key performance indicators.

Perform other duties as assigned.

QUALIFICATIONS
A tenacious problem solver
A collaborative, team first attitude
Energized by serving others. Skilled in providing accurate and timely financial analysis services to a diverse customer base with a consistent, professional approach
An unwavering commitment to meeting deadlines and communicating progress toward those deadlines
Well organized and able to handle multiple tasks simultaneously
Exceptional verbal and written communication skills, particularly related to communicating financial information in an appropriate manner to the intended audience, including senior executive management
Committed to maintaining and continually improving process controls

• Spreadsheet controls
• Model and file versioning and related controls
• Data entry procedures and controls

Advanced proficiency with software applications associated this position.

• Microsoft Office suite, including Excel including VBA Macros, PowerPoint, Access, and Word
• Microsoft SQL Server including database design
• SQL stored procedures
• SQL Server Management Studio SSMS

Analytical skills to evaluate data, processes, models, and trends, specifically statistical analysis (standard deviations, slope, R squared, etc.)
A passion for identifying and communicating a financial story from a large volume of data
Focused on accurate and efficient data entry
Curiosity about the retail electricity business and understanding sources of existing profitability and potential new profit sources
Self-disciplined and capable of working with minimal supervision in a fast-paced office environment
Respect for others evidenced by a commitment to communicating effectively, and courteously
Committed to continual learning and advances existing technical knowledge by attending educational workshops and reviewing publications.

EDUCATION & EXPERIENCE
The preferred candidate will have a Bachelor degree in Finance, Accounting, Economics, Statistics, Math, or a related field. A Master degree is preferred.
Ideal candidate will have 3 to 5 years in retail or wholesale energy industry financial analysis or accounting
Familiarity with the electricity and natural gas markets, including physical and financial derivative contracts
Strong quantitative skills with the ability to analyze and interpret data
Individual must be highly motivated and able to solve problems
Highly organized with the ability to prioritize
Ability to work independently in a manner aligned with team goals
Hands on experience applying MS Excel and SQL database tools to solve industry challenges
Strong communication skills, both written and verbal
Team player with a positive attitude, being flexible, willing to learn, and open to continuous improvement of models and processes
Absolute attention to detail Retail is Detail!
Experience with an electricity and/or natural gas retailers is highly desirable

KJ is a great Aggie and you want to be on his team!

I have 4 years of FP&A experience with a large retailer. This looks like a great position for someone in FP&A. I'd apply, but I'm limited to the San Antonio and Austin areas right now.