Business Intelligence Data Analyst

Ernst & Young Advisory Services Sdn Bhd; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

EY seeks a Business Intelligence Data Analyst to join the Information Security Compliance team. You will analyze compliance information from diverse sources to derive patterns and trends, supporting risk reduction and informed investment decisions.

You’ll design automations, manage data sources, and collaborate across teams to deliver robust dashboards using Power BI, Tableau or Spotfire, with strong SQL skills and Cloud knowledge. The role offers growth in a global, inclusive environment.

Qualifications

• 6–8 years of work experience in BI/Analytics/Data Engineering.
• Expert in Power BI with strong SQL/SSIS skills.
• Ability to translate findings into clear insights and communicate them.

Responsibilities

• Prepares reports based on business and technical requirements.
• Designs and implements automations of business processes.
• Leads production and maintenance of documentation.
• Evaluates documentation of delivery mechanisms, tools and techniques.

Skills

SQL / T-SQL

ETL processes

MS SQL Server

Power BI

Tableau

Spotfire

Power Automate

Power Apps

Cloud platforms

SSIS

Statistics

Communication

Stakeholder management

Project management

Education

Bachelor’s or Master’s in Information Systems, Computer Science, Mathematics

Tools

SSIS

MS SQL Server

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.

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:

• 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 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

• 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.

Select how often (in days) to receive an alert:

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.