Technology Data and Reporting Analyst

As a Business Office-Technology Data and Reporting Analyst (SQL-Power BI) - Supervising Associate at EY, you will have the chance to utilize your expertise in data analysis, reporting, and business intelligence to influence decision-making throughout the organization. Your role will involve 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: - A Bachelors 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. As a Business Office-Technology Data and Reporting Analyst (SQL-Power BI) - Supervising Associate at EY, you will have the chance to utilize your expertise in data analysis, reporting, and business intelligence to influence decision-making throughout the organization. Your role will involve 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 A