Dentsu is a network designed for what’s next, helping clients predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy through five global leadership brands; Carat, Dentsu Creative, dentsu X, iProspect and Merkle, each with deep specialisms.Merkle, a dentsu company, is a leading data-driven customer experience management enterprise specializing in delivering unique, personalized customer experiences across platforms and devices. With over 30 years of experience, Merkle partners with Fortune 1000 companies and non-profit organizations to optimize their customer portfolios. Its expertise in data, technology, and analytics enables it to gain insights into consumer behavior, driving hyper-personalized marketing strategies. Merkle's consulting, creative, media, analytics, data, identity, CX/commerce, technology, and loyalty & promotions capabilities combine to drive improved marketing results and a competitive edge. With over 14,000 employees, Merkle is headquartered in Columbia, Maryland, with more than 50 additional offices worldwide. Its innovative solutions enable brands to build meaningful customer relationships and enhanced customer experience.We are now excited to invite applications for the role of Lead Analyst - Salesforce Datorama with our awesome team in Pune.Must Require Skills: Salesforce Datorama: - Proficiency in using Salesforce Datorama for data integration, visualization, and reporting. - Experience with Datorama’s API Connect, TotalConnect, and LiteConnect for data ingestion. - Ability to connect and integrate various data sources, including marketing platforms, CRM systems, and databases. - Skills in creating interactive and insightful dashboards using Datorama. - Understanding of key performance indicators (KPIs) and metrics relevant to marketing and business intelligence. BI Tools:Proficiency in at least one Business Intelligence tool such as Tableau, Power BI or any other tool. (SF DTR must require) SQL:Strong skills in SQL for data querying and manipulation. Good to Have Skills: Python, JavaScript, Data Modeling, Macros and Excel. ETL Processes - Understanding of ETL (Extract, Transform, Load) processes to ensure data quality and consistency Advanced Excel - Proficiency in using advanced Excel functions and macros for data analysis and reporting. Data Governance - Knowledge of data governance practices to ensure data integrity, security, and compliance.Roles & Responsibilities: Must have 2 years of HandsOn experience in Dashboard development and Reports creation. Develop, design, and maintain interactive dashboards and reports using Salesforce Datorama and Any other BI tool. Collaborate with clients to understand their data needs and translate them into actionable insights. Perform data extraction, transformation, and loading (ETL) processes to ensure data accuracy and integrity. Analyze large datasets to identify trends, patterns, and insights that drive business decisions. Provide technical expertise and support in the use of data visualization tools. Work closely with cross-functional teams to gather requirements and deliver data solutions that meet business objectives. Ensure data quality and consistency across all dashboards and reports. Stay up-to-date with the latest trends and best practices in data analytics and visualization. Independently handle client communications and proactively share regular updates to all stakeholders. Ensure delivery of all outputs maintaining quality and timeline expectations. Be accountable and diligent in following aligned processes and be a good team player. Express oneself clearly and concisely in oral communications, Organize ideas and information logically and sequentially. Qualifications: Bachelors/master’s in computer science, Economics, Statistics, Mathematics. Advanced degree in a quantitative discipline, preferably Mathematics/Statistics or similar will be an added advantage. Skilled inSQLis a must, python will be an added advantage. Skilled inSF Datoramais a must. Working knowledge ofAny BI Tool(Tableau, Power BI, Datorama) is a must. Accuracy and attention to detail a must, Strong math and analytical skills.
Job Title
Lead Analyst - Salesforce Datorama