Description

You will design and optimize complex SQL queries and build Power BI dashboards to drive data analysis and reporting.

This role is on-site.

Responsibilities

• Design and optimize advanced SQL queries using complex joins, CTEs, window functions, and recursive queries.
• Develop and maintain Power BI dashboards and reports, ensuring data accuracy and business relevance.
• Use Python and Numpy for data cleaning, transformation, automation, and advanced analytics.
• Optimize query performance by tuning indexes, execution plans, and refactoring SQL logic.
• Build and maintain SQL-based data models, views, and stored procedures using PL/SQL.

Required Skills

• 10+ years of experience in data analysis and SQL development.
• Strong hands-on expertise with Advanced SQL, including window functions (ROW_NUMBER, RANK, LAG/LEAD) and CTEs.
• Proficiency in PL/SQL for writing stored procedures and implementing advanced logic.
• Expertise in Power BI, including DAX, Power Query, and dashboard development.
• Strong experience with Python, specifically Numpy, for data manipulation.
• Proven ability to analyze large datasets to identify trends, patterns, and anomalies.
• Experience with query performance tuning and execution plan optimization.

Preferred Skills

• Experience with data extraction and transformation for reporting and analytics use cases.

Key Skills

Education

Any Gradute