Iberdrola USA Lead Analyst - SAP BW/BO & BI Reporting (ASC 58083) Augusta, ME in Augusta, Maine


Business and Department

ASC-ME-Augusta General Office Augusta,ME



Scope of Work - Main duties, settings, geography, reporting relationships, other relationships:

The Lead Analyst will develop and manage SAP BI/BW/BPC/BOBJ and business Enterprise Reporting, as well as SAP BW HANA (HANA Studio) other BI Reporting Tools (Microstrategy).

MAJOR ROLES AND RESPONSIBILITIES (Scope of work - range of responsibilities):

  • IT Lead for Reporting related requirements gathering, coordinate and achieve consensus with Business Units, identifies best practices and process improvements, and lead product/application evaluations as assigned.

  • Perform Business Warehouse reporting implementation for ongoing projects using SAP. Design, develop and configure SAP BI Objects.

  • Support transfer rules, update rules, start and end routines, fix complex issues, etc.

  • Identify and evaluate new technologies/services and establish/recommend strategic direction.

  • Find solutions to complex technology issues, providing direction as required. Stay current on technologies within assigned business area.

  • Provide expertise in the SAP Business Intelligence best practices, methodologies, standards and suite of tools.

  • Solve unique and complex problems with broad impact on the business.

  • Lead the technical phases of major projects, establishing the technical plans, monitoring schedules, scope and resources.

  • Create and enforce standards. Recommends policies and procedures.



Education & Experience Required:

  • This position requires a Bachelor’s Degree in Business, Computer Science or other technical discipline. Will consider additional years of relevant experience and/or relevant technical certifications in lieu of the degree requirement. Graduate-level training or technical certification in SAP BW is desired.

  • Requires minimum of 10 years work experience in computer field as an analyst including seven years of experience in SAP BW/BI/BPC/BOBJ/ABAP in designing, configuring, developing & maintaining BI infocubes, Data Modeling, Data Mining, DSO's, ETL transformation, reports and testing.

  • Reporting expertise in all the following tools i.e. Crystal, Focal Point, BEX, WEBI and newer technologies are required.

  • SAP BW Basis knowledge is a plus.

  • Knowledge in SAP HANA (HANA Studio) and other Reporting tools (Microstrategy) will be valuable.


  • Experience and demonstrated understanding of the ISU-CCS/CRM-B data model

  • Experience and demonstrated understanding of BW objects and modeling

  • Experience developing custom extractors and enhancing delivered extractors via user exits and BAPIs

  • Proficiency in ABAP as it pertains to BW ETL

  • Experience with SAP HANA data modeling and proper use of advanced DSO’s and Composite providers

  • Ability to interact with end users to refine business requirements

  • Ability to interact with technical developers to provide technical requirements and thoroughly test delivered solutions

  • Understanding of BW specific security roles

  • Preferred experience with initial BW system configuration and administration (Source Systems, RFC connections, delivered content activation)

  • Experience in 3.x data model migration

  • Experience in a variety of reporting solutions including (but not limited to) BEx, BEx Web, Analysis for Office, WEBI, Crystal Reports

  • Understanding of BW performance optimization, both from an ETL perspective as well as a front end/query perspective

  • Experience in data-load administration, including process chain creation, monitoring, error troubleshooting and recovery

  • A desire to proactively identify and address technical and functional issues and omissions before they become production defects

  • Effectively and concisely communicate (written and oral) within the team and senior leadership, including the ability to explain complex SAP technology concepts;

  • Collaborate, build consensus, and influence with and without authority

  • Proactively identify innovative solutions

  • Work independently and proactively set work priorities, conflict resolution, and timely deliverables.

  • Knowledge of CMMI best practices and experience in SAP Solution Manager required.

AVANGRID is an Equal Opportunity / Affirmative Action employer. AVANGRID shall abide by the requirements of 41 CFR 60-1.4(a), 60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities, and prohibit discrimination against all individuals based on their race, color, religion, sex, sexual orientation, gender identity, or national origin. Moreover, these regulations require that covered prime contractors and subcontractors take affirmative action to employ and advance in employment individuals without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, protected veteran status or any other status protected by federal, state, or local law. The Company is committed to a policy in all of its employment practices of equal opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, disability, religion, marital status, veteran status, sexual orientation, or other protected status.

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 Human Resources department at877-387-9061 or careers@avangrid.com

Company: AVANGRID Service Company (ASC)

Department: GIS & BW Networks

Job Title: Lead Analyst – SAP BW/BO & BI Reporting

Reports to: Manager – GIS & Data Solutions

Location: Augusta, ME

Cross Company Responsibility: Yes

REFERENCE: 5088389102

Publication date: 11.04.2018