What are the responsibilities and job description for the Data Analyst (W2 Only) position at CO?
Data Analyst I
Lincolnshire, IL
6 Months
Max Pay rate: $27
Hybrid: Tuesday, Wednesday, Thursday- Possible Monday/Friday as required to complete project.
Certifications: Data lake, Alteryx, PBI, database management, SQL preferred
Years of experience 3-5
Interview schedule: Teams phone screen, 2nd round
Job Overview:
We are seeking a skilled Database Management and Data Analyst with a strong background in manufacturing to join our team on a 6-month contract basis. The ideal candidate will possess expertise in managing databases (Data Lake), solving data gaps, and creating Power BI dashboards, with specific experience in handling Bill of Materials (BOM). This role is crucial in ensuring data integrity, optimizing manufacturing processes, and transforming data into actionable insights through interactive visualizations.
Key Responsibilities:
- Database Management:
o Oversee, develop and maintain manufacturing database systems, ensuring data accuracy and integrity.
o Identify, analyze, and resolve data discrepancies and gaps related to manufacturing data.
- Data Gap Solving:
o Conduct thorough audits of BOM and Item data to identify inconsistencies and gaps.
o Develop and implement strategies to address and rectify data gaps, particularly within BOM or Items.
o Collaborate with BOM analysts and our outsourced manufacturers to ensure comprehensive data coverage and quality.
- Power BI Dashboarding:
o Design, develop, and maintain interactive Power BI dashboards tailored to manufacturing metrics and KPIs.
o Transform complex manufacturing data sets into intuitive and actionable visualizations.
o Work closely with stakeholders to understand reporting needs specific to manufacturing operations.
- Collaboration and Communication:
o Collaborate with IT, manufacturing, and business teams to gather requirements and deliver effective data solutions.
o Communicate findings and insights clearly to both technical and non-technical stakeholders.
Qualifications:
- Proven experience in database management and data analysis within the manufacturing sector.
- Strong proficiency in Power BI and creating interactive dashboards.
- Experience with SQL and database querying, with a focus on manufacturing data.
- Understanding of Bill of Materials (BOM).
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently and manage multiple tasks within a fixed time frame.
Preferred Qualifications:
- Familiarity with manufacturing ERP systems.
- Advanced Excel skills and experience with other data management software.
Job Type: Contract
Pay: $25.00 - $27.00 per hour
Schedule:
- 8 hour shift
Education:
- Bachelor's (Preferred)
Experience:
- Data lake: 5 years (Preferred)
- Alteryx: 5 years (Preferred)
- Power BI: 5 years (Preferred)
- SQL: 5 years (Preferred)
- Data Gap: 5 years (Preferred)
- Data management: 5 years (Preferred)
Ability to Commute:
- Lincolnshire, IL 60069 (Preferred)
Ability to Relocate:
- Lincolnshire, IL 60069: Relocate before starting work (Preferred)
Work Location: In person
Salary : $25 - $27
