Sql data analyst Jobs in Cincinnati oh

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

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 :