Data and Reporting Analyst (MS Power BI)

Posted on November 4, 2019


Sun Prairie, WI

Position Details


Job Summary

Beacon Technologies is looking for a Data and Reporting Analyst (MS Power BI) to work in Sun Prairie, WI.

Job Description
A Data Analyst (Power BI) is needed to support the NA Enterprise PMO. The PMO oversees a multitude of projects (approx. 40 projects on an annual basis) and portfolios with the objective to constantly improve project execution, quality, and fiscal oversight. The PMO develops, governs and implements processes and policies, supports PM personnel, gathers data and prepares analysis and presentations to management and governing boards. The Data Analyst will work with the Project Online team in developing Power BI reports along with supporting the daily back-office operations of the PMO which includes compiling of metrics and trends on project execution and quality, project resource and demand, maintain or updates PPM tools (Project Online), PMO templates and monthly PMO routines e.g. report creation, communication, deliverable tracking. The successful candidate should also a have keen attention to details, affinity for working with people, and possess a “can do” attitude and work towards stringent timelines.


  • Development and enhancements of PMO reports using Power BI, Excel, Project Online and SharePoint
  • Support the PMO team with their daily routines, e.g. Meeting coordination, follow-up on tasks and meeting outcomes, gather data for status reporting and work closely with PMs, ensure that sufficient records of meetings and decision-making are in place
  • Help to maintain and improve PMO tools like Sharepoint, Project Online, PWA, MS Power BI (e.g. site collections, user set-up, schedule settings, etc.) to ensure ease of system use, contribute to further automation and improvements of Sharepoint and Project Online
  • Review the existing monthly data points and identify project trends and proactively communicate and raise awareness of risk and issues on project execution
  • Accountable for continuous and accurate gathering of project and portfolio data and preparation of communication and reports related to PMO

Required Skills

  • Candidate must possess an eye for details and passion for data analytics and adherence to processes
  • Strong experience with Power BI and all reporting aspects
  • Ability to aggregate information into concise information as input into presentation for project stakeholders and management and translate into further PMO improvements
  • Effective team player and self-starter with exceptional communication skills to work with on- and offsite teams
  • Understanding the principles of a software development lifecycle and Project Management
  • Ability to analyze, map and integrate data from multiple sources to form opinions and recommendations
  • Strong knowledge of data management and reporting, demand planning and forecast analysis
  • Strong knowledge of technology to control and safeguard the collection, organization, structure, processing and delivery of data
  • Ability to work independently and manage work with tight deadlines reliably and efficiently

Work Experience

  • Minimum of 3+ years with MS Project, PWA/Project Online (user and administrative capabilities)
  • Minimum of 3+ years MS Power BI skills – ability to create Power BI reports and pro-actively use analytical skills to discover trends in project execution and develop key PMO metrics.
  • SharePoint experience in at least one of the following
    • SharePoint 2013 O365 version (e.g. Designer skills; add custom lists, modify document libraries, site collection admin skills)
    • SharePoint Designer 2013 (workflows) – Designer skills, create and modify workflows and custom actions for SharePoint
    • InfoPath Designer 2013 (custom forms) – Designer skills, create and modify forms, create and modify rules, including data connections
  • Experience using MS Office/ O365 suite, JIRA
  • 3+ years of work experience either as data analyst/ business analyst supporting Project Management function

Formal Education: (minimum requirement to perform job duties)

  • Bachelor’s Degree or equivalent combination

​​​​​​​APPLY NOW!