Data ModelerLooking for a creative, logical, inquisitive, assertive analyst with strong critical thinking skills to assist with the development of a Risk Data Warehouse.Minimum 5 years professional experience in Business Intelligence and Data Warehouse system implementationSolid knowledge of Data Warehousing principles and implementation methodologiesExperience of designing and working with relational and dimension models and complex record layouts, both structured and unstructuredWorking knowledge in technical aspects of business intelligence including data modeling, relational database management systems, ETL, metadata / data management, and OLTP toolsSolid analytical, problem solving and strategic thinking skillsProven experience as a quick learner and effective change agentSelf-starting attitude and self-leading on problem solvingConsistent high attention to detailHas expert knowledge of applications systems analysis techniquesAble to rapidly learn technical/business techniques and disciplines of special value to the systems supportedSolid understanding of computers, programming, database tools/software, and Microsoft productivity applications (Excel, Word, PowerPoint, Visio, Project, Access)Moderate working knowledge of an ETL tool (Data Stage, etc) a plusWorking experience with relational database, such as Oracle, SQLServer is requiredSAP Business Objects experience a plusRelational databases, filtering, aggregating data, joinsSolid SQL skill and be able analysis the data and issue root cause, as well as create complex analytical proceduresSource to target data mappingAbility to trace where data comes fromAnalysis of source systems that feed the data warehouseSource to target data mapping (application to data warehouse; data warehouse to data marts; data marts to reports)Work in collaboration with various teams to develop target modelsDevelop transformation rules based on profiling resultsDeveloping user stories based on business and system requirementsSupport and improve business process, data management and governance standardsAssist in the identification and assessment of potential new data sourcesParticipate in meta data documentation, data profiling, and monitoringStrong English and technical documentation writing skill is requiredPerform impact and root cause analysisDrill into business processes, data quality, data relationships, and data flows to gain insight and understandingPartner with other team members to translate business requirements into technical specifications and ensure a smooth hand off to developers and quality assurance analystsUtilize existing artifact templates to capture requirements and proactively identify opportunities for improvements to existing standards or additional artifacts that will ensure high quality contents and deliveryWhen applicable, create test conditions and test scripts as a basis for user acceptance testingIdentify risks or barriers early in projects that would impede successful completion of tasks and make recommendations for approaches/solutionsPromote a culture that values attention to detail, repeatability, traceability, in depth questioning and communication