EY Technology Data Reporting Analyst-SQL-Power BI 

India, Karnataka, Bengaluru 

184358467

Key Responsibilities:

• Drive the design, development, deployment, and maintenance of business reporting transformations using Power BI and SQL.
• Understand and articulate the business case for analysis, including the business question to address and the estimated value to be delivered.
• Design dashboards and analysis, selecting the appropriate visualization and analytics tools.
• Determine relevant data sources, collect, organize, and process data for analysis.
• Identify trends and patterns to address business questions and provide insights through reporting and data visualization techniques.
• Collaborate with other data and analytics professionals and teams to optimize, refine, and scale analysis into an analytics solution.
• Ensure the confidentiality and protection of sensitive data.
• Present actionable information and reports to senior leadership.

Skills and Attributes for Success:

• Strong analytical and numerical skills with meticulous attention to detail.
• Ability to interpret complex data and present it in an easily understandable format.
• Excellent communication and presentation skills; capable of clearly presenting complex data to non-technical audiences.
• Ability to work autonomously and collaboratively within a team.

Must-Have:

• Advanced skills and experience in Power BI Report Development.
• Proficiency in Power BI Service Management.
• In-depth knowledge of ETL processes using Power Query.
• Advanced proficiency in MS Excel, including Data Analysis Expressions (DAX).
• Ability to design and create SQL queries, interpret advanced SQL queries, and manipulate data for reporting and analysis.
• Skilled in developing PowerPoint presentations.

Good-to-Have:

• Experience with Power Apps and MS Flow.
• Familiarity with SQL databases.
• Previous experience managing a reporting and analysis function.
• Proficiency in Excel VBA.

To qualify for the role, you must have:

• A Bachelor’s degree in Computer Science, Data Science, Statistics, Information Systems, or a related field; or equivalent work experience.
• Proven work experience as a Data Analyst or in a similar role.
• Strong understanding of SQL, database structures, and related statistical software.
• Proficiency in data visualization tools such as Tableau, Power BI, or similar.
• At least 8-10 years of experience in reporting, data analysis, and stakeholder management.

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.