EY Data Analytics and Reporting Specialist in Kochi, India
Data Analytics and Reporting Specialist
Core Business Services
Requisition # IND00C3F
Post Date Nov 04, 2018
The Data Analytics and Reporting Analyst will work within the Continuous Service Improvement and Operations Management (CSI&OM) team within Optimization Services, and will work to help enable teams across EWT (Enterprise Workplace Technology) to standardize, collect/receive the necessary metrics needed for benchmarking, measuring and trending our progress and successes in meeting or exceeding service management targets.
As Data Analytics and Reporting Analyst you'll be responsible for the identification and capture of data points; inspection and cleansing of data; transformation of data into meaningful analysis, statistics, reports and dashboards; analysis and identification of trends and opportunities for improvement; creating valuable insights and recommendations, present findings/observations and providing conclusions/recommendations to key stakeholders to support decision making and continual service improvement.
The Data Analytics and Reporting Analyst will be guided by the CSI&OM - Data Analytics and Reporting Specialists and Lead, however is expected to be able to work under own initiative and as part of a team.
Essential Functions of the Job:
Obtain, document and analyze EWT reporting needs and requirements through collaboration with department leaders
Translate reporting needs into production reports and dashboards
Work across functional lines to strive for and ensure consistent data quality
Conduct continuous review of reports and identify opportunities for improvements with the aim of minimizing redundant reporting and development of single source of truth where possible
Develop and maintain dashboards to visualize data utilizing Power BI, Spotfire or Tableau
Automate data preparation and report creation where possible
Development of ad-hoc reports as necessary
Provide increased focus on analytics and emphasize on providing valuable insights to drive improvement opportunities
Build understanding of business and operational strategies and identify critical metrics required to support those strategies
Perform analysis and develops recommendations for continuous improvement opportunities
Ability to handle various data sources, using data modeling work to develop reporting capabilities and valuable insights across these data sources is key.
Analytical/Decision Making Responsibilities:
- The role requires advanced analytical acumen and solution orientation. The role possesses critical thinking skills and the ability to understand and manipulate data to provide insightful observations, identify trends and communicate these effectively. The role is expected to act independently to make timely and informed decisions aligned to the role’s remit or to escalate as appropriate to management or others in IT as needed. The role’s insight and proposed actions should strive to be strategic, look beyond ‘stop gap’ measures and seek to drive improvements to reporting and analysis practices in a manner that is both effective and supporting the value EWT has to the business.
Knowledge and Skills Requirements
Maintains advanced interpersonal and collaborative skills to engage strategically with peers and other senior executives of the firm, in cross business discussions to build and maintain a solid network for effective teamwork and knowledge sharing. Uses these communication skills to challenge insightfully, to direct improvements and remediation to processes, propose credible options as solutions, and position EWT’s role in quality technical service management and IT infrastructure business support.
Advanced consultative skill to conduct effective questioning to break down complex issues into core elements, formulate appropriate ideas and negotiate those ideas clearly and concisely to advance a cooperative engagement by all levels of the organization including senior and/or executive management.
Manifests a strong analytical and problem solving ability to negotiate complex and conflicting issues, handle ambiguity as well as multiple and shifting priorities and to drive EWT related decisions that are both financially sound and operationally feasible.
Proven track record of establishing, maintaining and improving team behaviors through the use of Metrics and Key Performance Indicators
Adapts communication style to the style of others. Develops rapport and remains calm under pressure. Builds strong relationships across all levels of a matrix based, geographically and culturally dispersed organization utilizing advanced oral and written English communication skills.
Maintains an advanced knowledge of Data Analytics and Data Visualization best practices.
Utilizes proper resource, time and project management disciplines across a diverse culture, differentiating regulations and multiple time zones.
Provide individual and peer mentoring as appropriate and required to develop capabilities within team, function and organization
Ability to comprehend business needs, convert them into BRD & TRD (Business/Technical requirement document), develop implementation roadmap and execute on time.
Experience in working with large datasets, derive insights and present information through visualization and reports.
In-depth understanding of the ETL process & best practices
- Degree in Computer Science or a related discipline
Over 5 years work experience. At least 2 years working in a data analysis or reporting role
Demonstrated experience in design, develop and maintain BI reports, optimizing efficiency in manipulating data and writing complex queries.
Background in statistics and business/data modeling
Microsoft Excel 2013 Expert with VBA Programming skills
Experience in Microsoft Business Intelligence – SSIS, SSRS & SSAS
Hands on experience in using different DBMS (SQL Server, Oracle, MSQL & Access).
Hands-on experience in Power-BI, Tableau and Spotfire.
Knowledge on Big Data (Hive, Spark) would be beneficial
Knowledge of Python and R would be beneficial
- ITIL Foundation V3