Lead Analyst – Intercompany Analytics

Lead Analyst – Intercompany Analytics

Requirements

• Able to work collaboratively and constructively as part of a team as well as independently.
• Excellent analytical ability.
• Process modeling, automation & optimization (Microsoft Power Platform, advanced Excel (Lookup/Logic Functions, Power Query, Pivot Tables/Charts/Power Pivot), SharePoint, and Alteryx Designer).
• Familiarity with SAP or similar ERP software.
• Software Development Cycle (requirements development, design model, verification).
• Strong communication skills, both verbal and written.
• Experience with Financial Modeling.
• Bachelor’s Degree in Accounting, Software Engineering, Finance or STEM-related field required and a minimum of 8 years of financial or data analytics experience, including financial analysis/modeling and corporate business accounting experience. The equivalent combination of education and experience may be considered.

Responsibilities

• Responsibility for maintaining, updating, and improving Avangrid’s in house application for requesting, consolidating, validating and creating master data.
• Daily oversight of the internal Networks master data request processing system; updating/upgrading, troubleshooting, and expanding capabilities, as necessary. (General Form DMC maintenance/Alteryx/Power Queries)
• Master Data Management – Overseeing the collection, input, and maintenance of master data to ensure consistency and completeness.
• Intercompany – Ensure accurate billing of intercompany transactions between 16 operating and service companies.
• Intercompany – Analyze and report on intercompany transactions including identifying base costs and their associated billings.
• Intercompany – Forecast and report on intercompany transactions in the budgeting process.
• Intercompany – Maintain intercompany and other analytics processes in SAP.
• Data Governance – Developing and enforcing data governance policies to maintain compliance and integrity.
• Data Quality Assurance – Identifying and resolving data quality issues while implementing processes to enhance accuracy.
• Stakeholder Collaboration – Working with various teams to understand data needs and ensure alignment with business objectives.
• Optimize internal process efficiency using automation and/or consolidation. Work with other departments to share data resources, reduce redundant processing, and optimize data flow between departments. (ex. SAC WBS Category project; IP PPM IDs)
• Project Management – Leading data-related projects, coordinating with teams, and ensuring timely completion.
• Analytics Reporting – Develop Key Performance reporting to guide business decisions and inform the business of analytic trends.
• Perform analytical data analysis of large/multiple reports; present results using intuitive, thoughtful data visualization methods.
• Update processes with developing technologies – ensure that Avangrid utilizes new technology in relation to master data analytics appropriately and efficiently.

Preferred Qualifications

• Six Sigma and/or quality assurance background preferred.