Cybersecurity Metrics Analyst

As a Cybersecurity Metrics Analyst, you will play a crucial role in ensuring the security and compliance of our organization. You'll be responsible for analyzing, measuring, and reporting on various security metrics to enhance our overall security posture. Your expertise will guide decision-making and risk management efforts.

Job Description

We are seeking an experienced and detail-oriented Data Analyst with extensive expertise in building dashboards and analyzing data, specifically in the context of Security Operations. The ideal candidate will have hands-on experience with Microsoft Power BI and SQL Server, a solid understanding of data lakes, and exposure to tools like Databricks. This role requires the ability to work with APIs to extract data from various sources and automate workflows using Power Automate or similar tools.

You will play a critical role in designing and supporting dashboards that provide key insights into the organization's security posture, empowering decision-making at both operational and executive levels.

Responsibilities

• Dashboard Development: Design, develop, and maintain advanced dashboards using Microsoft Power BI to visualize and track security metrics and KPIs.
• Data Integration: Work with APIs to extract data from multiple sources, ensuring data accuracy, consistency, and completeness.
• Data Lake Management: Collaborate with the team to structure and optimize data lakes to store and retrieve large datasets efficiently.
• SQL Server Management: Write and optimize complex SQL queries to process, analyze, and transform data for dashboard use.
• Security Metrics: Develop dashboards tailored to Security Operations, including incident trends, threat intelligence, and compliance metrics.
• Automation: Use Power Automate or similar tools to streamline data workflows and automate reporting processes.
• Collaboration: Work closely with Security Operations, IT, and executive stakeholders to understand requirements and deliver actionable insights.
• Documentation: Maintain detailed documentation of dashboard structures, data sources, and APIs used for integration.

Qualifications

Required Skills and Experience:

• Education: Bachelor’s degree in computer science, Data Analytics, Information Systems, or a related field.
• Experience:
  • At least 5 years of experience in data analytics and dashboard development.
  • Proven track record of building Security Dashboards or supporting Security Operations metrics.
• Technical Skills:
  • Expertise in Microsoft Power BI and SQL Server.
  • Hands-on experience with Data Lakes and tools like Databricks.
  • Proficiency in working with APIs for data extraction and integration.
  • Knowledge of automation tools such as Power Automate or similar.
• Security Knowledge: Familiarity with cybersecurity frameworks like NIST, ISO, GPDR, FedRAMP, SOX, incident management processes, and security metrics.

Preferred Skills:

• Experience in handling large datasets and performance optimization for real-time dashboards.
• Knowledge of cloud platforms like Azure for data storage and processing.
• Familiarity with scripting languages such as Python or R for advanced data analysis.
• Certifications in Microsoft Power BI, SQL, or security domains (e.g., CISSP, Security+).

Key Attributes

• Strong analytical and problem-solving skills.
• Excellent communication skills to work effectively with technical and non-technical stakeholders.
• Ability to handle multiple projects and deliver results in a fast-paced environment.

Passion for using data to solve problems and improve decision-making.