Senior Data Analyst

BIG Language Solutions, Inc.; Dadri; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

BIG Language Solutions, Inc. is seeking a Senior Data Analyst to design and optimize SQL Server solutions, build SSIS ETL pipelines, and develop Power BI dashboards. The role focuses on enterprise reporting, data warehousing, and automating reporting for data-driven decisions.

You will work with Python, Azure SQL, and Azure Data Factory to deliver scalable BI solutions and mentor junior analysts in a fast-paced environment.

Qualifications

• 5-8 years of experience in Data Analytics, BI, or Data Engineering.
• Strong expertise in SQL Server and ETL development.
• Experience building enterprise-grade BI solutions and dashboards.

Responsibilities

• Design and optimize SQL queries, stored procedures, functions, views.
• Develop SSIS packages and ETL pipelines with incremental loads.
• Build interactive Power BI dashboards with DAX and data modeling.
• Develop data warehouse solutions with fact/dimension models.
• Automate reporting using SQL, Python, SSIS, and AI-enabled tools.
• Analyze large datasets for trends and business opportunities.
• Collaborate with stakeholders to translate requirements into BI solutions.
• Mentor junior analysts and establish BI best practices.

Skills

Advanced SQL

SSIS

Power BI

Azure SQL

Python (Pandas)

ETL development

Business Intelligence

Data modeling

Data warehousing

Education

Bachelor's degree in Computer Science, Engineering, Data Analytics, Statistics, or related field

Tools

SQL Server

SSIS

Power BI

Azure SQL

Azure Data Factory

Excel

Job description

Senior Data Analyst - Job Description

Location

Noida (Onsite)

Employment Type

Full-Time

Experience

5-8 Years

Role Summary

We are looking for an exceptional Senior Data Analyst with deep expertise in SQL Server, SSIS, Power BI, Azure SQL, ETL development, Python, and Business Intelligence. The role involves building enterprise reporting solutions, optimizing databases, developing scalable ETL pipelines, automating reporting, and delivering executive dashboards that enable data-driven decision making.

Key Responsibilities

• Design and optimize SQL queries, stored procedures, functions, views, and database objects.
• Develop enterprise-grade SSIS packages, ETL pipelines, incremental loads, and automated workflows.
• Build interactive Power BI dashboards with advanced DAX, Power Query, data modeling, and Row-Level Security.
• Develop data warehouse solutions including fact/dimension models and reporting marts.
• Automate reporting using SQL, Python, SSIS, and AI-enabled solutions.
• Analyze large datasets, identify trends, anomalies, and business opportunities.
• Collaborate with business stakeholders to translate requirements into scalable BI solutions.
• Mentor junior analysts and establish BI best practices.

Mandatory Technical Skills

SQL Server: Advanced SQL, Stored Procedures, Views, Functions, Triggers, CTEs, Window Functions, Query Optimization, Performance Tuning, Indexing, Execution Plans.

SSIS: ETL Development, Data Flow, Control Flow, Incremental Loads, Scheduling, Logging, Error Handling, Package Deployment, Performance Optimization.

Power BI: Advanced DAX, Power Query, Data Modeling, Star Schema, Snowflake Schema, Power BI Service, Gateway, Dashboard Optimization, Incremental Refresh, RLS.

Programming: Python (Pandas, NumPy), Automation Scripting.

Database: SQL Server, Azure SQL, Azure Data Factory (preferred).

Excel: Advanced Excel, Power Query, Power Pivot, Pivot Tables, VBA (preferred).

Preferred Skills

Microsoft Fabric, Azure Synapse, Snowflake, Databricks, REST APIs, Git, CI/CD, Power Automate, Data Governance, Machine Learning fundamentals.

Qualifications

Bachelor's degree in Computer Science, Engineering, Data Analytics, Statistics, or related field with 5-8 years of experience in Data Analytics, Business Intelligence, or Data Engineering.

Preferred Candidate

Strong analytical mindset, excellent stakeholder management, experience with enterprise-scale data, passion for automation, and ability to independently deliver end-to-end BI solutions.