BIG Language Solutions - Senior Data Analyst - ETL/Python

BIG Language Solutions; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

BIG Language Solutions is seeking a Senior Data Analyst to design enterprise BI and data pipelines using SQL Server, SSIS, Power BI, and Azure SQL. The role focuses on building scalable ETL pipelines, optimizing databases, automating reporting, and delivering executive dashboards for data-driven decisions.

The candidate will mentor junior analysts, develop BI best practices, and collaborate with stakeholders to translate requirements into scalable BI solutions in a fast-paced setting.

Qualifications

• Bachelor's degree in CS/Engineering/Data Analytics with 5-8 years of experience.
• Solid experience in SQL Server, SSIS, Power BI, Azure SQL, and ETL development.
• Experience building enterprise BI and data warehouse solutions.
• Ability to translate requirements into scalable BI solutions.
• Mentor junior analysts and establish BI best practices.

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 RLS.
• 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.

Skills

SQL Server

SSIS

Power BI

Azure SQL

ETL development

Python

Data Analytics

BI

Education

Bachelor's degree in Computer Science / Engineering / Data Analytics

Tools

Microsoft Fabric

Azure Synapse

Snowflake

Databricks

REST APIs

Git

CI/CD

Power Automate

Data Governance

Machine Learning

Job description

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 Skills :
• Microsoft Fabric, Azure Synapse, Snowflake, Databricks, REST APIs, Git, CI/CD, Power Automate, Data Governance, Machine Learning :

Education and Experience

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.

ref:hirist.tech