Data Analyst [Locals and nearby to Chicago, IL]

Role: Data Analyst

Location: Chicago, IL (Onsite from Day 1) – Only Locals

Job Type: Contract

Mandatory Skills:

• SQL
• ETL
• IBM DataStage

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.