job title :- lead data analyst
location : ahmedabad
shift timing : 2:00 pm - 11:00 pm ist
experience required : 3 - 6 years
employment type : full-time
about the role:
we are looking for a skilled and motivated data analyst to join our analytics team. the ideal candidate will have strong expertise in power bi, advanced excel, and sql, along with a working knowledge of crm platforms. you will play a key role in translating data into actionable insights and helping stakeholders make data-driven decisions.
key responsibilities:
- build and maintain power bi dashboards and data models that provide actionable business insights.
- work with large datasets to perform ad-hoc analyses, uncover trends, and identify opportunities.
- write efficient and optimized sql queries to extract, join, and aggregate data from relational databases.
- use advanced excel functions (e.g., power query, index-match, pivot tables, vba/macros) for reporting and analysis.
- collaborate with business teams to gather requirements and turn them into technical solutions.
- analyze and interpret data from crm systems (e.g., salesforce, hubspot) to assess sales funnel performance, customer behavior, and lead quality.
- ensure data accuracy, consistency, and integrity across reporting tools and sources.
- present findings to business stakeholders in a clear, concise, and visually compelling manner.
required skills & experience:
- minimum 3 - 6 years of experience in a data analysis or business intelligence role.
- excellent english communication skills
- strong hands-on experience with power bi (dax, data modelling, custom visuals).
- proficiency in sql for data manipulation and extraction.
- expert-level skills in excel, including advanced formulas and automation techniques.
- familiarity with crm systems and ability to analyze customer and sales data.
- strong problem-solving and communication skills.
- experience working with cross-functional teams in a fast-paced environment.
