Data Analyst

Saaki Argus & Averil Consulting; Chennai District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Saaki Argus & Averil Consulting seeks a Data Analyst in India to develop and optimize SQL queries, build scalable data pipelines, and support reporting across BI platforms.

The role emphasizes data quality, dimensional modeling, and collaboration with cross-functional teams to translate business needs into scalable data solutions.

Qualifications

• Strong SQL and data warehousing experience.
• Experience designing data warehouses and dimensional models.
• Ability to optimize queries and transform data for analytics.

Responsibilities

• Develop and optimize complex SQL queries using window functions, CTEs, and subqueries for data analysis.
• Design, build, and maintain scalable data pipelines using ETL/ELT processes to ensure reliable data flow across systems.
• Perform data transformation and cleansing to support accurate reporting and analytics.
• Design and implement data warehouse structures including star schema and snowflake schema.
• Create and manage fact and dimension tables to support business intelligence and reporting needs.
• Write and maintain stored procedures for data processing, automation, and performance improvement.
• Analyze and optimize query performance to improve efficiency and reduce execution time.
• Collaborate with cross-functional teams to understand business requirements and translate them into data solutions.
• Ensure data quality, consistency, and integrity across multiple data sources and systems.
• Support reporting and analytics by preparing datasets and enabling downstream tools such as dashboards and BI platforms.

Skills

SQL

Data Warehousing

ETL

Data cleansing

Dimensional modeling

Stored procedures

Query optimization

Cross-functional collaboration

Data quality

Snowflake schema

Tools

ETL tools

Job description

Job Title : Data Analyst

Notice Period : Immediate to 30 days

Location : Bangalore

• Develop and optimize complex SQL queries using advanced techniques such as window functions, CTEs, and subqueries for efficient data analysis.
• Design, build, and maintain scalable data pipelines using ETL/ELT processes to ensure reliable data flow across systems.
• Perform data transformation and cleansing to support accurate reporting and analytics.
• Design and implement data warehouse structures including star schema and snowflake schema.
• Create and manage fact and dimension tables to support business intelligence and reporting needs.
• Write and maintain stored procedures for data processing, automation, and performance improvement.
• Analyze and optimize query performance to improve efficiency and reduce execution time.
• Collaborate with cross-functional teams to understand business requirements and translate them into data solutions.
• Ensure data quality, consistency, and integrity across multiple data sources and systems.

Support reporting and analytics by preparing datasets and enabling downstream tools such as dashboards and BI platforms.