Lead Analyst - Intercompany Analytics

Overview

Lead analyst overseeing master data, intercompany analytics, reporting, and data governance.

Key Responsibilities

• intercompany analytics
• master data
• data governance
• process automation
• analytics reporting
• project management

Tasks

-Intercompany - Forecast and report on intercompany transactions in the budgeting process. -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) -Data Governance – Developing and enforcing data governance policies to maintain compliance and integrity. -Project Management – Leading data-related projects, coordinating with teams, and ensuring timely completion. -Intercompany - Maintain intercompany and other analytics processes in SAP. -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. -Intercompany - Ensure accurate billing of intercompany transactions between 16 operating and service companies. -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) -Intercompany – Analyze and report on intercompany transactions including identifying base costs and their associated billings. -Master Data Management – Overseeing the collection, input, and maintenance of master data to ensure consistency and completeness. -Data Quality Assurance – Identifying and resolving data quality issues while implementing processes to enhance accuracy. -Responsibility for maintaining, updating, and improving Avangrid’s in house application for requesting, consolidating, validating and creating master data. -Update processes with developing technologies – ensure that Avangrid utilizes new technology in relation to master data analytics appropriately and efficiently. -Stakeholder Collaboration – Working with various teams to understand data needs and ensure alignment with business objectives.

Requirements

• power platform
• advanced excel
• alteryx
• sap
• financial modeling
• bachelor's

What You Bring

-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 -Six Sigma and/or quality assurance background preferred. -Strong communication skills, both verbal and written. -SKILLS/ABILITIES: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 softwareSoftware Development Cycle (requirements development, design model, verification)Strong communication skills, both verbal and written.Experience with Financial Modeling. -EXPERIENCE/EDUCATION: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. -Able to work collaboratively and constructively as part of a team as well as independently. -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.

People Also Searched For

About Avangrid

-Born in 2015 from a merger with UIL Holdings, creating a national powerhouse from regional utilities. -Headquartered in Orange, Connecticut, with operations in 24 U.S. states. -Its utilities arm manages eight electric and natural gas systems. -Projects include onshore wind, solar, biomass, thermal plants, and grid upgrades. -Fully acquired by Iberdrola in late 2024, enhancing investment potential. -Key ventures include the nation's largest offshore wind project and the Maine Power upgrade. -Combines local legacy with large-scale clean energy ambition.

Sector Specialisms

Visa Sponsorship

-applicants not us citizens must meet immigration requirements to work in the us.