BIG Language Solutions - Senior Data Analyst - ETL/Python
hirist
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)