Data Analyst

Job summary

Collect, clean, validate, and analyze data from multiple sources, using SQL, Excel, and visualization tools to create dashboards and reports. Identify trends and process improvements, document analytical work, and communicate actionable insights to stakeholders to support business decisions.

Job details

Key Responsibilities Collect, clean, validate, and analyze structured data from multiple sources. Write SQL queries to extract, manipulate, and analyze data from databases. Develop and maintain dashboards, reports, and visualizations using Power BI or Tableau. Perform data validation, identify inconsistencies, and ensure data accuracy. Analyze trends, patterns, and key performance indicators (KPIs) to support business objectives. Prepare periodic, ad hoc, and management reports. Use Excel functions, PivotTables, lookups, and other analytical tools for data analysis. Collaborate with business stakeholders to understand reporting requirements and translate them into analytical solutions. Identify opportunities for process improvement through data analysis. Document data definitions, reporting processes, and analytical findings. Present insights and recommendations to technical and non-technical stakeholders. Support data-driven decision-making through accurate and timely reporting. Required Skills and Qualifications Strong proficiency in SQL, including joins, subqueries, aggregations, and CTEs. Advanced Microsoft Excel skills, including PivotTables, lookup functions, and data cleansing. Hands-on experience with Power BI or Tableau for dashboard development and data visualization. Strong understanding of data cleaning, data validation, and exploratory data analysis. Knowledge of KPIs, business metrics, trend analysis, and statistical concepts. Ability to interpret complex data and communicate actionable insights. Excellent analytical thinking, attention to detail, and problem-solving skills. Good communication and stakeholder management skills. Preferred Skills Knowledge of Python for data analysis using Pandas and NumPy. Familiarity with statistical analysis and hypothesis testing. Experience with data warehousing, ETL processes, and data integration. Exposure to cloud data platforms such as Azure, AWS, or Google Cloud. Knowledge of automation and reporting optimization.

What you’ll do

Collect, clean, validate, and analyze data from multiple sources, using SQL, Excel, and visualization tools to create dashboards and reports. Identify trends and process improvements, document analytical work, and communicate actionable insights to stakeholders to support business decisions.

Requirements

Requires strong SQL and advanced Excel skills, experience with Power BI or Tableau, and knowledge of data cleaning, validation, exploratory analysis, KPIs, and business metrics. Candidates should be analytical, detail-oriented communicators; Python, statistical testing, data warehousing, ETL, cloud platforms, and reporting automation are preferred.

Listed skills

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

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Microsoft Excel
• Power BI
• Tableau
• Data Cleaning
• Data Validation
• Exploratory Data Analysis
• KPI Analysis
• Trend Analysis
• Data Visualization
• Dashboard Development
• Python
• Pandas
• NumPy
• Statistical Analysis
• Stakeholder Communication

Job areas

• Data & Analytics
• Technology
• Software

More jobs from Spait Infotech