Data Analyst

Job summary

Collect, clean, validate, transform, and analyze data from multiple sources, using SQL, Excel, and business intelligence tools to create dashboards and reports. Track KPIs, ensure data quality, collaborate with stakeholders, and present findings and recommendations to support data-driven decisions.

Job details

Key Responsibilities Collect, clean, validate, and transform data from multiple sources. Write SQL queries to extract, filter, join, and aggregate data from databases. Analyze datasets to identify trends, patterns, anomalies, and business opportunities. Develop interactive dashboards and reports using Power BI or Tableau. Use Microsoft Excel for data analysis, reporting, PivotTables, and lookup functions. Track key performance indicators (KPIs) and prepare periodic business reports. Perform data quality checks to ensure accuracy and consistency. Collaborate with business stakeholders to understand reporting and analytical requirements. Present findings and recommendations to support data-driven decision-making. Maintain documentation and follow data governance and confidentiality standards. Required Technical Skills SQL: Joins, subqueries, aggregate functions, CTEs, and basic window functions. Microsoft Excel: PivotTables, XLOOKUP/VLOOKUP, IF functions, charts, and data cleaning. Power BI or Tableau: Dashboard development, data visualization, and reporting. Data Analysis: Data cleaning, exploratory data analysis, trend analysis, and KPI reporting. Statistics: Basic descriptive statistics, averages, percentages, and correlation concepts. Communication: Ability to explain analytical findings clearly to technical and non-technical stakeholders. Preferred Skills Basic Python knowledge using Pandas and NumPy. Experience with relational databases such as MySQL, SQL Server, or PostgreSQL. Understanding of data modeling, ETL concepts, and data warehousing. Familiarity with business intelligence and reporting processes. Academic projects, internships, or practical experience in data analytics.

What you’ll do

Collect, clean, validate, transform, and analyze data from multiple sources, using SQL, Excel, and business intelligence tools to create dashboards and reports. Track KPIs, ensure data quality, collaborate with stakeholders, and present findings and recommendations to support data-driven decisions.

Requirements

Requires SQL, Excel, Power BI or Tableau, data analysis, basic statistics, and the ability to communicate findings to technical and non-technical stakeholders. Preferred qualifications include basic Python with Pandas and NumPy, relational database experience, knowledge of data modeling, ETL and data warehousing, and practical analytics experience.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Tableau · Preferred
• Data analysis · Preferred
• Microsoft Excel · Preferred
• Communication · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Microsoft Excel
• Power BI
• Tableau
• Data Cleaning
• Data Analysis
• Data Visualization
• Dashboard Development
• KPI Reporting
• Exploratory Data Analysis
• Basic Statistics
• Python
• Pandas
• NumPy
• Communication
• Data Quality

Job areas

• Data & Analytics
• Technology
• Software

More jobs from Spait Infotech