Senior Data Analyst

GCV Life; Mumbai Suburban; On-site; INR 900,000 - 1,800,000; Full time

Job summary

GCV Life is seeking a highly motivated SQL Developer/Data Analytics Engineer to build scalable data solutions for the pharmaceutical sector. You will optimize databases, automate workflows, and develop analytical dashboards using Power BI or Python.

The role involves ETL development, data modeling, and collaboration with business users to translate requirements into actionable insights. Strong SQL expertise and experience with BI tools are required.

Qualifications

• 34 years of hands-on SQL development.
• Strong knowledge of complex joins, CTEs, window functions, stored procedures, and views.
• Experience with indexing and execution plans.
• Experience with SQL Server, PostgreSQL, MySQL, or Oracle.
• Experience handling large datasets.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop and optimize complex SQL queries, stored procedures, views, and triggers.
• Perform query tuning, indexing, and performance optimization.
• Design and maintain relational database structures.
• Ensure data integrity, quality, and security.
• Build and maintain ETL/data pipelines.
• Integrate, clean, validate, and standardize data from multiple sources.
• Automate data import and transformation processes.
• 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.
• Automate data processing using Python (Pandas, OpenPyXL, SQLAlchemy).
• Develop scripts for data validation, transformation, and reporting.

Skills

SQL development

Complex joins

CTEs

Window functions

Stored procedures

Views and functions

Query optimization

Indexing

Execution plans

Relational databases

Data integrity

Analytical thinking

Python

Power BI

ETL pipelines

Tools

SQL Server

PostgreSQL

MySQL

Oracle

Job description

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 & 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

• 34 years of hands‑on SQL development.
• Strong knowledge of:
• o Complex Joins
• o CTEs
• o Window Functions
• o Stored Procedures
• o Views & Functions
• o Query Optimization
• o Indexing & 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