Credit Risk Business Systems Analyst &ndash Cognos and Netezza D (Montreal)

Credit Risk Business Systems Analyst &ndash Cognos and Netezza D

The start date of this job is flexible and in order to find the best candidate the job may remain open much longer than the date mentioned on this posting .. or you may be asked to start sooner than the expected start date if you are able to do so Please read the job description below and if this interests you please send a MS-Word version copy of your updated resume (ASAP) along with your salary expectations first available date and a telephone contact number E-mail to nikhil(at)teamrecruiter.com the recruiter in charge of this role is Nikhil AFTER you have submitted your resume via e-mail (when you have a moment) please apply online to match your resume to the job with following link s www.stafftrak.net ApplyOnline teamrecruiter.web tt JD& jobId 010597 If you do not think you are a match for this opportunity but know someone who is feel free to forward this email to them and you will be eligible for a referral bonus upon a successful hire. Our client is well established Major Bank looking for Credit Risk Business Systems Analyst Cognos & Netezza DW Location Downtown Toronto Duration 6 months contract position with strong possibility of further extension Summary Business Systems Analyst III Manager is seeking a Business Systems Analyst for the Risk Information Strategy 6MM project. MUST HAVES 3-5 years experience - Support BRD collection process with business - Develop and document specifications for reporting metrics - Develop specification for data warehouse and data marts - Experience creating data mapping documentation - Experience working with data data warehouses is required - Experience with SQL language - Write Queries - Supporting Business Requirements for the Business Team - Analyze Data - SRS - Microsoft Excel Microsoft PowerPoint Microsoft Outlook Nice to Have Knowledge of Credit Risk Data Integration and Reporting Knowledge of Data Quality methodologies and tools Knowledge of BI & Reporting tools (e.g. SAS Cognos) Knowledge of querying tools for Netezza DW (e.g. Aginity) Former Developer Enterprise Experience Responsibilities Work with business stakeholders as SMEs to assess current capabilities understand business requirements and translate and develop into Technical System Requirements Specification (SRS) documents. Position requires sound knowledge of data warehousing and reporting and related methodologies Work with the business to design effective To-Be processes identify and define detailed product requirements and use cases Work with the Solution Developers and IT Specialists (Solution Designers Configuration Data Modeler Test) to translate user and or systems requirements into functional technical specifications Collaborate closely with Application Owners Application Managers and Solution Designers as the business functional counterpart in solution identification and maintenance Support testing teams in translating requirements and use cases into test conditions and expected results for product performance user acceptance and operational acceptance testing participate in the testing of developed systems solutions Adhere to existing processes standards including the system development life cycle (SDLC) and project management methodology (PMLC) business technology architecture risk and production capacity guidelines and escalate issues as required Monitor product lifecycles ensuring specifications and functionality support business objectives and architecture decisions undertaking re-development as required Participate in quality management reviews in particular reviews of the designs prototypes and other requirements work products to ensure they fulfill the requirements Contribute to the development of project plans by participating in the scoping and estimating of proposed projects Communicate project status and provide timely escalation of issues to the Technology Project Manager (Application Manager Demand Manager Portfolio Manager) and ensure timely notification and escalation of possible issues problems options and recommendations for prompt resolution Act as a technical resource for business partners to ensure deliverables meet business and end-user requirements Continuously enhance knowledge expertise in own area and keep current with leading-edge technologies trends developments and develop expertise in services applications infrastructure analytical tools and techniques that can contribute to effective solution development delivery Work with the Technology Project Manager and architecture organization to define metrics and performance goals for the application Assist in the delivery and maintenance of secure computing facilities and technical infrastructure architecture to support stakeholders and applications as appropriate Serve as a resource for the change enablement team as they evaluate training and performance support needs and design the training and performance support products Prioritize and manage own workload in order to deliver quality results and meet timelines Support a positive work environment that promotes service to the business quality innovation and teamwork and ensure timely communication of issues points of interest Advanced knowledge of tools (e.g. MS Office Excel Access Visio) within own area Identify and recommend opportunities to enhance productivity effectiveness and operational efficiency of the business unit and or team Participate in knowledge transfer within the team and business units Establish effective relationships across multiple business and technology partners program and project managers Sound knowledge of Bank and technology standards (e.g. infrastructure architecture processes applications). Sound to advanced knowledge of source to target data mapping and data analysis. Expert knowledge of business analysis principles Sound to advanced knowledge of technical environment and applications supported Sound to advanced knowledge of SQL language Subject matter expert and consults with clients and or project teams Involved in all aspects of the business analysis process and may provide guidance and direction to other Business Analysts Acts as a key resource for the project team and the business assuming Lead Business Systems Analyst role within projects on one of the work streams Supports the development of detailed complex and or comprehensive project plans and or large projects Leads resolution of client applications issues Education University Degree in Information Technology or Software Engineering Please fill the below Qualifications Matrix indicating your skill level Qualification Rating Must Have Short-listing Questions Experience with Business Intelligence tools (SQL SAS etc.) Yes has transitioned from systems analyst to a business systems analyst (technology) role Yes Skills Banking Financial Industry Experience 1 Yrs. Communication Skills - Please Provide Rating - 1 to 5 (excellent) Data Mapping 3 Yrs. Data Marts 3 Yrs. Datawarehouse experience 3 Yrs. Excel 5 Yrs. Excellent grasp of writing complex and optimized SQL queries 3 Yrs. MS Office (Word Excel Outlook) 5 Yrs. Please note that this is the most up to date version of job description available at this time During Client Interview you will receive additional information variance may apply When you have some time please register in our database (5 minute process) to be considered for future openings the link is available on our website at www.teamrecruiter.com in the Candidate section. We thank all applicants for their interest. Only those who meet the qualifications will be contacted through telephone email. You are encouraged to register with us in our database to be considered for future positions available. Have a great day. ......At Teamrecruiter.com we offer some of the most highly qualified professionals in the workforce. We dedicate an industry trained recruitment specialist to the following areas IT Finance Admin Sales Executive Search and Contractors. If you would like to learn more about our full-service recruiting firm please visit our website at www.teamrecruiter.com. CAMSC and ACSESS certified ..All Offers are conditional on Client Post-Offer Conditions being met and removed by end client prior to written offer signing