outlook Data Warehouse Design And Development Gathering Requirements MS SQL Analyst   Requirement id 21913 Job title Analyst Job location in Madison, WI Skills required MS Office Products, outlook, Data Analysis, Data Warehouse Design And Development Ga Open Date 20-Nov-2014 Close Date Job type Not specified Duration 6 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Analyst: MS Office Products, outlook, Data Analysis, Data Warehouse Design And Development Ga {NOTE: START DATE:1/5/2015 END DATE :6/30/2015} {NOTE:SUBMISSION DEADLINE 11/25/2014 8:00 AM on Tuesday Job Description DOT is looking for a candidate that can help us build our Data Warehouse & BI practice. The candidate will be working on Data Warehouse & BI projects, gathering & documenting requirements, designing solutions, developing ETL using Informatica PowerCenter, developing universes and reports using Business Objects, testing, and implementing solutions. They will be responsible for both ETL and business intelligence report design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Works with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Works with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 5 - 7 years experience or equivalent education. Ideal candidate will have experience designing Data Warehouse and BI solutions, and development experience with both Informatica PowerCenter and Business Objects. DW & BI Knowledge areas: 1. Data warehouse/data marts using Kimball & Inmon methodologies 2. Informatica PowerCenter ETL 3. SAP Business Objects universe and report design/development 4. XCelsius Dashboard design and development 5. Crystal reports 6. Oracle, DB2 and SQL Server 7. Dimensional Data Modeling 8. Slowly Changing Dimensions 9. Infoburst 10. Requirements gathering 11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 12. Excellent written and oral communications 13. Independent worker Informatica PowerCenter - ETL (5+years experience): • Data warehouse design • Data warehouse development Business Objects (5+ years experience): • SAP Business Objects Universe design and development • SAP Business Objects report design and development • Xcelsius dashboards Database Knowledge (5+years experience): • ORACLE • SQL Server • DB2 • Complex SQL statements   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 21913 while calling.   Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2), MS Office Products job openings in Madison, WI Jobs List Technical Architect II - 98076 - SP Create date: 20-Jan-2022 start date:2/28/2022 End date:02/28/2023 submission deadline: Wednesday, February 2 at 4:00PM CST. client info : DCF Note: * Interview Process: An in-person or video interview will be required before a final selection is made. Please submit local candidates ONLY. * Phone and web based i.... (This job is for - Monitoring Jobs in WI Madison Architect - (in Madison, WI)) Help Desk-1 - WISCJP00017955 Create date: 14-Dec-2020 Start Date :01/04/2021 End Date :06/30/2021 Submission Deadline :Due to SCS 12/16/2020 by 8:00 a.m. CT Client Info :DWD - Department of Workforce Development (DWD Description : The contractor must be able to commute daily into DWD office headquarters in Madison WI. During the CO.... (This job is for - job Jobs in WI Madison Consultant - (in Madison, WI)) Desktop Support-3 - WISCJP00016637 Create date: 04-Jun-2020 Start Date :07/01/2020 End Date :06/30/2021 Submission Deadline :Due to SCS 06/08/2020 by 8:00am CT Client Info : DHS - Department of Health Services (DHS) Note : * Duration: Initial Period: 07/01/2020 - 06/30/2021; Renewals/Extensions through 06/30/2023 Description .... (This job is for - Troubleshooting Jobs in WI Madison Consultant - (in Madison, WI)) Programmer Analyst-3 - WISCJP00014207 Create date: 02-Nov-2018 Start Date :11/26/2018 End Date :06/30/2019 Submission Deadline :Due to SCS 11/07/2018 by 8:00 a.m. CT Description : This posting is for two (2) Programmer Analyst 3 positions that will support the Division of Early Care and Education (DECE) in the implementation of the new Child Care Dev.... (This job is for - outlook Jobs in WI Madison Analyst - (in Madison, WI)) Database Architect - 3 - WISCJP00012143 Create date: 26-Apr-2018 Start Date : 05/14/2018 End Date : 06/30/2018 Submission Dead Line : Due to SCS 05/01/2018 by 8:00 am Business Unit : DOT - Division of Project Development (DPD) Description : Designs and builds relational databases. Develops strategies for data acquisiti.... (This job is for - job Jobs in WI Madison Architect - (in Madison, WI))    MS Office Products job openings in other states Jobs List Software Developer - 347 Create date: 24-Jan-2020 Environment: MS Office tools and products. Must be able to work on-site at Oakland County, Michigan Description : Experienced Workday Developer/Business Analyst needed to gather and document requirements from functional users and create design documents to configure and build reports and integrations for Workday Implementatio.... (This job is for - job Jobs in MI Pontiac Developer - (in Pontiac, MI)) Student Applications Adminstrator - 53517 Create date: 08-Jun-2018 Start Date : 06/18/2018 End Date : 06/30/2018 Submission Dead Line : 06/30/2018 Description : Note: Initial End date is 6/30/18 to coincide with our Fiscal year end. However, position will extend beyond that time period. Renewal contract will incl.... (This job is for - SDLC Jobs in GA Atlanta Administrator - (in Atlanta, GA)) IAM Program Contractor - 6244 Create date: 09-May-2017 Required Skills: MS Office products Required Customer Support/Interaction Required Communication (Verbal/Written) Required Identity & Access Management Experience Required Desired Skills: Authentication Directory (Active Directory, RACF, ACF2) knowledge .... (This job is for - job Jobs in OH Columbus Developer - (in Columbus, OH)) IT - DOT - Program Manager 4/PM4 - 44758 Create date: 09-Jan-2017 Start Date : 01/30/2017 End Date : 06/30/2017 Submission Deadline : 01/13/2017 Description : • Work with Agency project managers to facilitate the development of project scope definitions. • Maintain project level budgets, set standards for project level budget data reporti.... (This job is for - job Jobs in OH Columbus Manager - (in Columbus, OH)) Desktop Engineer - J-11-158-280 Create date: 29-Aug-2016 Start Date :09/11/2016 End Date :09/30/2017 Submission Deadline :09/02/2016 Description : Candidate will be part of the Software Lifecycle Management Portfolio responsible to successfully manage new applications and new updates to existing applications into a large enterprise environme.... (This job is for - Deployment Offshore Onshore Jobs in MN EDINA Engineer - (in Edina, MN))     (Analyst: MS Office Products, outlook, Data Analysis, Data Warehouse Design And Development Ga in Madison, WI)

Featured Jobs - - Consultant (Jobs in Tennessee, Tennessee) Communication Quality Assurance Tourbleshooting Analyst (Jobs in Tallahass J2EE Curam Technical Developer (Jobs in Raleigh, North Carolina) Migration Engineer (Jobs in Raleigh, North Carolina) - Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Nashville, Tennessee) datawarehouse Requirements Analyst (Jobs in Richmond, Virginia) Angular Vue.Js SQL Developer (Jobs in Madison, Wisconsin) React Vue.Js Developer (Jobs in Madison, Wisconsin) Java HTML/CSS/JavaScript Oral Developer (Jobs in Jackson, Mississippi)