Source description
About the role
Job Description : We are looking for an experienced SQL Developer / BI Analyst with strong expertise in SQL, BI & Analytics, Python, and Prompt Engineering. The ideal candidate should have hands-on experience in developing complex SQL queries, building dashboards and analytical reports, optimizing database performance, and leveraging AI tools for analytics and automation. Key Responsibilities : - Develop and optimize simple and complex SQL queries using Joins, String Functions, Date Functions, Ranking Functions, Analytical Functions, and Set Operators. - Work extensively on SQL performance tuning, query optimization, execution plan analysis, and troubleshooting deadlocks. - Create and maintain database objects such as Stored Procedures, Functions, Views, Triggers, Indexes, and Constraints. - Build and manage Temporary Tables, Table Variables, CTEs (Common Table Expressions), Subqueries, Derived Tables, and complex joins involving multiple tables. - Analyze business data and generate actionable insights through BI and Analytics solutions. - Design and develop dashboards, reports, and visualizations using BI tools such as Tableau, Power BI, Google Data Studio / Looker Studio, and PLX Dashboards. - Use SQL Profiler and other monitoring tools to track and improve query performance. - Develop Python-based solutions for data analysis, automation, reporting, and data processing. - Work with Python libraries such as Pandas, NumPy, Matplotlib, and Seaborn for analytics and reporting purposes. - Utilize Prompt Engineering techniques to effectively use AI tools such as ChatGPT, Copilot, Gemini, or similar GenAI platforms for SQL generation, reporting automation, data analysis, and productivity enhancement. - Create, refine, and optimize prompts to generate accurate and context-aware AI responses. - Collaborate with business and technical stakeholders to understand reporting and analytics requirements. Mandatory Skills : - Strong SQL Development and Query Optimization - BI & Analytics Experience - Python Programming - Prompt Engineering / Generative AI Tools - Tableau / Power BI / Data Visualization Tools - Stored Procedures, Functions, Views, and Triggers - Execution Plan Analysis and Performance Tuning Preferred Skills : - Knowledge of Data Warehousing concepts - Exposure to Cloud-based Analytics platforms - Strong analytical and problem-solving skills - Good communication and stakeholder management skills Interview Process : - Interview Rounds : 3 Technical Rounds followed by HR Round. Job Description : We are looking for an experienced SQL Developer / BI Analyst with strong expertise in SQL, BI & Analytics, Python, and Prompt Engineering. The ideal candidate should have hands-on experience in developing complex SQL queries, building dashboards and analytical reports, optimizing database performance, and leveraging AI tools for analytics and automation. Key Responsibilities : - Develop and optimize simple and complex SQL queries using Joins, String Functions, Date Functions, Ranking Functions, Analytical Functions, and Set Operators. - Work extensively on SQL performance tuning, query optimization, execution plan analysis, and troubleshooting deadlocks. - Create and maintain database objects such as Stored Procedures, Functions, Views, Triggers, Indexes, and Constraints. - Build and manage Temporary Tables, Table Variables, CTEs (Common Table Expressions), Subqueries, Derived Tables, and complex joins involving multiple tables. - Analyze business data and generate actionable insights through BI and Analytics solutions. - Design and develop dashboards, reports, and visualizations using BI tools such as Tableau, Power BI, Google Data Studio / Looker Studio, and PLX Dashboards. - Use SQL Profiler and other monitoring tools to track and improve query performance. - Develop Python-based solutions for data analysis, automation, reporting, and data processing. - Work with Python libraries such as Pandas, NumPy, Matplotlib, and Seaborn for analytics and reporting purposes. - Utilize Prompt Engineering techniques to effectively use AI tools such as ChatGPT, Copilot, Gemini, or similar GenAI platforms for SQL generation, reporting automation, data analysis, and productivity enhancement. - Create, refine, and optimize prompts to generate accurate and context-aware AI responses. - Collaborate with business and technical stakeholders to understand reporting and analytics requirements. Mandatory Skills : - Strong SQL Development and Query Optimization - BI & Analytics Experience - Python Programming - Prompt Engineering / Generative AI Tools - Tableau / Power BI / Data Visualization Tools - Stored Procedures, Functions, Views, and Triggers - Execution Plan Analysis and Performance Tuning Preferred Skills : - Knowledge of Data Warehousing concepts - Exposure to Cloud-based Analytics platforms - Strong analytical and problem-solving skills - Good communication and sta