Skip to main content

Data Analyst

Technology
4 days ago
Full time

Job description

Roles and Responsibilities Collect, clean, validate, and analyze data from multiple sources. Identify data patterns, trends, and insights to support business decisions. Write and execute SQL queries to retrieve, manipulate, and analyze data.

Create dashboards, reports, and visualizations using Power BI or Tableau. Perform data cleaning, transformation, and preprocessing. Analyze large datasets and identify business opportunities and potential issues.

Prepare daily, weekly, and monthly performance reports. Work with business teams to understand data requirements and reporting needs. Develop and maintain KPIs, metrics, and performance dashboards. Perform data validation and ensure data accuracy and consistency.

Identify discrepancies and investigate data-related issues. Automate repetitive reporting tasks wherever possible. Present analytical findings and recommendations to stakeholders. Maintain proper documentation of data processes, reports, and analysis.

Required Technical Skills

Strong knowledge of SQL, including joins, subqueries, aggregate functions, and stored procedures. Good knowledge of Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, and formulas.

Experience with data visualization tools such as Power BI or Tableau. Understanding of data cleaning, data transformation, and data validation. Basic knowledge of Python using Pandas, NumPy, and Matplotlib is preferred.

Understanding of databases such as MySQL, SQL Server, or PostgreSQL. Knowledge of statistical concepts and data analysis techniques. Ability to create reports, dashboards, and data visualizations. Understanding of ETL processes and data warehousing concepts.

Knowledge of business metrics and KPI analysis.

Required Soft Skills

Strong analytical and problem-solving abilities. Excellent attention to detail. Good verbal and written communication skills. Ability to interpret complex data and present insights clearly. Strong logical and critical-thinking skills. Ability to work independently and collaboratively. Good time-management and organizational skills. Ability to handle multiple projects and meet deadlines.

Key Performance

Indicators (KPIs) Accuracy and reliability of data analysis. Timely delivery of reports and dashboards. Data quality and validation accuracy. Efficiency in report generation and automation. Accuracy of KPI tracking and reporting. Quality of insights and business recommendations. Stakeholder satisfaction.

Preferred Skills Experience in Power BI dashboard development. Knowledge of Python programming for data analysis. Familiarity with cloud platforms such as AWS, Azure, or Google Cloud. Understanding of Big Data technologies. Knowledge of advanced Excel and statistical analysis.

Experience working with large datasets. Understanding of machine learning concepts is an added advantage.

Keywords
SQLMicrosoft ExcelPower BITableauData ValidationPythonData CleaningData TransformationPandasNumPyMatplotlibDatabase ManagementStatistical AnalysisETLData WarehousingKPI Analysis

Interested in this role?