Senior Data Analyst (ETL and DWH)-US

Senior Data Analyst (ETL and DWH)Location: Chicago IL (Onsite)Duration: Contract/FulltimePreferred to have someone local/relocate to IL, if not we can look into remote options – but need good candidatesPlease share senior candidate profilesRequirements:Strong ETL and DWH background with 12 to 15 years+ experience range.Should have experience of developing architecture by gathering requirements from multiple data sources and also should have experience of creating business Intelligence and reporting based on the DWHCustomer wants a resource who is good in gathering requirements, convert those requirements in the architecture, develop it in the ETL and also work on the BI aspects.Job Description:Overall 12+ years of experience in ITAs a data analyst, exp. > 5 yearsExperience in DataikuDatabases Oracle, SQL, T-SQL, My SQL, Mongo DBETL Tools Tableau Prep, Alteryx, SSIS, SSRS, SSASReports Tableau, SSRS, Power BI Business Analysis Requirement analysis, business rules, data flow diagram, flowcharts, business process modeling & improvement, functional requirement Analysis, source target mappings, gap analysis, cause and effect analysis, decision tree.Data Modeling ER Diagrams, Conceptual, Logical & physical modeling.Data Analysis Techniques Neural Network, Clustering, ClassificationMust have Excellent SQL skills, building complex SQL queries from scratch to pull and analyze dataMust have basic programming skills with Python or Java languageMust have understanding of Database conceptsExcellent proficiency with MS Office (viz. Excel and PowerPoint)Good to have experience with Operations, Purchasing and Supply ChainGood statistical knowledge and skillsGood to have some dashboarding skillsStrong attention to detail – will be responsible for providing key information to data partners/stakeholdersGood communications skills, with a knack for synthesizing data into meaningful business findings Zortech Solutions