OnlineSales.ai - Senior Data Analyst - SQL/Python

About OnlineSales.ai :

Built by ex-Amazon ad-tech experts, OnlineSales.ai offers a future-proof Retail Media Operating System boosting Retailers profitability by 7% of Sales! We are an Enterprise B2B SaaS startup, based out of Pune India.

With OnlineSales.ai's platform, retailers activate and delight 10x more Brands by offering an omni-channel media buying experience, advanced targeting, analytics & 2x better ROAS.

Tier 1 Retailers and Marketplaces globally are accelerating their Monetization strategy with OnlineSales.ai and are innovating ahead of the market by at least 2 years.

About the Role :

We are seeking a talented and motivated individual to join our team as a Senior Data Analyst who will be responsible for extracting insights from complex datasets to drive informed decision-making and enhance business performance.

You will collaborate closely with cross-functional teams to identify key metrics, develop data-driven strategies, and provide actionable recommendations.

Additional responsibilities may include managing daily regulatory reporting tasks and remediation activities, as well as process improvement.

What will you do @OnlineSales ?

- Data Analysis : Utilize advanced analytical techniques to explore large datasets, identify trends, patterns, and anomalies, and extract actionable insights.

- Data Visualization : Create visually compelling dashboards and reports to communicate findings effectively to stakeholders, enabling them to make informed decisions.

- Data Extraction : regular extraction of relevant data from internal databases using SQL queries.

- Design and optimize SQL queries to retrieve specific datasets required for performance analysis and reporting.

- Issue Identification : Proactively identify performance-related issues by monitoring key performance indicators (KPIs), analyzing trends, and investigating anomalies reported by internal stakeholders or external clients.

- Addressing Client Exceptions and Issues : Responsively address performance-related exceptions and issues raised by clients, ensuring timely resolution and effective communication throughout the process.

- Collaborate with client-facing teams to understand client requirements, prioritize tasks, and deliver solutions that meet or exceed client expectations.

- Root Cause Analysis : Dive deep into data to understand the root causes of performance issues, considering factors such as system architecture, infrastructure, code efficiency, and user behavior.

- Hypothesis Testing : Apply hypothesis testing techniques to validate assumptions and identify statistically significant factors impacting performance.

- Documentation and SOP Creation : Create clear and detailed Standard Operating Procedures (SOPs) outlining the process for diagnosing, troubleshooting, and resolving performance issues.

- Ensure that documentation is organized, easily accessible, and regularly updated to reflect changes in systems, processes, or configurations.

- Cross-Functional Collaboration : Collaborate with teams across the organization, including business development, marketing, product development and operations, to understand their data needs and provide analytical support.

You will be a great fit, if you have :

- 2 to 4 years of relevant experience.

- Bachelor's or Master's degree in Computer Science, Engineering, or a related technical field.

- Proficiency in SQL for data extraction and manipulation from relational databases.

- Familiarity with programming languages such as Python for Data Analysis and Data modeling is a plus.

- Strong analytical skills with the ability to interpret complex datasets and draw meaningful insights.

- Strong problem-solving abilities with a proactive approach to troubleshooting and issue resolution.

- Advanced proficiency in Excel and adept data manipulation skills for efficient analysis and visualization of large datasets.

- Effective communication and interpersonal skills for collaboration with cross-functional teams and stakeholders.

- Understanding of E-Commerce as a domain.

- Excellent documentation skills with the ability to create clear and comprehensive reports and SOPs.

- Attention to detail and commitment to data accuracy and quality.

- Willingness to work for a startup.