Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
outlook Data Warehouse Design Requirements Gathering MS SQL Server Oracle SQL Serve
 
Requirement id 22000
Job title Analyst
Job location in Madison, WI
Skills required MS Office Products, outlook, Data Analysis, Data Warehouse Design Requirements Gathe
Open Date 01-Dec-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 Requirements Gathe

{NOTE: START DATE:1/05/2015

END DATE: 06/30/2015}

{NOTE: SUBMISSION DEADLINE:12/05/2014 8:00 AM on Friday}

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 Xcelcius 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

Required Skills:

MS Office Products
outlook
Data Analysis
Data Warehouse Design
Requirements Gathering
MS SQL Server
Oracle
SQL Server
SAS
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 22000 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 Requirements Gathe in Madison, WI)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved