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.Aera Developer - SeniorThe opportunityWe're looking for Senior Consultants as Aera Solution Builder to join the Supply Chain Tech group of EY GDS consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.Your key responsibilities

• Translating business needs into technical specifications.
• Performing Data Analysis and Data Manipulation as per client requirements.
• Expert in Data Modelling to simplify business concepts.
• Create extensive ER Diagrams to help business in decision making.
• Developing reporting systems that provide accessible information for decision-making.
• Writing/Customizing code in Data Workbench, Decision workbench, Process Builder, UI Builder, Business Riles, Cortex modules of Aera
• Evaluating and improving Aera Skills
• Generating and delivering quality reports to customers and performing quality assurance checks on reports. Develop, Customize, Deploy, maintain data visualizations as per client business requirements.
• Should have thorough knowledge in creating dynamic visualizations with multiple concepts.
• Experience working with clients throughout various parts of implementation lifecycle
• Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.

Skills and attributes for success

• Strong experience on building Dynamic, Interactive dashboards, and ad hoc reporting.
• Experience with query tools and data visualization.
• Demonstrate management and an ability to drive projects or teams individually
• Excellent analytical thinking for translating data into informative visuals and reports

To qualify for the role, you must have

• Experience as Aera Skill Builder
• Expertise in the BI reporting with strong Data Warehouse concepts.
• Must have strong Data Modelling skills.
• Expert Level knowledge on Aera skill builder modules like Data Workbench, Decision workbench, Process Builder, UI Builder, Business Riles, Cortex
• Should have experience in creating dashboards, presentations like line, bar, histograms, scatter, water, Bullet, Heat maps, tree maps etc.
• Should have experience in creating calculated measures and columns in reports and configuring Aera skill.
• Should have hands-on experience in applying Security concepts such as Row Level Security (RLS), limit data access , etc
• Experience on Sharing, Publishing and setting up Row level security of reports.
• Should have designed and developed stored procedures, queries, ETL Process, views, Data models necessary to support BI Visualizations.
• Should be able to effectively handle reports performance and administration.
• Aera Skill Builder and Aera Architect Certified.
• Experience on different type of web concepts like Gateways, Schedule refresh, Q&A, Insights in Datasets.
• Should have Worked on providing permissions on Reports, Dashboards and Datasets using Content packs.

Ideally, you'll also have

• Strong knowledge of Aera Skill Build concepts, design and coding
• Expertise in data handling to resolve any data issues as per client needs
• Experience in designing and developing database object such as
• Tables, Views, Indexes, Materialized Views and Analytical functions
• Experience of creating complex SQL queries for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Candidate should be eager to learn advance technologies, new product updates etc., learn and train other team members
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into BI specifications and High- and Low-level design documents.

What we look for

• The incumbent should be able to drive Aera Skill Development related tasks. Additional knowledge of complex source system data structures preferably in SCM services (preferred) Industry and reporting related developments will be an advantage.
• An opportunity to be a part of market-leading, multi-disciplinary team of 10000 + professionals, in the only integrated global transaction business worldwide.
• Opportunities to work with EY GDS consulting practices globally with leading businesses across a range of industries

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