Company: Gregor Analytics (GCV Life Pvt. Ltd. Website: www.gregoranalytics.com
Job Description – Senior Data Analyst Experience: 3–4 Years
Location: 501, Windfall Building, Sahar Plaza, Andheri Kurla Road, Andheri East, Andheri – 400059. Landmark – Next to Chakala Metro Station
Employment Type: Full-Time
About the Role
We are looking for a highly motivated SQL Developer / Data Analytics Engineer with strong SQL expertise and at least one complementary skill in Power BI or Python. The role involves building scalable data solutions, optimizing databases, automating data workflows, and developing analytical dashboards for the pharmaceutical industry.
Key Responsibilities
SQL s Database Development
· Develop and optimize complex SQL queries, Stored Procedures, Views, Functions, and Triggers.
· Perform query tuning, indexing, and performance optimization.
· Design and maintain relational database structures.
· Ensure data integrity, quality, and security.
Data Engineering
· Build and maintain ETL/data pipelines.
· Integrate, clean, validate, and standardize data from multiple sources.
· Automate data import and transformation processes.
Business Intelligence
· Develop datasets and data models for Power BI.
· Build and support dashboards and KPI reports.
· Collaborate with business users to translate requirements into analytical solutions.
Automation (Python – Preferred)
· Automate data processing using Python (Pandas, OpenPyXL, SQLAlchemy).
· Develop scripts for data validation, transformation, and reporting.
Required Skills Mandatory
· 3–4 years of hands-on SQL development.
· Strong knowledge of:
o Complex Joins
o CTEs
o Window Functions
o Stored Procedures
o Views C Functions
o Query Optimization
o Indexing C Execution Plans
· Experience with SQL Server, PostgreSQL, MySQL, or Oracle.
· Experience handling large datasets.
· Strong analytical and problem-solving skills.
Must Have One of the Following
· Power BI: Data Modelling, DAX, Power Query, Dashboard Development.
· Python: Pandas, NumPy, Data Automation, ETL Scripts.
Good to Have
· SSIS / Azure Data Factory
· Git
· Data Warehousing
· Star Schema
· Healthcare or Pharmaceutical Analytics
Education
Bachelor's degree in Computer Science, IT, Engineering, Data Science, Mathematics, or a related field.
Preferred Candidate Profile
· Strong analytical mindset with attention to detail.
· Ability to work independently and in a collaborative environment.
· Excellent communication and stakeholder management skills.
· Passion for solving business problems through data.
Compensation
· Experience: 3–4 Years
· CTC: ₹6-8 LPA
Recruiter Screening Checklist Mandatory
· ✔ 3–4 years of SQL development experience.
· ✔ Excellent SQL (CTEs, Window Functions, Stored Procedures, Query Optimization).
· ✔ Experience with SQL Server/PostgreSQL/MySQL/Oracle.
· ✔ Strong in Power BI or Python.
· ✔ Experience with large datasets and BI reporting.
Preferred
· ✔ Healthcare/Pharma/FMCG analytics experience.
· ✔ ETL or data engineering exposure.
· ✔ Product or analytics company background.
This version is concise while still giving recruiters clear screening criteria and candidates a precise understanding of the role.
Pay: ₹600,000.00 - ₹800,000.00 per year
Benefits:
Work Location: In person
