Job Title: Entry-Level Data Analyst
Location: Chicago, IL
Job Type: Only W2
Job Description:
· Collect, clean, and analyze data from multiple sources.
· Write SQL queries to extract and manipulate data.
· Create reports and dashboards using tools such as Power BI or Tableau.
· Perform data validation and identify data quality issues.
· Analyze trends, patterns, and business performance metrics.
· Prepare daily, weekly, and monthly reports.
· Support senior analysts and business teams with ad-hoc data requests.
· Maintain and update datasets, reports, and dashboards.
· Communicate analytical findings to technical and non-technical stakeholders.
· Document data sources, processes, and reporting procedures.
· Assist with automating repetitive reporting tasks.
Required Skills:
· SQL — SELECT, WHERE, JOIN, GROUP BY, subqueries, aggregations.
· Excel — PivotTables, VLOOKUP/XLOOKUP, formulas, charts, data cleaning.
· Basic understanding of data analysis and statistics.
· Familiarity with Power BI or Tableau.
· Good analytical and problem-solving skills.
· Strong attention to detail.
· Good written and verbal communication skills.
Preferred Skills:
· Python, especially Pandas and NumPy.
· Power BI/DAX or Tableau.
· Basic knowledge of relational databases.
· Understanding of ETL/data pipelines.
· Basic knowledge of statistics.
· Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.
· Experience working with large datasets.
Qualifications:
· Bachelor’s degree in computer science, Data Analytics, Statistics, Mathematics, Business Analytics, Engineering, or a related field.