Must Have Technical/Functional Skills:
– Design, write, and optimize complex SQL queries to extract, transform, and analyze data from multiple sources
– Develop and maintain Power BI dashboards and reports, ensuring data accuracy, performance, and business relevance
– Use Python for data cleaning, transformation, automation, and advanced analytics
– Strong hands-on experience with SQL (joins, CTEs, subqueries, performance optimization)
– Strong hands-on experience with Advanced SQL, including:
• Window functions (ROW_NUMBER, RANK, LAG/LEAD)
• CTEs and recursive queries
• Query performance tuning and optimization
• Advanced aggregations and conditional logic
Roles & Responsibilities:
• Design, write, and optimize advanced SQL queries involving:
• Complex joins
• Common Table Expressions (CTEs)
• Window/analytic functions
• Subqueries and correlated 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
Essential Skills:
– Design, write, and optimize complex SQL queries to extract, transform, and analyze data from multiple sources
– Develop and maintain Power BI dashboards and reports, ensuring data accuracy, performance, and business relevance
– Use Python for data cleaning, transformation, automation, and advanced analytics
– Strong hands-on experience with SQL (joins, CTEs, subqueries, performance optimization)
– Strong hands-on experience with Advanced SQL, including:
• Window functions (ROW_NUMBER, RANK, LAG/LEAD)
• CTEs and recursive queries
• Query performance tuning and optimization
• Advanced aggregations and conditional logic
Roles & Responsibilities:
• Design, write, and optimize advanced SQL queries involving:
• Complex joins
• Common Table Expressions (CTEs)
• Window/analytic functions
• Subqueries and correlated 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
Essential Skills:
We are seeking a highly skilled Data Analyst with strong expertise in SQL| Python| and Power BI to analyze complex datasets| build insightful dashboards| and support data-driven decision-making.
The ideal candidate will work closely with business and technical stakeholders to transform raw data into meaningful insights.
– Strong proficiency in SQL (joins| subqueries| CTEs| window functions| performance tuning)
– Strong hands-on experience with Python (Pandas| NumPy| data analysis libraries)
– Extensive experience with Power BI (DAX| Power Query| data modeling| dashboard creation)
– Strong analytical and problem-solving skills.