Data Analyst

EZeats

Data Analyst

About this role

We are seeking a highly analytical and detail-oriented Data Analyst with 1+ years of experience to join our team. The ideal candidate will have a strong understanding of data analysis techniques, a deep knowledge of SQL aggregation, and hands-on experience working with key data technologies.

Responsibilities

Collect, clean, and preprocess large datasets from various sources.

Write and optimize complex SQL queries for data extraction, aggregation, and analysis.

Perform data analysis using advanced aggregation techniques to identify trends, patterns, and actionable insights.

Develop and maintain dashboards and reports to visualize key metrics using tools like Tableau, Power BI, or Looker.

Work closely with cross-functional teams to understand data needs and deliver solutions.

Conduct A/B testing and statistical analysis to support business experiments and measure success.

Ensure data quality, accuracy, and integrity across all data processes.

Document data workflows and provide technical guidance to team members when needed.

Qualifications & Work Experiences

Proven experience as a Data Analyst or in a similar role.

Deep understanding of SQL, including advanced aggregation (e.g., GROUP BY, HAVING, window functions).

Hands-on experience with data visualization tools (e.g., Tableau, Power BI, or Looker).

Proficiency in Excel (pivot tables, advanced formulas) and scripting languages like Python or R for data analysis.

Familiarity with database systems such as PostgreSQL, MySQL, or Snowflake.

Experience with ETL processes and working with large datasets.

Knowledge of statistical methods and tools for analysis (e.g., regression, hypothesis testing).

Strong problem-solving skills and attention to detail.

Preferred Skills (Optional)

Experience with big data tools like Spark or Hadoop.

Knowledge of cloud platforms (AWS, GCP, Azure) for data storage and processing.

Understanding of data modeling and schema design principles.

Experience working with APIs and integrating data from external sources.