Full Job DescriptionAt 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.
Description
As part of ET / Service Management team, the SM Metrics and Reporting team is responsible for delivering operational and service based reporting to measure and drive process adherence and compliance for EY enterprise technology services.
The vision for SM Metrics and Reporting team is to provide single version of truth, create data driven culture, automate and modernize the delivery model thorough improved data visualization and storytelling, build advanced analytics capabilities, adopt agile development methodologies with a mission to provide the best reporting experience to users through quick and actionable insights from data for better decision making across the EY Technology.
This position at ESM Metrics and Reporting as Supervisory Associate – Power BI, SQL Server and Azure Lead Developer will have:
5 to 8+ years of experience in any reporting and analytics functions/roles with exposure to Enterprise IT, Service Management related metrics and analysis.
Create data visualizations and implement decision support tools end to end using standard BI reporting tools i.e. Power BI with ability to automate end to end report creation and delivery.
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.
Excellent communication skills (written and oral) including technical aspects of a project, ability to develop usable documentation, results interpretation and business recommendations •
Strong analytic mindset and logical thinking capability, strong QC mindset
Demonstrates consulting, creativity, critical thinking, project planning, and attention to detail capabilities.
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.
Responsibilities, Qualifications, Certifications
Technical Skills:
Primary (minimum necessary skills and certifications will be a plus)
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
Secondary (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
Other Requirements:
At least 3 years of professional experience in quantitative data analysis or at least 2+ years of relevant professional experience with research in machine learning algorithms
Track record of customer focus, based on openness, trust, and delivering on promises
Excellent Communication skills
Job Requirements:
Education:
Bachelor’s degree in computer science or statistics or a related discipline, or equivalent work experience.
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.