ABOUT THE ROLE AND OUR TEAM:
The Global Local Operations team is globally aligned to continuously evaluate, improve and maintain the health of our database by collaborating with different teams and applying techniques like automation. The team will also ensure smooth operations of contract management for better internal sales team and external customer experience.The purpose of the team is to act at a unified global level as one team and focus closely to support our sales and other departments. The strategy developed by this team will involve creating expertise without any geographical divisions and work towards a globalized, unified & standardized approach. One Team One Dream.
RESPONSIBILITIES:
Data Extraction:
Write, optimize, and maintain complex SQL queries to extract relevant data from various databases. Clean, transform, and ensure data integrity for accurate analysis and reporting. Strong understanding of databases such as Snowflake, including data modeling, query optimization, and integrating Salesforce data with Snowflake for advanced analytics and reporting.Salesforce Data Management:
Proficient in administrative tasks, such as managing users, setting up security controls, handling data management, and configuring roles, profiles, and reports. Experienced in designing and implementing custom Salesforce objects, fields, picklists, page layouts, workflows, approval processes, validation rules, custom tabs, Visualforce pages, and dashboards to meet specific business requirements. Capable of translating functional requirements into detailed technical specifications and delivering high-quality solutions. Analyze/Build/Deploy Tools to leverage Best Practices around Salesforce Applications to measure Service Effectiveness.Reporting & Dashboards:
Create and maintain interactive dashboards and reports using Metabase and other visualization tools to communicate key insights to stakeholders. Identify trends, patterns, and anomalies in large datasets, providing actionable recommendations.SUCCESSFUL CANDIDATES HAVE:
Strong 5+ years of experience in Data Analytics and Business Analysis SQL: Proficient in writing complex queries, optimizing query performance, and handling large datasets. Salesforce: Strong understanding of Salesforce CRM data structures and how to extract, clean, and analyze Salesforce data as well as work with related tools like Ringlead. Proficiency in data visualization tools (Metabase, Tableau, Power BI) and a solid understanding of relational databases. Strong understanding of databases such as Snowflake, including data modeling and query optimization.