Security Data Engineer

EY; Gurugram District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

EY is seeking a Security Data Engineer to provide data engineering services to Information Security projects. You will design, build and optimize secure, scalable data platforms, ETL processes, and integrations that strengthen reporting, analytics and governance.

This role partners with business and tech stakeholders to enable auditable security operations. The ideal candidate has strong SQL, data modeling and governance skills, plus experience with Databricks and Azure storage.

Qualifications

• Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering or related field, or equivalent experience.
• 5+ years of experience in data engineering or security data domains.
• Security certifications (Cybersecurity, SANS, ISC2, etc.) are a definite plus.
• Strong knowledge of data governance, lineage and metadata management.

Responsibilities

• Collaborate with stakeholders to understand and document intricate data requirements and translate them into actionable technical specs.
• Create and maintain data models, data dictionaries, and data flow diagrams for security reporting, risk analytics and governance.
• Use an agile approach to design data models aligned with sprint needs and avoid over-engineering.
• Implement data lineage and metadata management to improve governance and audibility.
• Lead data profiling and quality assessments and support data validation and business rules.
• Drive modernization, automation and continuous improvement across the data engineering lifecycle.
• Assist leadership with defining data strategy and alignment to organizational objectives.

Skills

SQL & T-SQL

Databricks

Azure Blob Storage

ETL Design

ER/Dim Modeling

ER/Studio

Visio

Data Governance

AI in Modeling

Information Security

Education

Bachelor's degree in CS/DS/IS or related field

Job description

ESP Security Data Engineer

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you.

And we're counting on your unique voice and perspective to help EY become even better, too.

Join us and build an exceptional experience for yourself, and a better working world for all.

Summary

EY is seeking a Security Data Engineer to provide data engineering services to projects and programs that support Information Security technology. This individual contributor role partners with business and technology stakeholders to design, build and optimize secure, scalable data platforms, ETL and integrations that strengthen reporting, analytics, governance and operational decision-making.

Responsibilities

• Collaborate extensively with stakeholders across various business units to meticulously understand and document intricate data requirements, translating them into actionable technical specifications
• Create and maintain comprehensive documentation of conceptual, logical and physical data models, data dictionaries, and data flow diagrams that enable cyberse- curity reporting, risk analytics, compliance monitoring, vulnerability management, iden- tity governance, and security operations.
• Utilize an agile methodology to incrementally design data models according to sprint requirements, avoiding premature over-engineering
• Implement data lineage and metadata management practices, enhancing data governance and audibility
• Lead data profiling and data quality assessments and support the implementation of data validation and business rules
• Drive modernization, automation and continuous improvement across the data engineering lifecycle
• Assist leadership with defining data strategy and ensuring alignment with organizational objectives

Technical Skills

• SQL and T-SQL: Mastery of SQL and T-SQL for querying, manipulating, and managing relational databases
• Data storage: SQL, Databricks, Azure Blob Storage, Dataverse and Microsoft Graph
• ETL Processes: Proficiency in designing, documenting and implementing ETL (Extract, Transform, Load)
• ER/Dimensional Modeling: Expertise in utilizing Entity-Relationship (ER) dia grams and dimensional modeling techniques, including star and snowflake schemas for both data warehouse and OLTP environments
• Database Tools: Hands-on experience with industry-standard database modeling tools like ER/Studio, and Visio
• Data Governance: Understanding of data governance principles and practices, including data quality, metadata management, and data security.
• AI: Experience with using AI tools in modeling practices and synthetic genera tion is a plus
• Information Security: 5+ years of experience in the technical skills listed above

Business Skills

• Partner effectively with architects, engineers, product owners and projectteams to turn data models into working database tables
• Ability to work with senior business and technology stakeholders to align re quirements, priorities an delivery outcomes
• Strong consulting, communication, collaboration and problem-solving skills in a matrix environment

Education

Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering or a related field, or equivalent experience

Certifications

Security certifications or secure software experience (Cybersecurity, SANS, ISC2, etc.) are a definite plus

Advanced Degree

Advanced degree preferred.

Company

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Experience Level

Senior Level