Title: Data Analyst
Location: Chicago, IL (Hybrid 3 days office a week)
Duration: 6 Month assignment with possibility of extension
Description:
Qualifications (must haves):
- SQL
- Data warehousing
- Data modelling and Design
Nice to have: Experience in the banking
Tasks & Responsibilities:
-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
-Guide the production support team on unforeseen issues, ETL abendss