Job Title: Data Analyst I
Location: Chicago, IL (Remote)
Employment Type: Full-Time
Work Authorization: OPT / CPT / GC-EAD / H4-EAD / L2-EAD
Key Responsibilities
- Pull marketing and customer data from internal tools and reporting systems and validate data accuracy before distribution.
- Monitor campaign performance regularly and identify reporting gaps, inconsistencies, or unexpected trends.
- Prepare recurring reports and dashboards using Excel and Power BI for weekly and monthly business reviews.
- Support senior analysts with ad-hoc analysis related to customer behavior, marketing performance, and business insights.
- Collaborate with marketing and business stakeholders to understand reporting requirements and delivery timelines.
- Maintain and update reporting documentation, metric definitions, and report logic.
Required Qualifications
- Bachelor’s degree in Data Analytics, Business Analytics, Statistics, Economics, Computer Science, Marketing, or a related field.
- 1–3 years of experience in data analysis, reporting, or business intelligence through professional work, internships, academic projects, or training programs.
- Strong proficiency in Microsoft Excel, including pivot tables, lookups, data validation, and reporting functions.
- Hands-on experience with Power BI or Tableau for dashboard development and reporting.
- Good working knowledge of SQL for data extraction, validation, and analysis.
- Understanding of marketing analytics, customer data analysis, and campaign performance metrics.
- Strong analytical, problem-solving, and communication skills with attention to detail.
- Ability to explain insights and findings clearly to non-technical stakeholders.
Preferred Qualifications
- Experience with analytics tools such as Google Analytics or Adobe Analytics.
- Familiarity with CRM and marketing platforms including Salesforce, Google Ads, Meta Ads Manager, or similar tools.
- Basic knowledge of Python or R for reporting automation or data analysis is a plus.
- Exposure to ETL workflows, reporting processes, and data quality validation.
- Experience working in marketing analytics, digital analytics, or customer insights environments preferred.