Senior IT Security Analyst

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 decisionready 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 AIready 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 endtoend 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 semistructured 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 analyticsready 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 executivelevel dashboards, reports, and presentations to support governance forums, audits, and regulatory reviews. Translate complex security and control data into clear, businessfocused insights. Establish and maintain standards for reporting accuracy, data lineage, quality, and timely delivery. Ensure alignment between underlying SQLbased data models and reporting layers to support scalability, reusability, and selfservice 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, selfservice reporting, and metricdriven 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 insightdriven recommendations and databacked decision support. AI and Automation: Identify and leverage AIenabled 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 .