IT Information Analyst (SQL, Datawarehouse)
Location: Falmouth, Maine
Posted: November 25, 2016
Reference ID: 1765667308
Adecco is assisting a local Client andrecruiting for an Information Analyst (SQL, Data Warehouse) in Falmouth, Maine. This position is for Adecco's large Financial/Investments clients. It is a great opportunity with a well-established company and offers a competitive W-2 compensation and benefits package. Job Location: Falmouth, ME Relocation: No relocation assistance is available Remote Option: No Onsite Only Education Requirement: Bachelor's Degree Length of W-2 position: 12 Months, possible extension based on business needs Experience Level: 3+ years of experience Pay Rate: $48.52 / Hour W-2 Position Type: W-2 Only no corp-corp or third party please Adecco does not sponsor Visa candidates at this time. To be considered for this position, you must have the legal right to work in the US without sponsorship To Apply: Apply Online by selecting "Apply Now" so your resume will be sent directly to the recruiter. Job Overview: Team is new and considered a 'start-up', all hands on deck mentality right now to get this up and running. Team is creating a central data warehouse for whole bank Taking information from 30+ systems used in different depts. and creating a data warehouse pulling al this information into an easy, searchable database. A lot of interaction with LOB's across bank including Technology side of business Data indexes, conformed names for the data, ETC. Understand how data warehouse works Will be addressing any problems that arise Will not be doing the work in the actual data warehouse, but more of the initial process of creating Confirms project requirements by studying user requirements; conferring with others on project team. Database Analyst would serve as the point of contact for requests ranging from moderate to very complex that are received daily. Conduct analysis of requests and provide consultative advice to the requestors to arrive at the most effective solution for delivering desired output by applying all available departmental tools. Maintains data dictionary by revising and entering definitions. Work as part of a project team to coordinate database development and determine project scope and limitations. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Maintains client confidence and protects operations by keeping information confidential. Contributes to team effort by accomplishing related results as needed. Maintains user reference by writing and rewriting database descriptions. Identifies data sources constructs data decomposition diagrams, provides data flow diagrams and documents the process. Define and implement incorporated data standards. Formulate and recommend to management new and/or modified data policies Required Skills and Qualifications: Effectively apply any available tools (including, but not limited to, EasyTrieve, PowerSelect, SQL, MS Access, Monarch, File Manager and Visual Basic code) Analyzing & querying complex data using Access, SQL Server & Excel 3+ Ability to construct and use basic SQL statements 5 Yrs Data Warehouse workflow experience 3 Yrs DB knowledge, data warehouse and data mart 3 Yrs Speak/facilitate meetings with both business and technology teams, interacting with all levels within the bank Flexible to pick-up whatever needs to be done, regardless of task, to assist team in end goal Able to get to the core of business requirements Previous experience with larger projects, working with several LOB's at one time Previous project experience within Banking/FI's with different LOB's within the banking stream (Wealth, Commercial, Consumer, etc.) SQL Experience required - comfortable with data and SQL, as well as the logic behind it, does not need to code but does need to be comfortable to read/write, must be able to use queries within the database & able to pull results Understand and getting requirements for data warehouse team Candidate needs to be heavy on the data side, but also need to have business acumen because they will be gathering requirements. To Apply: Apply Online by selecting "Apply Now" so your resume will be sent directly to the recruiter. Adecco Group offers Consultant benefits including Holiday, 401(k), Insurance Benefit Plans and Service/Anniversary Bonus opportunities. Adecco Group is an Equal Opportunity Employer. All applicants required pass a Criminal Background and Drug screen prior to employment. Equal Opportunity Employer Minorities/Women/Veterans/Disabled The Adecco Group is a global leader in HR services. Our group connects over 700,000 associates with our business clients each day through our 6,600 offices in over 70 countries and territories around the world. We offer employment opportunities at any stage in your professional career. Contact us today to discuss available contract and direct hire positions.