Epico

Senior Power BI Expert

Epico is looking for a Senior Power BI Expert

The expert will establish the reporting foundation and deliver the three most important reports. Business users will build the remaining reports using the reusable semantic model.

Key Responsibilities

  • Identify all SAP BO reports used by Hugin and document their owners, users, and usage frequency.
  • Agree with the business which reports must be rebuilt and identify the three highest-priority reports.
  • Assess reports used as email templates for Hugin vendors, including week plans, and define how their generation and distribution will be replaced.
  • Set up the Power BI workspace and coordinate required access, connectivity, and firewall changes.
  • Validate data availability and build a reusable semantic model for Hugin reporting.
  • Recreate and validate key measures and business logic.
  • Develop the three priority reports for business users to test and verify the reports and data model.
  • Provide documentation and knowledge transfer so business users can build the remaining reports.
  • Coordinate UAT, resolve defects, and deploy the solution to production.
  • Support transition and SAP BO retirement once required replacement capabilities are ready.
  • Legacy Report Analysis & Reverse Engineering: Inspect existing Crystal Reports and SAP BusinessObjects reports to thoroughly understand sections, groups, suppression formulas, cross-tabs, subreports, parameters, and complex formulas.
  • Distribution & Integration: Understand basic integration mechanisms (endpoints, API calls, etc.) to ensure automated email distribution and report delivery processes transfer smoothly to the new setup.
  • Source Data Investigation & Validation: Utilize strong SQL skills to investigate source data, analyze functions/views, validate report results, and troubleshoot duplicates or missing records.

Success Factors

  • A complete report inventory and agreed migration scope are available.
  • Power BI connectivity, access, and the reusable semantic model are established.
  • Key measures and business logic are reconciled against existing SAP BO outputs.
  • The three priority reports pass business UAT and are deployed to production.
  • Business users can independently build the remaining reports.
  • Vendor communications, including week plans and email templates, have a validated replacement.
  • Required reporting capabilities are ready before SAP BO is phased out at the end of 2027.

Location:

Gentofte, Denmark

The consultant is expected to conduct work from the specified location mentioned in the requisition. They are mandated to support Orsted’s offices for a minimum of 3 days per week. Fully remote work is not allowed unless prior agreement with Orsted’s hiring manager. These rules could be modified in the future at Orsted’s discretion.

Requirements:

Technical Skillset Required:

  • Power BI Suite: Power BI Paginated Reports / Report Builder (RDL), Power BI semantic models, DAX, and Power Query (M).
  • Databases: Strong SQL / PostgreSQL proficiency.
  • Legacy Systems: Crystal Reports / SAP BusinessObjects.
  • Integration: Basic understanding of endpoints, API calls and automated report distribution triggers.

    Experience with SAP BusinessObjects and/or Crystal Reports migrations is highly preferred.

Jobdetaljer

  • Varighed

    5 mdr.

  • Lokation

    Copenhagen, Denmark

  • Deadline

    -

  • Søg job