Lead Engineer- BI & Reporting

PepsiCo; Hyderabad; On-site; INR 3,000,000 - 4,600,000; Full time

Job summary

PepsiCo is seeking a Cybersecurity BI and Reporting Analyst to help develop and sustain the security metrics program across global audiences, from operations leaders to the Board.

You will build and maintain dashboards, define data models, ensure timely reporting, and partner with data suppliers to deliver risk-based insights.

A strong background in SQL, Power BI, and information security frameworks plus excellent communication is required.

Qualifications

• Bachelor's degree in Statistics, Mathematics, Computer Science, or related discipline.
• 6+ years of experience in SQL Server or similar relational database methodologies.
• 6+ years of experience in Visualization tools such as Power BI.
• Strong experience in Design, Build, and Deployment of BI solutions using BI tools such as Power BI.
• 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.

Responsibilities

• 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, including BI capabilities, centralized data collection and archival, and automated dashboards and 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.
• Identify and communicate information security risks from data mining and aggregation of sources.
• Define, implement, and monitor best practices for the security metrics program.
• Enable design and deployment of data harvesting mechanisms and key risk indicators.

Skills

SQL Server

Power BI

BI dashboards

Data modeling

Stakeholder communication

Information security frameworks

Education

Bachelor's degree in Statistics/Math/CS

Tools

Power BI

Job description

Overview

The cybersecurity BI and Reporting Analyst 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 PepsiCo’s security agenda by providing risk-based insights for varied global audiences ranging from operational leaders to PepsiCo’s 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
• 6+ years of experience in SQL Server, or similar relational database methodologies
• 6+ years of experience in Visualization tools such as Power BI
• Strong experience in Design, Build, and Deployment of Business Intelligence solutions using BI tools such as Power BI
• 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