Role: Data Analyst
Location: Chicago, IL (Onsite from Day 1) – Only Locals
Job Type: Contract
Mandatory Skills:
Job Description:
- Strong in SQL and Data warehouse concepts; Hands on experience working in a data warehouse environment.
- Write complex SQLs to analyze/profile datasets and identify patterns.
- Recommend solutions based on data analysis.
- Demonstrate strong analytical and problem-solving skills and be quick to identify design related concerns.
- Provide Data Requirements.
- Collaborate with Subject Matter experts and Business partners in gathering data requirements.
- Work independently and demonstrate strong understanding of existing Data model and ETL processes.
- Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping.
- Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline.
- Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.
- Demonstrate strong negotiation skills while working with developers, architects to solution the data needs.
- Validate the accuracy, integrity and quality of Data developed.
- Support defects triage.
- Participate in the SIT, UAT defects triage and help set up a defect resolution path.
- Assess defects on their impacts and help set up priorities.