Security Data Engineer

EY; Bengaluru Urban; On-site; INR 3,500,000 - 5,500,000; Full time

Benefits offered by this job

Flexible working arrangements

Career development support

Total Rewards package

Job summary

EY is seeking a Security Data Engineer in Bengaluru to design and maintain large-scale data pipelines, leverage SQL for ETL, and work with Data Bricks and Data Lake technologies. You will collaborate with security teams to align data needs with security tools and create documentation and dashboards for stakeholders.

Ideal candidates have 7–10 years in IT, strong Python/PowerShell scripting, and experience with Azure cloud services and data visualization tools like Power BI or Tableau.

Qualifications

• Degree in Computer Science or related discipline, or equivalent work experience.
• 7–10 years working within Information Technology in a global firm.
• Knowledge of Azure Data Lake, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Notebooks, PySpark, Spark SQL.
• Working knowledge of data analysis programming or scripting languages, such as Python (with pandas, NumPy) or PowerShell.
• Experience with Azure SQL and ETL processes.
• Certifications in data visualization or analytics platforms.
• Experience with cloud platforms (AWS, Azure, GCP).
• Programming languages such as Python or Scala.
• Familiarity with data visualization tools (Power BI, Tableau).

Responsibilities

• Design, develop, and maintain robust data pipelines to process and analyze large datasets.
• Utilize SQL for data extraction, transformation, and loading (ETL) processes.
• Work with Data Bricks and Data Lake technologies to manage and optimize data storage and processing.
• Collaborate with security teams to understand data requirements and integrate data from various security tools.
• Create and maintain documentation for data pipelines, processes, and workflows.
• Monitor and troubleshoot data pipeline performance and data quality issues.
• Develop data models and visualizations to present security insights to stakeholders.
• Stay updated with industry trends and best practices in data engineering and security analytics.

Skills

SQL proficiency

Databricks

Azure Cloud

Security analytics

Data modelling

ETL processes

Python

PowerShell

Power BI/Tableau

Education

Degree in Computer Science or related field

Tools

Azure Data Lake

Azure Synapse Analytics

Azure Data Factory

Azure Databricks

Notebooks

PySpark

Spark SQL

Job description

Job Description:

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.

Security Data Engineer

EY Technology:

Technology has always been at the heart of what we do and deliver at EY. We need technology to keep an organization the size of ours working efficiently. We have 450,000 people in more than 160 countries, all of whom rely on secure technology to be able to do their job every single day. Everything from the laptops we use, to the ability to work remotely on our mobile devices and connecting our people and our clients, to enabling hundreds of internal tools and external solutions delivered to our clients. Technology solutions are integrated in the client services we deliver and is key to us being more innovative as an organization.

EY Technology supports our technology needs through three business units:

Client Technology (CT) - focuses on developing new technology services for our clients. It enables EY to identify new technology-based opportunities faster, and pursue those opportunities more rapidly.

Enterprise Technology (ET) – ET supports our Core Business Services functions and will deliver fit-for-purpose technology infrastructure at the cheapest possible cost for quality services. ET will also support our internal technology needs by focusing on a better user experience.

Information Security (InfoSec) - Info Sec prevents, detects, responds and mitigates cyber-risk, protecting EY and client data, and our information management systems.

The opportunity

The Security Data Engineer partners closely across the Security Technology Services organization and Information Security to support and management of Security products and services. This includes analytics and reporting, service reviews, service improvements, service transition, introduction and readiness, and other activities as identified pertaining to end-to-end service management of internal security technology offerings.

Your key responsibilities

• Design, develop, and maintain robust data pipelines to process and analyze large datasets.
• Utilize SQL for data extraction, transformation, and loading (ETL) processes.
• Work with Data Bricks and Data Lake technologies to manage and optimize data storage and processing.
• Collaborate with security teams to understand data requirements and integrate data from various security tools.
• Create and maintain documentation for data pipelines, processes, and workflows.
• Monitor and troubleshoot data pipeline performance and data quality issues.
• Develop data models and visualizations to present security insights to stakeholders.
• Stay updated with industry trends and best practices in data engineering and security analytics.

Skills and attributes for success

• Conceptual knowledge of security applications and technologies, as well as operating system platforms including Cloud technologies
• Proven experience as a Data Engineer or in a similar role.
• Strong proficiency in SQL and experience with data manipulation and querying.
• Hands-on experience with Data Bricks and Data Lake technologies.
• Familiarity with security tools and frameworks for data extraction.
• Knowledge of data modelling, ETL processes, and data warehousing concepts.
• Excellent problem-solving skills and attention to detail.
• Proficiency in Azure Cloud services, with a strong understanding of Azure security tools such as Azure Security Center, Azure Monitor, and Azure Sentinel
• Build and maintain strong relationships across all levels of a matrixed, geographically and culturally dispersed organization
• Strong communication and collaboration skills.
• Possess knowledge of the Information Technology Infrastructure Library (ITIL) to drive compliance in Incident, Problem, and Change processes and drive as necessary

To qualify for the role you must have

• Degree in Computer Science or related discipline, or equivalent work experience
• 7-10 years working within Information Technology in a global firm
• Knowledge of Azure Data Lake, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Notebooks, PySpark, Spark SQL
• Working knowledge of data analysis programming or scripting languages, such as Python (with libraries like pandas, NumPy) or PowerShell
• Experience with Azure SQL and database management systems for data extraction, transformation, and loading (ETL) processes.
• Certifications in data visualization or analytics platforms.
• Experience with cloud platforms (e.g., AWS, Azure, Google Cloud).
• Knowledge of programming languages such as Python or Scala.
• Familiarity with data visualization tools (e.g. Power BI, Tableau).

What we look for

• Critical thinking skills demonstrating analytical and systematic approach to problem solving
• Experience working in a global virtual environment
• Excellent interpersonal, communication and presentation skills
• Good judgment, tact, and decision-making ability
• Ability to understand and integrate cultural differences and motives and to work with cross cultural teams.
• Ability to deal with ambiguity and change, and exercise appropriate time management to meet deadlines
• Ability to work autonomously but also within a team environment where necessary

What working at EY offers

We offer a competitive remuneration package where you’ll be rewarded for your individual and team performance. Our comprehensive Total Rewards package includes support for flexible working and career development, and with FlexEY you can select benefits that suit your needs, covering holidays, health and well-being, insurance, savings and a wide range of discounts, offers and promotions. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

EY is committed to being an inclusive employer and we are happy to consider flexible working arrangements. We strive to achieve the right balance for our people, enabling us to deliver excellent client service whilst allowing you to build your career without sacrificing your personal priorities. While our client-facing professionals can be required to travel regularly, and at times be based at client sites, our flexible working arrangements can help you to achieve a lifestyle balance.

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.