Data Analysis / Data Analytics / Data Analyst
Data Analyst (Advanced Excel) (w/ SQL) (w/ Oracle)
Up to $70,000 to start plus full benefits
JobGiraffe's client is a maker of widely-recognized toys and collectibles
As Data Analyst, you will:
- Receive industry-specific training
- Oversee projects focused on sourcing new datasets
- Establish control frameworks for each project
- Ensure data integrity and data consistency, establishing best practice for data management
- Gather, compile, prepare and analyze data
- Summarize results, insights and trends and other key findings
- Run routine, special and ad hoc reports
- Conduct routine, special and ad hoc analysis
- Make recommendations based on your analysis and findings
- Identify shortcomings and areas for improvement
- Review and update company SOPs related to data management
- Utilize the SQL programming language for data analysis processes
- Maintain SAP B1 reporting infrastructure
- Develop and implement/deploy Tableau dashboards for reporting purposes
- Collaborate cross-functionally with various internal departments and leadership teams
- Handle special projects
- Perform other duties as assigned
An ideal candidate profile will include:
- Data Analysis / Data Analyst experience
- Advanced Excel Skills (vlookup, pivot tables, custom sorting/filtering, etc.)
Pluses:
- +++ SQL Programming experience
- +++ Oracle Database experience
- +++ SAP B1 experience
- +++ Crystal Reports experience
- +++ Tableau Desktop/Server experience
- +++ Python Programming experience
- +++ Advanced analytics experience *classification/predictive modeling, optimization models, forecasting)
- +++ Query Performance Tuning
West Suburbs of Chicago - Westmont, IL
JG ID #24-1445 - Westmont, IL 60559 – Liza Farrell, Lead Recruiter
Job Type: Full-time
Pay: $60,000.00 - $70,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- AD&D insurance
- Dental insurance
- Disability insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
Application Question(s):
- Do you have advanced Excel Skills (vlookup, pivot tables, custom sorting/filtering, etc.)?
Education:
Experience:
- Data Analysis / Data Analyst: 2 years (Preferred)
- SQL: 1 year (Preferred)
- Oracle: 1 year (Preferred)
- SAP: 1 year (Preferred)
- Tableau: 1 year (Preferred)
Work Location: In person