OA-OIT A4 Emerging SME )Location: Harrisburg, PADuration: 8 MonthsThe selected candidate will be responsible for creating and managing Business Intelligence (BI) reports utilizing the Microsoft Power-BI platform for the Enterprise Information Security Office (EISO). These reports are intended to provide executive leadership with key performance indicators on our cybersecurity programs and initiatives.The data on which these reports are based is taken from a variety of sources including both structured and unstructured data. Currently these reports are manually generated and updated.
In addition to refining the existing reports and the creation of possible new ones, the selected candidate will work with the staff responsible for these data and endeavor to streamline and automate the data collection and generation of these reports.The selected candidate will normally work in Harrisburg, PA, at 5 Technology Park. For the duration of the COVID-19 pandemic emergency, however, the selected candidate is required to telework.Duties:Maintain the EISO Power-BI which is hosted in Microsoft AzureProvide updates to the service to automate data collection and report generation, working with the data owners as directed by EISO staffWork with EISO staff to consider and implement new reportsWork with EISO staff to consider and implement new management dashboardsSkill sets:Power-BIMaintain the application as neededUpdate existing reports and dashboardsCreate new reports and dashboardsIntegrate both structured and unstructured data as the foundation of reports, automating the process as possibleMicrosoft Office – for data collection and progress reportingWordExcelPowerPointWorking knowledge of SIEM and EGRC applicationsSkill - Required / Desired - Amount of Experience - HavePOWER BI - Maintain the application as needed - RequiredPOWER BI - Update existing reports and dashboards - RequiredPOWER BI - Create new reports and dashboards - RequiredPOWER BI - Integrate both structured and unstructured data as the foundation of reports, automating the process as possible - RequiredMicrosoft Office – for data collection and progress reporting - o Word o Excel o PowerPoint - RequiredWorking knowledge of SIEM and EGRC applications - Required