Job Description

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.Consulting D&A SQL/TSQL + Power BI/ Tableau - GIGThe opportunityAs part of our EY-DnA team, you will help clients in developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. Working with latest tools available in the market you will help clients by acquiring data from primary or secondary data sources and maintain databases/data systems and help to identify, analyse, and interpret trends or patterns in complex data sets.Using your expertise in data analytics you will help our clients to view data in context and make smarter business decisions to achieve improved products and services.We\'re looking for candidates with strong technology and data understanding in data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.Your key role and responsibilities

• Work as a Senior team member to contribute in various technical streams EY DnA implementation project.
• Client focused with good presentation, communication and relationship building skills.
• Use an issue-based approach to deliver growth, market and portfolio strategy engagements for corporates
• Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations
• Exposure to BI and other visualisation tools in the market
• Building a quality culture
• Foster teamwork
• Participating in the organization-wide people initiatives

Skills and attributes for successMust have:

• Strong SQL and PL/SQL skills
• SQL coding experience on large projects working with newer versions of SQL Server (2014 and newer)
• Ingesting data from a variety of corporate data sources and performing required transformations in Power BI query editor.
• Build dashboards, reports and cubes using SQL, MDX, DAX
• Working knowledge of Tableau administrator/architecture.
• Adding or Creating Dimensions, Measures and Calculations.
• Working with custom parameters
• Able to use to understand and use advanced forecasting features and other analytical functions.
• Performance tuning the dashboard by optimising queries
• Knowledge of cloud computing, preferably on Azure.Strong DWH basics.
• Strong data modelling skills.
• Familiar with Agile and Waterfall SDLC process
• Should be at least 3-5 years of experience in Enterprise intelligence
• Tableau Administration
• BE/BTech/MCA/MBA with adequate 3-7 industry experience

Good to have skills:

• Developing calculations in DAX which are accurate and performant on large datasets.
• Designing effective layouts using themes and report grids, working closely with our UX design team.
• Utilising the navigation features in Power BI (e.g. bookmarks, drill-throughs) to guide readers through a compelling data-driven story.
• Deployment and other admin related activities such as scheduling data refresh, sending outputs to users via mail, access control etc.
• Guide the users with the industry standard practices in terms of Power BI dashboard development and maintenance.
• Should have an understanding of various pricing tiers and differentiators between various Power BI licences.
• Working with our clients to manage User Acceptance Testing (UAT) processes and fixing any defects identified.
• Publishing reports via the Power BI service, managing them through distribution of apps and monitoring usage/data refreshes/security access.

What working at EY offersAt EY, we\'re dedicated to helping our clients, from start-ups to Fortune 500 companies - and the work we do with them is as varied as they are.You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that\'s right for you

EY | Building a better working worldEY 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.

EY