BIG Language Solutions - Senior Data Analyst - ETL/Python

hirist

Noida 5 Years Exp Posted 1d ago

Job Description

 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)

 

Similar Openings for You