Avangrid · 11 hours ago
Lead Analyst - Intercompany Analytics
Boston, MA
Full-time
Onsite
Mid, Senior Level
$101K/yr - $126K/yr
5+ years expAvangrid is a company focused on energy solutions, and they are seeking a Lead Analyst for Intercompany Analytics. This position is responsible for the creation and maintenance of master data, overseeing analytics applications, and providing financial data and business advice to support key business objectives.
Charity
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/Power Apps/Power Automate/SharePoint/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
Qualification
Required
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 5 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
Preferred
Six Sigma and/or quality assurance background preferred
Benefits
Award winning student loan debt repayment program
12% 401(k) Match
Competitive salary and performance-based bonuses
Comprehensive benefits - including medical, dental, vision and variety of well-being programs
Tuition Assistance
Opportunities for professional development, career advancement, and internal mobility
Supportive and inclusive work environment
Generous PTO policy
Company
Avangrid
Avangrid, Inc.
Founded in 1997Orange, Connecticut, USA
5001-10000 employees
H1B Sponsorship
Avangrid has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (5)
2023 (6)
2022 (5)
2021 (3)
2020 (3)
Funding
Current Stage
Late StageLeadership Team
Alfredo del Canto
SVP Chief of Staff to CEO
Bob Kump
Deputy CEO and President
Recent News
Company data provided by crunchbase