Metrics and Reporting Analyst - Senior Associate

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. 

Metrics and Reporting Analyst 

The opportunity

EY’s global enterprise technology group provides various enabling services (ERP, infrastructure, platforms, service desk) to assist over 300K employees in creating and delivering solutions and services to Fortune 500, privately held and government-like entities.

The Reporting Analyst is responsible for the creation, maintenance, and continuous improvement of reporting systems that provide critical business insights. This role involves gathering data from various sources, ensuring its accuracy, and developing reports that inform strategic decision-making. The ideal candidate will have a strong foundation in data analysis, proficiency in reporting tools, and the ability to communicate findings clearly to stakeholders across the organization.

Your key responsibilities

• Develop and maintain reports, dashboards, and scorecards that track key business metrics.
• Gather data from multiple sources, ensuring accuracy and consistency in reporting.
• Analyze data to identify trends, patterns, and insights that can drive business decisions.
• Work closely with business units to understand their reporting needs and deliver tailored solutions.
• Continuously evaluate and improve reporting processes and tools for efficiency and effectiveness.
• Provide training and support to users on how to access and interpret reports.
• Collaborate with IT and data teams to ensure data quality and the integration of reporting systems.
• Manage ad-hoc reporting requests and deliver timely responses to business inquiries.

Skills and attributes for success

• This individual should possess a combination of technical skills, analytical abilities, and leadership attributes

To qualify for the role you must have 

• Proven experience in a reporting or data analysis role.
• Experience in design, develop and deployment of rich Graphic visualizations with Drill Down and Drop up options using Power BI
• Experience in creating Power BI Reports using multiple sources. Responsible for deploying the dashboards into Power BI service (cloud-based business analytic service). Responsible for performed performance tuning on SQL Server queries and stored procedures
• Responsible for creating calculated members, measures and named sets using DAX Queries. Responsible for creating the tables and their relationships in the data Modelling.Experience with all types of transformations that are available in Power BI query editor.
• Experience with Scheduled Automatic refresh and scheduling refresh in power bi service along with using Power BI gateway.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions
• Creating Row level security with power bi and integration with Power BI service portal. Integrated custom visuals based on business requirement using power BI desktop. 
• Deliver advanced/complex reporting solutions such as Dashboards and Standardized reports using Power BI Desktop
• Strong End to end experience in designing and deploying data visualizations using Power BI.
• Experience in using Python and R scripts in Power BI dashboards
• Experience with Advanced Reporting and Dashboards in Power BI.
• Strong proficiency in MS SQL Server and prior experience in MS SQL Server performance tuning- Advanced knowledge of T-SQL, including transactions, error handling, CTEs, Row_Number/Over, hierarchical data sets. - Excellent understanding of indexes, locks, execution plans and file stats-
• Should have a working knowledge about load balancing- Adhere to coding standards and produce high quality code.
• Experienced as MS SQL Server Database developer - Programming stored procedures, views and functions. - SQL server performance tuning. - Designing & developing database tables.- Creating & tweaking indexes.
• Ensure smooth ETL and data flows execution, data assembly, cleansing, validation, data modelling and documentation
• Strong analytic mindset and logical thinking capability, strong QC mindset
• ServiceNow Reporting with solid understanding of ServiceNow data model will be plus.
• Conveys the designs to the software development teams via discussion, documentation and prototype code
• Ability to translate complex data into actionable insights for non-technical audiences.
• Over 3+ years of experience in IT support services, with significant reporting experience in managing large-scale data & reporting requirements.
• Good knowledge of IT Services functions and their responsibilities and strong analytical and problem-solving ability
• The ability to work and team effectively with business, management personnel, and diverse and geographically dispersed teams
• Basic reporting skills
• Possess innovative mindset by being open to new ideas and works comfortably with global teams   

Ideally, you’ll also have

• Excellent English language skills (verbal and written), 
• Excellent communication, collaboration and basic project management skills
• Good presentation skills with ability to present material clearly and concisely
• Excellent awareness of different cultures and working practices across the regions
• Proven experience in working in, and basic management of, diverse and geographically dispersed teams

What we look for

• Bachelor's degree in Data Science, Computer Science, Statistics, or a related field.
• Data science or any other relevant certification is preferred
• Strong Experience in Data Visualization in BI tool i.e. Design, develop and deployment of end to end Reporting solution using Microsoft Power BI stack 
• Experience of designing and implementing data engineering, ingestion and curation functions on the Azure cloud using Azure native or custom programming
• Experience in designing, building and operationalizing large-scale enterprise data solutions and applications using one or more of Azure data and analytics services in combination with custom solutions - Spark, HDInsights, Azure Data Lake, SQL DB/DW etc.
• Hands-on experience analyzing, re-architecting and re-platforming on-premise data warehouses to data platforms on Azure cloud using Azure/custom services
• Exposure of architecting and implementing next-generation data and analytics platforms on Azure cloudANSI / SQL Queries & Stored Procedures, Views, Database Tables, Indexes design and SQL Server performance tuning
• SQL Agent Jobs + SSIS + SSRS + SSAS (MS BI Tools or similar ETL tools like Informatica) and Data Modelling
• ANSI SQL Queries & Performance Tuning
• ITIL Foundation certification is preferred

Secondary skills (Optional)

• PowerShell scripting and automation
• Experience in Agile Methodology for Development
• Experience working with Big Data and tools
• ServiceNow Performance Analytics reporting module is an added advantage
• Python is an added advantage
• ServiceNow Reporting with solid understanding of ServiceNow data model is plus
• .NET Development
• Excel Macro / VBA programming, JavaScript

What we offer

As part of this role, you'll work in a highly integrated, global 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’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced 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.