SCT-Tech Enablement-Aera Skill Builder-Senior Consultant-GDS02

We are looking for a highly skilled and experienced Aera Developer with 3 to 8 years of experience to join our team in Bengaluru. The ideal candidate will have a strong background in building dynamic, interactive dashboards, and ad hoc reporting. ### Roles and Responsibility Translate business needs into technical specifications. Perform data analysis and manipulation as per client requirements. Expertise in data modeling to simplify business concepts. Create extensive ER diagrams to help business decision-making. Develop reporting systems providing accessible information for decision-making. Write and customize code in Data Workbench, Decision workbench, Process Builder, UI Builder, Business Rules, and Cortex modules of Aera. Evaluate and improve Aera skills. Generate and deliver quality reports to customers, performing quality assurance checks on reports. Develop, customize, deploy, and maintain data visualizations as per client business requirements. Demonstrate management and the ability to drive projects or teams individually. Excellent analytical thinking for translating data into informative visuals and reports. ### Job Requirements Experience as an Aera Skill Builder. Expertise in BI reporting with strong data warehouse concepts. Strong data modeling skills. Expert-level knowledge of Aera skill builder modules like Data Workbench, Decision workbench, Process Builder, UI Builder, Business Rules, and Cortex. Experience in creating dashboards, presentations using line, bar, histograms, scatter, water, Bullet, Heat maps, and tree maps. Experience in creating calculated measures and columns in reports and configuring Aera skills. 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. Designed and developed stored procedures, queries, ETL processes, views, and data models necessary to support BI visualizations. Effectively handle reports performance and administration. Aera Skill Builder and Aera Architect Certified. Experience on different types of web concepts like Gateways, Schedule refresh, Q&A, Insights in Datasets. Worked on providing permissions on Reports, Dashboards, and Datasets using Content packs. 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 objects 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 advanced 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.