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.
  
  

(ref:hirist.tech)