Architect - Data Engineering

Pepsico; Hyderabad; Presencial; INR 1.200.000 - 2.400.000; Jornada completa

Descripción de la vacante

PepsiCo is seeking a Senior Cybersecurity Data Engineer to advance the security metrics program. You will develop dashboards and data models, ingest data from multiple sources, and provide risk-based insights to global leadership, including the Board.

The role emphasizes strong analytics, reporting, and collaboration with cross-functional teams. The position requires extensive SQL/ETL experience, Azure Data Factory, Databricks, and a deep understanding of information security metrics.

Formación

• Bachelor's degree in Statistics, Mathematics, Computer Science or related discipline.
• 8+ years of experience with SQL Server or similar relational databases.
• 8+ years of experience writing ETL or similar data ingestion methods.
• 6+ years of experience with Azure cloud services (Azure Data Factory, ADLS).
• 6+ years of experience with Databricks and DBSQL.
• Strong experience in collecting and aggregating data for reporting and archiving of statistical data.
• Proven leadership in developing, reporting, and communicating analytic results.
• Strong communication and relationship-building skills.
• Familiarity with information security frameworks (ISO, NIST, COBIT).
• Experience identifying and reporting value-added KRIs and KPIs related to information security or IT.
• Ability to understand data quality indicators and improvements.

Responsabilidades

• Contribute to the development and implementation of the security metrics program.
• Maintain internal stakeholder and data provider relationships.
• Ensure complete, accurate, and timely reporting of analytics and insights to stakeholders.
• Document requirements for new reporting and implement BI capabilities, centralized data collection, and automated dashboards/reports.
• Define data models and build efficient data ingestion processes for reporting.
• Identify and validate data sources input from stakeholders and incorporate feedback for risk-based metrics.
• Communicate information security risks identified by data mining across sources.
• Define, implement, and monitor best practices for the security metrics program.
• Design and deploy mechanisms and tools for data harvesting and identify key risk indicators.

Conocimientos

SQL

ETL

Analytics & reporting

Leadership

Communication

Information security knowledge

Risk indicators

Educación

Bachelor's degree in Statistics, Mathematics, Computer Science

Herramientas

Azure Data Factory

ADLS

Databricks

DBSQL

Descripción del empleo

Overview

The cybersecurity Data Eng Sr Engineer is a role within the PepsiCo cybersecurity organization to assist in the development and sustainment of the security metrics program. The candidate will contribute to the development and maturity of the security metrics program including people, process and technology. They will support PepsiCos security agenda by providing risk based insights for varied global audiences ranging from operational leaders to PepsiCos Board of Directors through data and dashboard development.

Responsibilities

The candidate will:

• Contribute to the development and implementation of the security metrics program
• Be responsible for maintaining internal stakeholder and data provider relationships
• Be responsible for ensuring complete, accurate, and timely reporting of analytics and insights to stakeholders
• Be responsible for documenting requirements for new reporting, including recommending and implementing business intelligence capabilities, centralized data collection and archival, and automated dashboards and reports
• Be responsible for defining data models, and building out efficient data ingestion processes for reporting
• Be responsible for identifying and validating data sources input from stakeholders and incorporating feedback in the development of risk-based metrics
• Contribute to the identification and effective communication of information security risks identified by data mining a single source or aggregating multiple data sources
• Be responsible for defining, implementing, and monitoring best practices and processes for the security metrics program
• Enable design and deployment of the mechanisms and tools for data harvesting and determine key risk indicators

Qualifications

• Bachelor's degree in Statistics, Mathematics, Computer Science, or related discipline
• 8+ years of experience in SQL Server, or similar relational database methodologies
• 8+ years of experience writing ETL or similar data ingestion methods
• 6+ years of experience in Azure cloud services such as Azure Data Factory, ADLS etc
• 6+ years of experience in Data Bricks and DBSQL
• Strong experience in the collection and aggregation of various data sources for reporting and archiving of statistical data
• Strong experience and proven leadership in developing, reporting, and communicating analytic results
• Strong communication and relationship building skills
• Working knowledge of information security industry frameworks (e.g. ISO, NIST, COBIT)
• Experience with identifying, analyzing, and reporting on value-added key risk indicators and key performance indicators related to information security, cybersecurity or broader IT
• Candidate must have strong analytical skills to determine how a system should work and how changes in conditions, operations, and the environment will affect outcomes
• Candidate must be able to understand information security risks and determine ways to identify measures that will accurately reflect the current degree of risk
• Knowledgeable in the Information Security domain
• Candidate must be able to identify measures or indicators of data quality and the actions needed to improve or correct performance, relative to the goals of the system