|
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
Role Descriptions: 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
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
Desirable Skills:
Keyword:
Skills: Python , Microsoft Power
BI~PL/SQL
|
