Business Intelligence Data Analyst

Ernst & Young LLP ( EY India ); Bengaluru; On-site; INR 2,000,000 - 4,000,000; Full time

Benefits offered by this job

Continuous learning

Flexible working

Diverse and inclusive culture

Job summary

Ernst & Young LLP ( EY India ) is seeking a Senior Business Intelligence Data Analyst to drive BI/analytics initiatives across global teams. You will analyze compliance data, build automated dashboards and collaborate with stakeholders to optimize risk controls and information security programs.

The role emphasizes advanced SQL, ETL, data visualization with Power BI/Tableau, and cloud platform exposure (Azure/GCP/AWS). Strong communication and leadership are essential.

Qualifications

• 6–8 years of work experience in Business Intelligence/Data Analytics/Data Engineering.
• Bachelor's or master’s degree in Information Systems, Computer Science, Mathematics or related field.
• Expert in PowerBI; Advanced SQL/SSIS packages knowledge.

Responsibilities

• Prepares reports based on business and technical requirements.
• Designs and implements automations of business processes.
• Identifies data sources and migrates data between environments.
• Creates and maintains good relations with stakeholders.
• Estimates impact of changes.
• Collaborates across teams to remove process obstacles.
• Proposes solutions to improve processes.
• Communicates effectively across the organization to foster dialogue.
• Coaches others on quality reviews and drafting complex reports.
• Monitors and improves tools and techniques; maintains documentation.
• Evaluates delivery mechanisms, tools and techniques, and implements standards.

Skills

SQL (T-SQL)

ETL processes

MS SQL Server

Data Visualization

Power BI

Power Automate

Power Apps

Azure

Google Cloud

AWS

SSIS

Statistics

Communication

Stakeholders management

Project management

Education

Bachelor's or Master’s degree in Information Systems, Computer Science, Mathematics or related field

Certifications (AZ-900, AZ-400, PL-100, PL-400, PL-200, DA-100)

Security certifications (CISSP, CCSP, GIAC, CISA)

Job description

Business Intelligence Data Analyst 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.

Business Intelligence Data Analyst Today’s world is fueled by vast amounts of information. Data is more valuable than ever before. Protecting data and information systems is central to doing business, and everyone in EY Information Security has a critical role to play. Join a global team of almost 950 people who collaborate to support the business of EY by protecting EY and client information assets! Our Information Security professionals enable EY to work securely and deliver secure products and services, as well as detect and quickly respond to security events as they happen. Together, the efforts of our dedicated team helps protect the EY brand and build client trust. Within Information Security we blend risk strategy, digital identity, cyber defense, application security and technology solutions as we consider the entire security lifecycle. You will join a team of hardworking, security-focused individuals dedicated to supporting, protecting and enabling the business through innovative, secure solutions that provide speed to market and business value.

The opportunity

The Information Security Compliance team is looking for someone to work with the analysis of compliance related information drawn from a wide variety of sources in order to derive patterns and trends regarding security control operations and effectiveness. The Compliance team is responsible for supervising and leading information security risk across a highly sophisticated and global network of technologies, platforms, and services. The results of the team’s analysis will not only drive remediation efforts as well as supporting investment decisions to further reduce information risk.

Your key responsibilities

Your key responsibilities Your key responsibilities:

• Prepares reports based on business and technical requirements
• Designs and implements automations of business processes
• Identifies different data sources and migrates data between environments
• Creates and maintains good relation with different groups of stakeholders
• Estimates impact of required/proposed changes
• Works across multiple teams to identify and remove obstacles in processes
• Proposes solutions in order to improve existing and future processes
• Communicates well up, down, and across the organization, adapting language and style to connect with all parties and encouraging a lively exchange on ideas, issues and questions being raised
• Promotes a collaborative approach when influencing or negotiating, by actively soliciting relevant inputs from all the parties and striving to create options that generate mutual gains
• Expresses thoughts effectively and convincingly using appropriate verbal and non-verbal behaviors to reinforce logical, concise messages
• Coaches others on the process of conducting quality reviews
• Coaches others on drafting complex reports
• Monitors the effectiveness of existing tools and techniques and implements improvements
• Leads the production and maintenance of documentation
• Evaluates documentation of delivery mechanisms, tools and techniques
• Implements technical documentation standards, guidelines and leading practices

Skills and attributes for success

• Advanced knowledge and experience of SQL (preferably T-SQL)
• Experience with ETL processes
• MS SQL Server management experience - creating/modifyig tables, views, stored procedures, jobs, etc
• Experience in Data Visualization and usage of PowerBi/Tableau/Spotfire platforms
• Knowledge of Power platform components: Power BI, Power Automate, Power Apps.
• Knowledge of Azure/Google Cloud/AWS cloud environments and its various components.
• Knowledge of MS Visual Studio - SSIS packages management/creation
• Statistics
• Good Technical aptitude, problem solving and ability to quickly learn and master new topics and domains.
• Excellent communication skills; written and verbal.
• Stakeholders managemnt
• Project Management

To qualify for the role

• To qualify for the role you must have 6 – 8 years of work experience in Business Intelligence/Data Analytics/Data Engineering
• Bachelor's or master’s degree in Information Systems, Computer Science, Mathematics or another related field
• Expert in PowerBI
• Advanced knowledge of SQL/SSIS packages
• Data analysis skills with strengths in drilling into underlying databases for discovery and seeing opportunities and trends, and translating these into understandable and meaningful business outputs
• Demonstrated ability to translate findings into clear insights and then communicate verbally and through compelling written documents
• Ideally, you’ll also have Certifications (AZ-900, AZ-400, PL-100, PL-400, PL-200, DA-100)
• At least one of the following security certifications: CISSP, CCSP, GIAC, CISA
• Familiarity with Active Directory Security (Specially Azure AD)
• Familiarity with Azure environment
• Knowledge of security frameworks especially ISO 27001.
• Knowledge in Governance, Risk and Compliance (GRC) frameworks and tools (preferably Archer GRC)
• Knowledge of O365 security
• Knowledge of Project management

What we look for

The Information Security Compliance team is looking for people who have seemingly insatiable curiosity to ask questions and the drive to do what is needed to draw reasonable conclusions from the information available.

What we offer

As part of this role, you will work in a highly coordinated, globally diverse team with the opportunity and tools to grow, develop and drive your career forward. Here, you can combine global opportunity with flexible working. The EY benefits package goes above and beyond too, focusing on your physical, emotional, financial and social well-being. Your recruiter can talk to you about the benefits available in your country. Here’s a snapshot of what we offer:

• Continuous learning: You will develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We will provide the tools and flexibility, so you can make a significant impact, your way.
• Transformative leadership: We will give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You will be accepted for who you are and empowered to use your voice to help others find theirs.

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