Senior Business Analyst - Analytics

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