Data Scientist IT Security Analytics & Reporting

Sony Latin America Inc.; Ciudad de México; On-site; MXN 600,000 - 900,000; Full time

Job summary

Sony is seeking a Data Scientist – IT Security Analytics & Reporting to transform large data volumes into strategic insights for global decision making. You will design analytics solutions, integrate multiple data sources including CMDB, endpoint security data, identity management, SCCM/Microsoft Configuration Manager, and cloud inventories, and build executive dashboards.

You will collaborate with international teams to deliver a data-driven view of IT security, develop security KPIs, automate

Qualifications

• Experience with data analysis and building dashboards for executives.
• Strong SQL skills and large-volume data handling.
• Experience with CMDB/Asset Management data and reconciliation.
• Hands-on with SCCM/Microsoft Configuration Manager or similar tools.
• Familiar with Microsoft Fabric, Data Warehouse, Lakehouse, or similar platforms.
• Proven ability to work with cloud inventories (AWS, GCP, Azure).
• Advanced English for collaboration with international teams.

Responsibilities

• Manage end-to-end data lifecycle: extraction, transformation, cleansing, analysis, and visualization.
• Build and maintain executive dashboards and security KPIs for CISO-level reporting.
• Design dashboards using Power BI and Microsoft Fabric or similar platforms.
• Integrate data from CMDB, endpoint security, identity systems, and cloud inventories.
• Develop scalable data models and reporting structures for global security metrics.
• Automate analytics processes and recurring reporting for efficiency.
• Document data models, pipelines, and KPI definitions for reproducibility.
• Collaborate with global teams across regions to translate needs into analytics solutions.

Skills

Power BI

SQL

Data analysis

Dashboards

Data modeling

Cloud data sources

Stakeholder communication

End-to-end data lifecycle

Tools

Power BI

SCCM

CMDB

Microsoft Fabric

Azure

AWS

GCP

Data Warehouse

Job description

At Sony, we are looking for a Data Scientist – IT Security Analytics & Reporting who will help us transform large volumes of information into strategic insights to support decision-making within a global organization.

This position will be responsible for designing analytics solutions, integrating multiple data sources, including CMDB, endpoint security data, identity management, SCCM/Microsoft Configuration Manager, and cloud environment inventories, developing executive dashboards, and generating security metrics that provide visibility into trends, improvement opportunities, and the organization’s overall security posture.

You will work with international technology, infrastructure, and security teams, collaborating across regions and operating companies to build a comprehensive, data-driven view of IT security.

Responsibilities

• Manage the end-to-end data lifecycle, including data extraction, transformation, cleansing, analysis, correlation, and visualization.
• Build and maintain executive dashboards and security KPIs for CISO-level reporting, providing clear visibility into security posture, trends, gaps, and opportunities for improvement.
• Design and maintain dashboards using Power BI and Microsoft Fabric or other modern data platforms.
• Create scalable data models and reporting structures to support global security metrics.
• Integrate and analyze information from multiple platforms, including CMDB/Asset Management, endpoint security solutions, SCCM/Microsoft Configuration Manager, identity systems, and cloud environments.
• Integrate cloud inventory and security data from AWS, GCP, and Azure.
• Reconcile and correlate asset information from different sources to establish a reliable and consistent view of technology assets across regions.
• Analyze large volumes of data to identify trends, patterns, anomalies, data quality issues, and opportunities for improvement.
• Develop security KPIs and executive reports for global leadership and CISO-level stakeholders.
• Automate analytics processes and recurring reporting activities to improve efficiency and data reliability.
• Document data models, pipelines, refresh processes, KPI definitions, and reporting logic.
• Collaborate with global teams and stakeholders across different regions and time zones to understand information needs and translate them into effective analytics solutions.
• Support data-driven discussions around security posture, remediation priorities, and operational performance.

Requirements

• Experience as a Data Analyst, BI Analyst, Analytics Engineer, Data Scientist, or Data Engineer.
• Strong experience with Power BI, including data modeling, DAX, and visualization.
• Strong SQL skills and experience working with large volumes of data.
• Experience managing databases and integrating multiple data sources.
• Experience creating dashboards and reports for different levels of an organization, including executive audiences.
• Experience with CMDB / Asset Management data and reconciling information across multiple sources.
• Hands-on experience with SCCM / Microsoft Configuration Manager or other endpoint management/security platforms.
• Experience working with Microsoft Fabric, Data Warehouse, Lakehouse, or similar modern data platforms.
• Familiarity with cloud environments such as AWS, GCP, and/or Azure.
• Ability to analyze complex information and translate it into clear insights and recommendations.
• Strong communication and stakeholder-management skills, with the ability to collaborate across regions, teams, and time zones.
• Advanced English skills for collaboration with international teams.