Data Analytics

Data Analytics

Contract basis third party payroll artech

*CGEM JP ID:* CGEMJP00355069

*Experience:* 9–12 years

*Location:* Pune

*Notice Period:* Only Immediate

*Budget:* 25–26 LPA

Job Summary

We are looking for a highly skilled Data Analyst / Analytics Developer with strong expertise in SQL, Qlik Sense, ETL/Data Integration, Data Modeling, and Scripting. The ideal candidate will be responsible for transforming complex data into meaningful insights, developing interactive dashboards, and supporting business decision-making through data-driven solutions.

Mandatory Skills

* Strong expertise in SQL and Database Management

* Hands-on experience with Qlik Sense

* Experience in ETL and Data Integration

* Strong understanding of Data Modeling

* Experience in Scripting (Qlik Script, SQL, Python, or Shell Scripting)

Key Responsibilities

* Develop, maintain, and optimize Qlik Sense dashboards, reports, and visualizations.

* Design and implement ETL processes for extracting, transforming, and loading data from multiple sources.

* Write complex SQL queries, stored procedures, and optimize database performance.

* Create and maintain logical and physical data models.

* Perform data validation, data cleansing, and quality checks.

* Collaborate with business stakeholders to gather reporting and analytics requirements.

* Develop reusable data models and semantic layers within Qlik Sense.

* Automate reporting and data integration processes through scripting.

* Analyze large datasets to identify trends, patterns, and business opportunities.

* Prepare technical documentation and maintain data dictionaries.

Required Technical Skills

*SQL & Database Management*

* Advanced SQL query writing and optimization.

* Relational databases:

* SQL Server

* Oracle

* PostgreSQL

* MySQL

* Database performance tuning and troubleshooting.

*Qlik Sense*

* Dashboard and report development

* Data modeling in Qlik Sense

* Qlik scripting and Load Editor

* Set Analysis, Variables, Expressions, and Section Access

* Performance optimization and deployment

*ETL & Data Integration*

* ETL tools and data integration frameworks

* Data extraction from multiple structured and unstructured sources

* Data transformation, cleansing, and validation techniques

* Scheduling and monitoring data pipelines

*Data Modeling*

* Star Schema and Snowflake Schema

* Dimensional Modeling

* Fact and Dimension table design

* Data Warehouse concepts and best practices

*Scripting*

* Qlik Sense Scripting

* SQL Scripting

* Python/Shell Scripting for automation

* Data manipulation and process automation

Preferred Skills

* Power BI or Tableau

* Data Warehousing concepts

* Cloud Platforms (Azure, AWS, or GCP)

* Agile/Scrum environments

* Data governance and data quality frameworks

Pay: From ₹2,500,000.00 per year

Work Location: In person