Manager, Risk Reporting & Projects

Job Title:   Manager, Reporting & Projects

Department:     Mid Office

Reports in office to: Boston, MA

Reports to: Managing Director, Market Risk

Work Type: Office

The base salary for this position is dependent upon experience and location ranging from $134,080-$167,600

Position Overview:

Duties - Risk Reporting

• Produce daily MtM valuation report of all company generation assets

• Daily monitoring of company positions and trading activity to monitor compliance with company Risk Policies and Risk Procedures

• Document adherence to various financial, delegations of authority, and trade controls

• Produce daily Gross Margin Report that shows month-to-date gross margin earnings compared to budget.

• Produce weekly Gross Margin Report that shows week-over-week change

• Perform business controls for locking trades, reconciliation against clearing broker data, and Delegations of Authority

Duties - Other

• Evaluate, develop, and implement process improvements and enhancements to optimize and strengthen controls and analytical capabilities

• Work very closely with Front Office, Compliance, and Information Technology groups to ensure that all relevant and required risk analysis products and services are available and continually refined

• Analyze & identify discrepancies between large volumes of data from various sources within the company

• Communicate process improvements and data anomalies to stakeholders/management

• Work with other groups to solve complex problems by designing or developing tools to deal with large amounts of data

• Collaborate and build relationships with IT, Legal, Asset Management, trading support, Accounting, etc. in order to meet deliverables

• Maintain a functional system for archiving filed data for easy retrieval

• Create ad hoc reports / data sets as assigned

• As time allows: Assist other business areas in report creation, report troubleshooting, and data retrieval

• Other projects/duties as assigned

Education / Experience

Bachelor’s degree or higher

Required: 10+ years of related experience in energy industry

Skills / Abilities Required

• Advanced Microsoft Excel skills: Power Query, Power Query M formula language, formulas, macros, pivot tables, ranges, tables

• Experience working with VBA, Power Query M formula language, SQL, database tools (Toad, SQL Developer)

• Ability to work independently, working through difficult reconciliation issues to their ultimate source/cause, and finding an appropriate solution

• Ability to gather, consolidate, analyze and report data accurately and efficiently

• Ability to analyze project risks and proactively identify solutions with a flexible, creative, and solution-focused outlook on problem solving

• Capacity to manage and coordinate multiple tasks, solve complex problems and work under pressure

• Ability to work with other departments with different perspectives on reporting issues

• Effective written and verbal communication skills

• Excellent interpersonal skills; able to interact with other parts of the business at all levels

• Ability to work within a team environment
Skills / Abilities Desired

• Familiarity/ prior experience with FIS Aligne, webTrader, Paragon

#LI-AM1

#ONSITE

Company:

Mobility Information

Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country.

At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law.
If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our People and Organization department at [email protected].

Avangrid employees may be assigned a system emergency role and in the event of a system emergency, may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate functions.  This does not include those that will work for Avangrid Power.

Avangrid employees may also be assigned a NERC Reliability Standards compliance role supporting Critical Infrastructure Protection (CIP) and/or Operations and Planning (O&P) responsibilities. This is applicable to employees that will work in electric transmission, operations, and cyber security business areas in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate business areas. NERC Reliability Standards compliance roles and responsibilities may include additional access protections, training, audit engagement, and required evidence retention, and will be communicated by the employee’s management.

Job Posting End Date: