Data Analyst

This role will support the identification, creation & reporting of data metrics used to enforce Information Security policies and programs. These metrics are reviewed and tracked by Process Owners to drive security compliance & governance, control implementations, and allow process improvements. Ideally targeting someone experienced in data warehousing and Power BI. This person will need to be skilled in identifying & analyzing process data , sourcing & extracting data from disparate sources, and creating dashboards. This person will need to build datasets necessary to generate policy-tracking metrics and executive-level dashboards of these metrics. Responsibilities Our client has a backlog of work and needs a Data Analyst to: Identify policy and security program metrics to demonstrate compliance of security protocols Further mature current policy metrics to include the new aspects of policies, enhancing process tracking by using more data Develop data necessary to track 20 separate policies /standards for governance and compliance, all coming from many unique data sources. Create executive-level dashboards for each of the non-compliant policy models, combining many disparate data sources into one Power BI summary The data sources are unique to each policy and many times the data needed is housed in 'systems' such as InTune, Audit log reports, Active Directory, Service Now, One Trust, CourseMill, SharePoint site activity, Social Chorus, Knowbe4, and Cofense. In order to measure compliance, for each policy it is necessary to a) identify the source system(s) housing the data that will give us the policy compliance insights - which sometimes requires process changes to capture the data, and b) Pulling the data into Power BI for modeling by gaining direct access to the system, extracting data from the system, and building a historical dataset (this is the case the majority of the time). Requirements Ability to source & extract data from disparate sources for a specific purpose Experience with Informatica to create ETL pipelines Data cleansing and preparation Data analysis and exploration Create data visualizations Create dashboards, analytics, and reports Critical thinking Problem solving Attention to detail Business strategy and operations understanding Writing and communication Statistical knowledge Domain/Active Directory knowledge Programming language (specifically SQL, Python, and R) SSIS is a plus knowledge of using and working with APIs Cyber Security metrics experience is a plus Masters of Science in Business Informatics a plus Background Check :Yes Notes : Selling points for candidate : Project Verification Info :The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA: Blanket Approval Received Client Letter: Will Provide Candidate must be your W2 Employee :Yes Exclusive to Apex :No Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project :0011049 | AgileOne Archer Daniels Midland Co. Master Job Title : Branch Code :