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 Scottish Power

-Operates in electricity generation, transmission, and distribution and specialises in renewable energy, particularly onshore and offshore wind farms, and manages the transmission and distribution networks in South and Central Scotland, as well as parts of North Wales and North West England. -Provides electricity and gas to residential, commercial, and industrial customers across the UK, offering services such as smart metering, energy efficiency advice, and home services like boiler care and maintenance. -Has three main divisions: Energy Networks, Renewables, and Energy Retail and Wholesale.

Sector Specialisms

Visa Sponsorship

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