About the Role:
The IT Security Manager - BI is responsible for developing, governing, and delivering cybersecurity and technology
control business intelligence across application, business unit, division, and enterprise levels. This role acts as the
central authority for cybersecurity metrics, analytics, and reporting, ensuring consistent, accurate, and
decision‑ready insights aligned with organizational risk priorities and regulatory expectations. The manager will
collaborate closely with different functions, Technology, Risk, and business stakeholders to define standardized
metrics, KPIs, dashboards, and reporting that measure control effectiveness, operational performance, and risk
posture. Additionally, the role is accountable for defining and influencing a scalable, secure, and AI‑ready data and
analytics architecture aligned with enterprise Data & AI Center of Excellence (CoE) standards, enabling automation,
advanced analytics, and future AI use cases. The BI Manager will govern metric definitions, data quality, automation,
and delivery practices, ensure alignment with enterprise data and AI frameworks, and drive continuous
improvement of cybersecurity reporting and analytics capabilities across the organization.
Responsibilities:
- BI Platform & Data Engineering: Lead and own cybersecurity BI initiatives end‑to‑end with minimal supervision. Design, build, and maintain scalable data pipelines using Microsoft Fabric (Data Factory, Lakehouse, Warehouse, Notebooks, Dataflow Gen2, etc.). Implement and operate Medallion Architecture (Bronze/Silver/Gold) to ensure data quality, governance, and analytics readiness. Ingest structured and semi‑structured data from multiple internal and external data sources. Design, develop, and optimize complex SQL queries, views, Common Table Expressions (CTEs), stored procedures, and functions to support data transformation, aggregation, and analytical workloads. Perform data transformation, cleansing, and enrichment using SQL and PySpark. Optimize performance and cost through query tuning, indexing strategies, partitioning, incremental loads, and efficient data modeling techniques. Monitor data pipelines, resolve failures, and implement robust error handling, logging, and reconciliation controls.
- Analytics, Reporting & Visualization: Prepare and curate analytics‑ready datasets and semantic models for Power BI dashboards and reports. Define and manage cybersecurity KPIs and KRIs in partnership with Security, HR, Legal, Risk, and business teams. Develop executive‑level dashboards, reports, and presentations to support governance forums, audits, and regulatory reviews. Translate complex security and control data into clear, business‑focused insights. Establish and maintain standards for reporting accuracy, data lineage, quality, and timely delivery. Ensure alignment between underlying SQL‑based data models and reporting layers to support scalability, reusability, and self‑service analytics.
- Automation & Continuous Improvement: Automate recurring data processing, metric calculation, and reporting using Power Automate, Logic Apps, Power BI, and Excel Power Query. Identify opportunities to improve efficiency through automation, reusable data assets, self‑service reporting, and metric‑driven insights. Continuously refactor and modernize SQL and data engineering assets to improve maintainability, performance, and scalability. Stay current with Microsoft Fabric, Power Platform, and data engineering best practices and apply platform enhancements where appropriate.
- Collaboration & Influence: Collaborate with Architects to implement approved data and analytics design patterns and resolve technical gaps. Work with analysts, data scientists, and stakeholders to translate business and control requirements into secure, scalable data solutions. Serve as the BI, SQL, and reporting Subject Matter Expert (SME) for cybersecurity, influencing outcomes without direct authority. Support continuous improvement of cybersecurity programs through insight‑driven recommendations and data‑backed decision support.
- AI and Automation: Identify and leverage AI‑enabled analytics, intelligent automation, and advanced data capabilities to enhance user experience, insight generation, and operational efficiency, while ensuring alignment with enterprise Data & AI CoE standards
Skills:
- Microsoft certifications such as DP 600, AZ 900, PL 300, DP 700.
- Experience supporting security governance, audits, and regulatory reporting.
- Background in large, complex enterprise environments.
- Strong strategic thinking and independent program delivery capabilities.
- Demonstrated ability to drive change and execute complex initiatives.
- Excellent written communication skills with the ability to simplify complex technical requirements into clear, actionable language.
- Skilled in influencing across senior leadership, driving consensus, and managing competing priorities.
- Strong facilitation and presentation skills for engaging executive stakeholders.
- Excellent verbal and written communication skills across all levels of the organization with a particular emphasis on executive level presence and communication.
- Proven success in executive engagement and extensive proven leadership across complicated domains and programs.
Level criteria T3 :
- Requires in-depth conceptual and practical knowledge in primary technical job family and knowledge of related technical job families; has worked with a range of technologies
- Has knowledge of best practices and aware of the competition and market differentiators
- Solves complex technical problems; exercises judgment based on the analysis of multiple sources of information
- Works independently, receives minimal guidance; may lead projects or may have accountability for on-going activities
- Impacts a range project activities within own team and other related teams; acts as a resource for colleagues
- Explains difficult or sensitive information; works to build consensus
- Level at which career may stabilize for many years
To maintain a fair and genuine hiring process, we kindly ask that all candidates participate in interviews without the assistance of AI tools or external prompts. Our interview process is designed to assess your individual skills, experiences, and communication style. We value authenticity and want to ensure we’re getting to know you—not a digital assistant. To help maintain this integrity, we ask to remove virtual backgrounds and include in-person interviews in our hiring process. Please note that use of AI-generated responses or third-party support during interviews will be grounds for disqualification from the recruitment process.
Applicants may be required to appear onsite at a Wolters Kluwer office as part of the recruitment process.
