Description

You will design, write, and optimize complex SQL queries to extract, transform, and analyze data from multiple sources. You will develop and maintain Power BI dashboards and reports, ensuring data accuracy, performance, and business relevance. You will use Python for data cleaning, transformation, automation, and advanced analytics.

Responsibilities

• Design and optimize advanced SQL queries involving complex joins, Common Table Expressions (CTEs), window functions, and subqueries.
• Perform data analysis on large, complex datasets to identify trends, patterns, and anomalies.
• Optimize query performance using indexes, execution plans, and query refactoring.
• Develop and maintain SQL-based data models, views, and stored procedures.
• Support data extraction and transformation for reporting and analytics use cases.

Required Skills

• 10+ years of experience in data analysis and SQL development.
• Strong hands-on experience with Advanced SQL, including window functions (ROW_NUMBER, RANK, LAG/LEAD), CTEs, and recursive queries.
• Proficiency in PL/SQL for stored procedures and advanced logic.
• Expertise in Power BI, including DAX, Power Query, and dashboard development.
• Strong experience with Python, specifically Numpy, for data cleaning and transformation.
• Proven ability to tune query performance and optimize execution plans.

Key Skills

Education

Any Gradute