The Data Warehouse & Reporting Analyst is responsible for maintaining accuracy of all data related tools and reporting for the supply-chain. This includes, but is not limited to, SAP applications, Global Parts Catalog, MicroStrategy business intelligence solution and JIRA business process workflow solution. This role will be integral in driving continuous improvement through our quality program across all supply-chain functions.
Responsible for developing, documenting, deploying and maintaining Avangrid Renewables' quality program for all supply-chain functions.
Gather requirements and lead development of SAP usability improvements and associated SAP based applications (MOLO & SCIMP)
Define reporting roadmap, implement business intelligence solution and produce/monitor periodic business monitoring reports.
Develop and deploy desktop metrics daily reporting functionality to drive focus and efficiency within the supply-chain.
Define and develop a Business Process Workflow solution that replaces email heavy business processes with a streamlined solution that improves process cycle time and visibility across the organization.
Manage and integrate ICN process into current change management activities to drive smoother transition from old to new parts (reduced scrap and increased cost savings)
Develops and maintains information for each part including Avangrid's part number, manufacturer part number(s), pricing, photos, and other information relevant to that part.
Utilizes system tools in SAP and SharePoint to establish and maintain the Materials Database to support Commercial Operations.
Implements the process for establishing new part numbers and any revisions to existing parts, as required.
Enables alternate and direct sourcing efforts by providing a complete definition of all part characteristics in a standardized format.
Works with all internal stakeholders to implement documented processes and make process improvements.
Develops, maintains and modifies SQL database in support of Operations reporting and business tools.
Develops, maintains and modifies Visual Basic programs in support of Operations reporting and business tools.
Bachelor's Degree in Management Information Systems, Supply Chain Management, Computer Science, Business or equivalent combination of education and work experience.
Minimum of 5 years' experience in purchasing and inventory functions.
Proficient with database management and all MS Office applications.
Experience in with ERP systems (preferably SAP), especially materials requirements planning (MRP).
Understanding of supply chain for an operations group.
Excellent analytical, project management, presentation and communication
Demonstrated ability to participate in cross-functional teams. Strong communication and interpersonal skills.
Ability to work independently.
Proficiency with MS office.
Proficient English language reading and speaking skills to communicate with co-workers; understand and provide directions; respond to management inquiries and make entries on reports and records.
Exhibit skills and attitude which demonstrate commitment to Company policies, principles and processes.
Basic knowledge of simple math concepts.
All offers of employment are contingent upon the successful completion of a medical Fit for Duty exam, background check, references, drug screen, verification of legal right to work in the U.S., and in some cases, a credit check. A credit check will be administered when a prospective employee will be working in Finance, Accounting, Treasury or where duties may involve handling of funds, accounts or cash. A Motor Vehicle (MVR) check will be administered when a prospective employee will be regularly using a company vehicle.
Avangrid Renewables is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as an individual with a disability, or any other status or class protected by federal or state law.