Advertising Data Analyst Jobs in Chicago, IL

Description

W2 role Local to IL preferred

Job Description

• Identifying and aggregating data sources to support executive level metrics and reporting related to compliance adoption and security trending
• Designing dashboard and dashboard filtering/look and feel based on requirements for executive level reporting -
• Defining automation and supporting offline/async reporting until automated dashboard items can be put in place.
• Working with spreadsheets and mass data extracts for offline reporting as needed
• Working with AWS Quicksight for dashboard design and metrics extraction
• We are seeking a Business Intelligence Analyst to drive the measurement visualization and reporting of our Digital Identity Access Management IAM program.
• This individual will design and deliver advanced analytics and dashboards using Amazon QuickSight helping cybersecurity and compliance leaders monitor identity control performance risk posture and adherence to frameworks such as NIST 800-53 and Zero Trust Identity principles.
• You will collaborate closely with Identity Engineering Cyber Governance and Risk Management teams to transform IAM data into clear actionable insights that improve our enterprise identity security posture and enable evidence-based decision-making.

Key Responsibilities: Dashboarding Analytics

• Design build and maintain Amazon QuickSight dashboards to visualize IAM KPIs KRIs and operational trends. -
• Develop automated data pipelines and reports using AWS data services e.g. S3 Redshift Athena Glue.
• Translate identity compliance controls from NIST 800-53 especially AC IA and AU families into quantifiable data-driven metrics.
• Create executive-level visualizations that communicate compliance risk and maturity of IAM capabilities.
• Ability to translate technical data into clear visualizations and stories for non-technical audiences.

Identity Access Management Metrics

• Develop and maintain metrics libraries mapped to IAM controls such as:
• Access provisioning/deprovisioning timeliness
• MFA and SSO adoption enforcement
• Identity lifecycle automation success rates
• Role/entitlement review compliance
• Monitor and analyze IAM data to identify anomalies trends and optimization opportunities aligned with Zero Trust and least privilege principles
• Governance CompliancePartner with Cyber Governance to produce recurring compliance dashboards that demonstrate control effectiveness aligned with NIST 800-53 ISO 27001 and internal audit requirements.
• Support continuous monitoring and audit-readiness through data-backed evidence and self-service reporting.
• Define metric definitions thresholds and data quality standards to ensure consistency and traceability.

Required Qualifications

• 3-5 years of experience in a Business Intelligence Data Analytics or Cybersecurity reporting role.
• Strong proficiency in Amazon QuickSight SQL and data modeling for large complex datasets.
• Solid understanding of Identity Access Management concepts including:
• Microsoft Entra ID Azure AD user and group management
• Duo Security MFA deployment and reporting
• SSO and federation standards SAML OIDC OAuth

This Person Will Be Assisting With

• Increased visibility into IAM control performance through automated dashboards.
• Reduced manual reporting effort across compliance and identity teams.
• Improved measurement of MFA SSO and provisioning compliance against NIST 800-53.
• Enhanced leadership decision-making through data-driven insights and trend analysis.
• Privileged Access Management PAM and identity lifecycle workflows
• Knowledge of NIST 800-53 access control and identity-related control families. -
• Experience building or automating metrics and dashboards to support security compliance and executive reporting.
• Excellent communication skills and the ability to translate technical data into business-friendly insights.