Lead Analyst - Intercompany AnalyticsDepartment:  FinanceReports to: Manager - Networks Business Analysis &amp; Planning Location: In Office,  Boston MAThe base salary range for this position is dependent upon experience and location, ranging from: $98,785.60 - $123,482Job SummaryThis position is responsible for the creation of all Master Data for Avangrid. Additionally, this role will be responsible for updating and maintaining Avangrid analytics application and key performance reporting for Avangrid and its affiliates. This position will lead analysis and research projects regarding business issues to provide management with financial data and business advice to support the key business objectives for Avangrid.Key Responsibilities<ul><li>Responsibility for maintaining, updating, and improving Avangrid’s in house application for requesting, consolidating, validating and creating master data.</li><li>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)</li><li>Master Data Management – Overseeing the collection, input, and maintenance of master data to ensure consistency and completeness.</li><li>Intercompany - Ensure accurate billing of intercompany transactions between 16 operating and service companies.</li><li>Intercompany – Analyze and report on intercompany transactions including identifying base costs and their associated billings.</li><li>Intercompany - Forecast and report on intercompany transactions in the budgeting process.</li><li>Intercompany - Maintain intercompany and other analytics processes in SAP.</li></ul><ul><li>Data Governance – Developing and enforcing data governance policies to maintain compliance and integrity.</li></ul><ul><li>Data Quality Assurance – Identifying and resolving data quality issues while implementing processes to enhance accuracy.</li></ul><ul><li>Stakeholder Collaboration – Working with various teams to understand data needs and ensure alignment with business objectives.</li><li>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)</li></ul><ul><li>Project Management – Leading data-related projects, coordinating with teams, and ensuring timely completion.</li></ul><ul><li>Analytics Reporting – Develop Key Performance reporting to guide business decisions and inform the business of analytic trends</li><li>Perform analytical data analysis of large/multiple reports; present results using intuitive, thoughtful data visualization methods.</li><li>Update processes with developing technologies – ensure that Avangrid utilizes new technology in relation to master data analytics appropriately and efficiently.</li></ul>Required Qualifications<ul><li>SKILLS/ABILITIES:<ul><li>Able to work collaboratively and constructively as part of a team as well as independently.</li><li>Excellent analytical ability.</li><li>Process modeling, automation &amp; optimization (Microsoft Power Platform, advanced Excel (Lookup/Logic Functions, Power Query, Pivot Tables/Charts/Power Pivot), SharePoint, and Alteryx Designer.</li><li>Familiarity with SAP or similar ERP software</li><li>Software Development Cycle (requirements development, design model, verification)</li><li>Strong communication skills, both verbal and written.</li><li>Experience with Financial Modeling.</li></ul></li></ul><ul><li>EXPERIENCE/EDUCATION:<ul><li>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.</li></ul></li></ul>Preferred Qualifications<ul><li>Six Sigma and/or quality assurance background preferred.</li></ul>Company:AVANGRID MANAGEMENT COMPANY, LLC.Mobility InformationPlease 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 <a href="mailto:careers@avangrid.com">careers@avangrid.com</a>.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&amp;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:November-25-2025

Avangrid is a leading sustainable energy company transitioning America toward a clean and connected future headquartered in Orange, CT, and has a footprint in 24 states with $40 billion in assets. Our primary businesses are Networks, which serves 3.3 million electric and natural gas customers in the Northeast, and Renewables, the third-largest renewable energy company in the U.S. with a diverse onshore and offshore renewable energy portfolio. With more than 7,000 employees, Avangrid has built a culture that blends diversity, equity and inclusion guided by the company&rsquo;s ESG+F framework and the UN Sustainable Development Goals. This has led to recognition by JUST Capital in 2021 and 2022 as one of America&rsquo;s best corporate citizens and second in utilities for our commitment to the environment and the communities we serve. Avangrid has been named one of the World&rsquo;s Most Ethical Companies for four consecutive years by the Ethisphere Institute.

Lead Analyst - Intercompany Analytics

Lead Analyst - Intercompany AnalyticsDepartment:&nbsp; FinanceReports to: Manager - Networks Business Analysis &amp; Planning Location: In Office, &nbsp;Boston MAThe base salary range for this position is dependent upon experience and location, ranging from: $98,785.60 - $123,482Job SummaryThis position is responsible for the creation of all Master Data for Avangrid. Additionally, this role will be responsible for updating and maintaining Avangrid analytics application and key performance reporting for Avangrid and its affiliates. This position will lead analysis and research projects regarding business issues to provide management with financial data and business advice to support the key business objectives for Avangrid.Key Responsibilities<ul><li>Responsibility for maintaining, updating, and improving Avangrid’s in house application for requesting, consolidating, validating and creating master data.</li><li>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)</li><li>Master Data Management – Overseeing the collection, input, and maintenance of master data to ensure consistency and completeness.</li><li>Intercompany - Ensure accurate billing of intercompany transactions between 16 operating and service companies.</li><li>Intercompany – Analyze and report on intercompany transactions including identifying base costs and their associated billings.</li><li>Intercompany - Forecast and report on intercompany transactions in the budgeting process.</li><li>Intercompany - Maintain intercompany and other analytics processes in SAP.</li></ul><ul><li>Data Governance – Developing and enforcing data governance policies to maintain compliance and integrity.</li></ul><ul><li>Data Quality Assurance – Identifying and resolving data quality issues while implementing processes to enhance accuracy.</li></ul><ul><li>Stakeholder Collaboration – Working with various teams to understand data needs and ensure alignment with business objectives.</li><li>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)</li></ul><ul><li>Project Management – Leading data-related projects, coordinating with teams, and ensuring timely completion.</li></ul><ul><li>Analytics Reporting – Develop Key Performance reporting to guide business decisions and inform the business of analytic trends</li><li>Perform analytical data analysis of large/multiple reports; present results using intuitive, thoughtful data visualization methods.</li><li>Update processes with developing technologies – ensure that Avangrid utilizes new technology in relation to master data analytics appropriately and efficiently.</li></ul>Required Qualifications<ul><li>SKILLS/ABILITIES:<ul><li>Able to work collaboratively and constructively as part of a team as well as independently.</li><li>Excellent analytical ability.</li><li>Process modeling, automation &amp; optimization (Microsoft Power Platform, advanced Excel (Lookup/Logic Functions, Power Query, Pivot Tables/Charts/Power Pivot), SharePoint, and Alteryx Designer.</li><li>Familiarity with SAP or similar ERP software</li><li>Software Development Cycle (requirements development, design model, verification)</li><li>Strong communication skills, both verbal and written.</li><li>Experience with Financial Modeling.</li></ul></li></ul><ul><li>EXPERIENCE/EDUCATION:<ul><li>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.</li></ul></li></ul>Preferred Qualifications<ul><li>Six Sigma and/or quality assurance background preferred.</li></ul>Company:AVANGRID MANAGEMENT COMPANY, LLC.Mobility InformationPlease 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 <a href="mailto:careers@avangrid.com">careers@avangrid.com</a>.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. &nbsp;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&amp;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:November-25-2025

Lead Analyst - Intercompany Analytics

About the Job

About the Company

Iberdrola

Similar Jobs

Lead Analyst - FP&A Investment Planning

Lead Analyst - FP&A Investment Planning

Lead Analyst - Reporting

Lead Analyst - Reporting

Senior Analyst, Supply Chain Data Analytics

Senior Analyst, Supply Chain Data Analytics

Service Business Analyst

Service Business Analyst

Lead Analyst - Financial & Operations

Lead Analyst - Financial & Operations

Business Operations Analyst

Business Operations Analyst

Senior Business Data Intelligence Specialist

Senior Business Data Intelligence Specialist

Lead Analyst - Financial Accounting

Lead Analyst - Financial Accounting

Senior Data Analyst - Finance

Senior Data Analyst - Finance

Data Analyst

Data AnalystNew