Data Analyst - SQL/Power BI in Gurgaon, भारत

Total Experience : 4 - 5 yearsResponsibilities :- Conduct moderately complex data profiling and analysis to evaluate data sources to determine the best source for business information.- Collaborate with data engineers to perform data validation and testing activities as appropriate.- Work directly with internal customers to refine requirements and validate output to ensure solutions will meet expectations and deliver actionable insights through data analysis.- Create advanced database queries, optimize SQL queries for improved performance.- Develop and implement data analysis frameworks and methodologies.- Perform root cause analysis for data quality issues and implement solutions.- Produce reports and dashboards to communicate findings to stakeholders.- Support data governance initiatives and compliance https://jobeax.com/link/khbfukHRAsN6cKO0 :- Advanced knowledge of data analysis tools and methodologies.- Proficiency in SQL and database technologies.- Strong knowledge of business intelligence and analytics platforms.- Excellent analytical and communication skills.- Collect, clean, transform, and analyze large and complex datasets from multiple sources.- Write optimized and complex SQL queries for data extraction, transformation, aggregation, and analysis.- Use Python for data analysis, automation, statistical analysis, and data processing.- Work with GCP services such as BigQuery, Cloud Storage (GCS), and other relevant cloud data services.- Develop and maintain analytical datasets, data models, and reporting solutions.- Identify trends, patterns, anomalies, and business opportunities from data.- Build dashboards, reports, and visualizations using tools such as Looker, Looker Studio, Power BI, or Tableau.- Perform data validation and quality checks to ensure accuracy and consistency.- Automate repetitive reporting and data-processing activities using Python and SQL.- Collaborate with business stakeholders, data engineers, product teams, and other technical teams to understand analytical requirements.- Translate business requirements into data queries, analytical solutions, and actionable insights.- Monitor key performance indicators (KPIs) and provide regular analytical reports.- Support ad-hoc analysis and provide data-driven recommendations to stakeholders.- Document data sources, analytical processes, queries, and reporting logic. (ref:hirist.tech)