Tech Stack
AzureCloudCyber SecurityETLIoTLinuxPythonSQL
About the role
- Design, develop, and maintain interactive Power BI dashboards for key security metrics (incident response times, vulnerability management, threat intelligence, compliance reporting)
- Connect to and model data from Claroty data sources such as xDome, CTD, and xSA platforms
- Develop complex DAX measures and calculated tables to quantify and track cybersecurity risk, maturity, and effectiveness
- Optimize Power BI dashboards for performance and scalability; publish, manage, and secure reports and datasets applying Row-Level Security (RLS)
- Create and maintain comprehensive technical documentation for Power BI security reports, including data sources, data models, DAX logic, and business rules
- Document dataflows and data lineage to ensure data governance and a single source of truth for security analytics
- Utilize scripting (Python, PowerShell) to automate ETL processes from various security platforms and develop custom scripts to pull data from security APIs (e.g., Microsoft Graph Security API, Microsoft Defender for Endpoint API)
- Work with Microsoft 365 platforms to leverage security data from SharePoint Online and related services
- Assist in development and maintenance of data-related security applications or scripts as needed
- Transform raw security data into actionable insights for customer reporting and ensure technical documentation is accurate for compliance
Requirements
- Proven experience as a Power BI Developer or Data Analyst, with a strong portfolio of dashboards and reports in a cybersecurity context
- Demonstrated experience with DAX and Power Query (M Language)
- Hands-on experience with Microsoft 365 services and the Microsoft Graph API, particularly security-related endpoints
- Strong proficiency in a scripting language such as Python or PowerShell for data manipulation and automation
- Experience with SQL for querying and managing data
- Familiarity with cybersecurity frameworks (e.g., NIST CSF, CIS Controls, ISO 27001)
- Excellent analytical and problem-solving skills, with a keen attention to detail
- Ability to translate complex security data and concepts into clear, concise, visually appealing business insights
- Exceptional written and verbal communication skills; excellent report-writing skills
- Strong understanding of data model principles (Star Schema, Snowflakes, etc.)
- Knowledge of data governance and security best practices, including data residency and data classification
- Desired 3+ years work experience in delivering data driven solutions
- Experience with Azure, Power BI, Python and SQL creation and scripting
- Experience with the application of threat modelling or other risk identification techniques
- Understanding of IT and OT network communication protocols
- Knowledge and understanding of various security control frameworks (e.g. IEC62443, NERCCIP, NIST, NCSC CAF)
- Familiarity with Linux and Windows operating systems and administrative tools
- Ability to successfully communicate & present to a range of technical and executive stakeholders
- Fluent English language skills (verbal and written)