Technology Data and Reporting Analyst-SQL-Power BI

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 Office-Technology Data and Reporting Analyst (SQL-Power BI) - Supervising Associate

At EY, we offer you the opportunity to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of yourself. We value your unique voice and perspective as we strive to help EY become even better. Join us to create an exceptional experience for yourself and contribute to a better working world for everyone.

The Opportunity

We are looking for an analytical Technology Data and Reporting Analyst to join our team. The ideal candidate will utilize their expertise in data analysis, reporting, and business intelligence to influence decision-making throughout the organization. This role involves managing extensive raw data, deriving data-driven insights, and producing high-quality reports for senior leadership.

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.

Technical Expertise:

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.

Qualifications:

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