USA_Developer
Pay Rate Range: $50.00 - 51.47/hr.GBAM Req ID: 10683391Job Description: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 skillsMust 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 logicRoles & 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 casesSkills: Digital : Python~Digital : Microsoft Power BI~PL/SQLExperience Required: 8-10 yearsSkills:CategoryNameRequiredImportanceExperienceSkillCategoryTest1_MNDigital : PythonYes17+ years