Sr. Data Analyst at Purchase of compelling goods and services. (SG1) · Bengaluru (Bangalore) · 6 - 10 years · ₹25L - ₹30L / yr · Posted 22 Nov 2021
Data AnalyticsWe are looking for a Senior Data Analyst who will support our product, sales, leadership, and marketing teams with data collection and organization of data in order to draw conclusions, make predictions, and drive informed decision making.
- The ideal candidate is adept at using large data sets to find opportunities for product and marketing optimization and using data models to test the effectiveness of different courses of action.
- Not just that, you also understand how to clean and organize data for complete analysis and calculations using spreadsheets, SQL Python, and R programming.
- Visualizing and presenting data findings in dashboards, presentations and commonly used visualization platforms must be your strength.
SKILLS YOU MUST HAVE:
- Data Cleansing, Data Analysis, Data Visualization (DataViz), SQL Questioning, Decision-Making, Problem Solving, Data Collection, Data Ethics, Sample Size Determination, Spreadsheet,
RESPONSIBILITIES:
- Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
- Mine and analyze data from company databases (GOOGLE ANALYTICS, User DB, and 3rd party Marketing Analytics tools) to drive optimization and improvement of product development, marketing techniques, and business strategies.
- Assess the effectiveness and accuracy of new data sources and data gathering techniques.
- Strong understanding of Google Analytics (GA) fundamentals and how to work with raw GA data
- Automate custom data fetching from Google Analytics dashboard to excel sheet and other primary and secondary sources
- Work with complex SQL queries
- Work with Big Query with GA integration to extract data
- Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.
- Filter Data by reviewing reports and performance indicators to identify and correct code problems
- Developing and maintaining databases, data systems reorganizing data in a readable format
- Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets could be helpful for the diagnosis and prediction
- Assign a numerical value to essential business functions so that business performance can be assessed and compared over periods of time.
- Use predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
- Develop company A/B testing framework and test model quality.
- Coordinate with different functional teams to implement models and monitor outcomes.
- Develop processes and tools to monitor and analyze model performance and data accuracy.
- Understanding of statistical concepts like Statistical significance, t-test, and z-test for AB testing
- Performing analysis to assess quality and meaning of data
- Preparing reports for the management stating trends, patterns, and predictions using relevant data
- Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
- Robust understanding of Mix panel and Amplitude
Skill requirement:
- 6-8 years of experience in database management and a strong understanding of Google Analytics
- Strong mathematical skills to help collect, measure, organize, and analyze data
- Experience using statistical computer languages (R, Python, MATLAB, SQL, etc.) to manipulate data and draw insights from large data sets.
- Experience analyzing data from 3rd party providers: Google Analytics, Site Catalyst, Coremetrics, Adwords, Crimson Hexagon, Facebook Insights, etc.
- Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
- Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks.
- Knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests, and proper usage, etc.) and experience with applications.
- Knowledge of data visualization software like Tableau
- Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions
- Accuracy and attention to detail
- Adept at queries, advanced excel management, writing reports, and making presentations
- Team-working skills
- Verbal and Written communication skills
- Proven working experience in data analysis
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs (6)
This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.
Work Mode: WORK FROM OFFICE
Role Descriptions:
- Perform detailed data analysis and support business decision-making
- Gather and document business requirements and translate them into technical specifications
- Work closely with stakeholders to define data needs and reporting requirements
- Create user stories, functional specifications, and support UAT activities
- Ensure alignment between business objectives and data solutions
Required Skills:
- Strong expertise in SQL and data querying
- Proven experience in data analysis, requirement gathering, and stakeholder management
- Ability to translate business requirements into technical solutions and user stories
- Good understanding of data models, reporting, and analytics concepts
Skills: Business Analysis~ORACLE SQL
Locations: ~HYDERABAD~PUNE~
Desire candidate
- Candidate should have valid PF.
PythonWe're hiring a Data Analyst to turn raw data into clear, actionable insight. You'll partner with product, sales, marketing, and operations teams to answer their most important questions with data — building dashboards, running deep-dive analyses, and defining the metrics the business runs on. The ideal candidate is fluent in SQL, comfortable wrangling messy datasets, and just as strong at telling the story behind the numbers as they are at producing them. You'll own the accuracy and trustworthiness of the reporting stakeholders rely on to make decisions.
Key Responsibilities
- Design, build, and maintain dashboards and recurring reports across business functions
- Write and optimize SQL queries to extract, join, and transform data from multiple sources
- Run ad-hoc and deep-dive analyses to answer specific business questions
- Define, document, and standardize metrics and KPIs alongside stakeholders
- Investigate data-quality issues and ensure the numbers people see are accurate
- Translate analysis into clear recommendations and present them to non-technical audiences
- Support experimentation and A/B test analysis where relevant
- Automate repetitive reporting to free up time for higher-value analysis
Requirements
- 3+ years in a data analyst or business-intelligence role
- Strong SQL and hands-on experience with Power BI and/or Tableau
- Working knowledge of Python (pandas/numpy) for analysis
- Solid grounding in statistics and analytical methods
- Advanced Excel and strong data-visualization / storytelling skills
- Ability to work independently with stakeholders across functions
Nice to have
- Experience with cloud data warehouses (BigQuery, Snowflake, Redshift)
- Exposure to dbt or other ETL/transformation tooling
PythonAt Nineleaps, we work on bleeding-edge technology with class-leading engineering practices on products that touch the lives of millions of users. We endeavor on doing things the right way, while also promoting a culture of excellence.
About the Role:
We are looking for a Data Analyst with strong analytical and problem-solving skills to transform complex data into meaningful, actionable business insights. The role involves working with large datasets, conducting deep-dive analysis, driving automation, and supporting data-driven product and business decisions.
Key Responsibilities:
- Analyse historical and large datasets to understand data sources, identify trends and patterns, and uncover meaningful insights.
- Write complex SQL queries and leverage Python to perform data analysis, ad hoc investigations, and solve business problems.
- Create reports and translate analytical findings into clear, concise, and actionable recommendations for stakeholders.
- Identify opportunities to drive automation and process improvements, improving efficiency and reducing manual effort.
- Communicate data-driven insights effectively to both technical and non-technical stakeholders in a clear and impactful manner.
- Maintain accurate documentation, ensure high-quality deliverables, and consistently meet defined timelines.
Requirements:
- 3–6 years of experience in Data Analytics, Business Intelligence, Data Engineering, or a similar analytical role.
- Strong hands-on expertise in Python and advanced SQL, with the ability to work with and analyse large datasets.
- Experience working with Google Sheets, and implementing automation through data pipelines or workflows.
- Strong analytical and problem-solving skills, with the ability to interpret complex data and derive actionable insights.
- Excellent communication skills with the ability to effectively present methods, results, and recommendations to stakeholders.
- Ability to collaborate effectively with remote and geographically distributed teams across different time zones.
Company Link: https://www.nineleaps.com/
Company LinkedIn: https://www.linkedin.com/company/nineleaps/
Strong Data Analyst Profile with advanced Excel and SQL expertise
2
Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst
3
Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots
4
Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts
5
Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)
6
Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy
7
Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)
8
Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.
9
Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person
10
Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts
Key Responsibilities
- Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
- Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
- Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
- Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
- Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
- Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
- Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
- Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
- Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.
Required Skills & Qualifications
- Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
- Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
- Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
- Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
- Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
- Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.
About Us
Corporate Web Solutions provides technology-driven solutions involving data analysis, automation, web development, and digital transformation.
Role Overview
As a Data Analyst Intern, you'll assist in analyzing datasets, preparing reports, identifying trends, and exploring AI-assisted analytics workflows.
Key Responsibilities
- Collect and organize data.
- Analyze datasets and identify trends.
- Prepare reports and visualizations.
- Work with Excel, spreadsheets, or analytical tools.
- Assist with dashboards and data-driven insights.
- Explore AI tools for data analysis.
Requirements
- Basic understanding of data analysis.
- Familiarity with Excel or Google Sheets.
- Basic knowledge of SQL or Python is a plus.
- Analytical mindset.
- Good attention to detail.
Perks
- Certificate of Internship
- Flexible work hours
- Mentorship and real project exposure
- Potential for PPO
- Letter of Recommendation
- Performance-Based Stipend available up to ₹18,000/month
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon