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
Data Warehouse PLSQL Oracle 11g R2 Databases Oracle Data Dictionaries Kimball Data
 
Requirement id 43671
Job title Modeler
Job location in Madison, WI
Skills required Data Analysis, Erwin Data Modelling Tool, Database Design, Data Warehouse PLSQL Oracle 11g R2 Datab
Open Date 02-Mar-2015
Close Date
Job type Not specified
Duration 3 Months
Compensation DOE
Status requirement ---
Job interview type ---
Apply
   Email Recruiter: coolsoft
Job Description Modeler: Data Analysis, Erwin Data Modelling Tool, Database Design, Data Warehouse PLSQL Oracle 11g R2 Datab

[NOTE : START DATE :03-30-2015
END DATE :06-30-2015

NOTE: SUBMISSION DEADLINE:03-05-2015 8:00 AM on Thursday]


Job Description:

This is a senior level modeler position. We expect candidates to have an in-depth knowledge of data warehousing concepts, including expertise in facts and dimensions, and real-world modeling scenarios. Potential candidates will be tested on their technical knowledge prior to being considered for the position.

The individual in this position will:

* Develop conceptual, logical, and physical data models for DCF business intelligence efforts. Ensure that all relevant aspects of data model (granularity, etc.) are taken into account. Analyze the logical and physical database models and guarantee models are in accordance with standards.

* Be responsible for leading and facilitating communication with business customers, IT staff, and other stakeholders, incorporating business requirements into data model design. Provide support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into the databases.

* Translate technical aspects of data modeling (facts, dimensions, “snowflaking”, etc.) into language that non-technical users can understand. Work with both technologists as well as non-technical users with ease and approachability.

* Make recommendations on data maintenance tactics for slowly changing dimensions, data roll-off / archival planning, etc.

* Work with DBAs to coordinate instantiation of tables and other relevant database objects.

* Design models optimized for storage (warehouse) and query / retrieval (end user marts). Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues.

* Understand and balance business requirements and user expectations.

Experience with Human Services business intelligence is desirable.

Data modeler capabilities with 5 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks.

Other Notes to Vendors:
* An in person interview will be required before a final hire is made.
* Please bring three (3) business references to an interview.
* A background check may be required before final hire.


Required Skills:

* Data Analysis
* Erwin Data Modelling Tool
* Database Design
* Data Warehouse
* PL/SQL
* Oracle 11g R2 Databases
* Oracle Data Dictionaries
* Kimball Data Warehouse Methodologies
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 43671 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),
Data Analysis job openings in Madison, WI
Jobs List

Quality Assurance Analyst II - 148940
Create date: 29-Sep-2025
Start Date :10/27/2025
End Date :06/30/2026

Submission Deadline :10/6/25 at 4:00 PM CST

Client Info : DHS

Note:

* Onsite or Remote? Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense.

* Position is 100% remote within the state o.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))

Business Analyst/Consultant IV - 143210
Create date: 30-May-2025
Start date : 07/28/2025

End Date : 06/30/2026

Submission deadline : 6/6/2025 4:00:00 PM

Client Info : ETF

Note:

* Interview Process: remote via MS Teams

* Duration: 6/30/2026, likely to extend

* Onsite or Remote? Must be a current WI resident. This position can work .... (This job is for - Stakeholders Jobs in WI Madison Analyst - (in Madison, WI))

Data Warehouse Developer II - 130696
Create date: 20-May-2024
No of Submissions : 1

Start date : 07/01/2024

End date : 06/30/2025

Submission deadline : 5/22/24 at 4pm CST.

Client info : DCF

Note :

* INTERVIEW NOTES:
• Phone and web based interviews will be acceptable.
• However, an in--person interview may be required.
• I.... (This job is for - Data Warehousing Jobs in WI Madison Developer - (in Madison, WI))

Project Management Office - 105370
Create date: 01-Mar-2023
Start date : 03-06-2023

End Date : 12-29-2023

Submission deadline : 3/8/2023

Client Info : QBE Regional Companies (N.A.), Inc.

Description :

Specific Needs:

· Strong Guidewire ClaimCenter Experience, including:

o Common integrations

o Multiple policy data source.... (This job is for - job Jobs in WI Madison Manager - (in Madison, WI))

Business Analyst/Consultant II - 113830 - SP
Create date: 30-Jan-2023
start date : 02/20/2023

End date : 06/30/2023

submission deadline : February 6, 2023, at 4:00PM CST.

client info : UW - Madison

Note :

* Interview Process: Zoom w/camera on. Number of rounds (1 to 2)

* Duration: Contract ending on June 30, 2023, with possibility of extension. .... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))
 
 Data Analysis job openings in other states
Jobs List

Systems Analyst - RFS 65129
Create date: 26-Nov-2025
Start date :12/15/2025
End Date :03/31/2028

Submission deadline :12/04/2025 by 8:00 A.M. CST

Client info: Tennessee Department of Health (TN-DOH)

Note:

* Position Location: Onsite

* In-person, with the potential for remote work upon completion of training and demonstrated proficiency 66.... (This job is for - SQL Jobs in TN Nashville Analyst - (in Nashville, TN))

Data Architect - Data Strategy And Analytics Lead
Create date: 20-Nov-2025
Start date : 01/26/2026

End Date : 01/22/2027

Submission deadline : 12/03/2025

Client Info : CT DAS

Note:

* Remote

* This is ahands-on senior contributor role requiring demonstrated leadership of data programs, initiatives, or teams.Junior candidates will not be considered. job Jobs in CT Hartford Architect - (in Hartford, CT))

Mainframe Developer Intermediate - 64848
Create date: 15-Sep-2025
Start Date :10/6/2025
End Date :10/31/2026

Submission Deadline : 09/19/2025

Client Info : Ne TRANS

Note :

* Position Location: On Site

* Candidate Must Be Local

* Local candidates preferred for onsite work in Lincoln, Nebraska (or must be willing to relocate).... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE))

DOAS HCM Training Specialist (774896)
Create date: 13-Aug-2025
Start Date :8/25/2025
End Date :04/30/2026

Submission Deadline :08/18/2025

Client Info : DOAS

Note:

* Agency Interview Type: Either Web Cam or In Person

* LOCAL CANDIDATES ONLY: DOAS participates in a hybrid work environment and telework is encouraged with some days in.... (This job is for - job Jobs in GA Atlanta Specialist - (in Atlanta, GA))

VSP - Help Desk Analyst 4 - (774531)
Create date: 08-Aug-2025
Start Date :9/1/2025
End Date :06/30/2026

Submission Deadline :08/13/2025

Client Info : VSP

Note:

* Please Submit your Best two candidates

* Candidates must be able to work on site.

* Local Candidates Strongly Preferred.

* Please submit your top .... (This job is for - job Jobs in VA NorthChesterfield Analyst - (in North Chesterfield, VA))
 
 Data Analysis job openings in WI
Jobs List

Business Intelligence Data Modeler III - WISCJP00017654
Create date: 05-Jun-2020
Start Date :06/15/2020
End Date :12/31/2020
Submission Deadline :Due to SCS 06/10/2020 by 8:00 am CT

Client Info : MILWCNTY-IMSD

Note :

* Duration: Initial Period: 06/15/2020 - 12/31/2020; Renewals/Extensions through 06/30/2021

Description :

The Busines.... (This job is for - Business Intelligence Jobs in WI Milwaukee Consultant - (in Milwaukee, WI))

BI Data Analyst - 37815
Create date: 23-Aug-2018
Candidate must be our own W2 Employee

We should take signed RTR form from candidate (Candidates RTR form should be only on the name of APEX Systems)

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens

Job Description :

Our great Fortune 500 client in Downtown Milwaukee has an immediate opening .... (This job is for - SSIS Jobs in WI Milwaukee Analyst - (in Milwaukee, WI))
(Modeler: Data Analysis, Erwin Data Modelling Tool, Database Design, Data Warehouse PLSQL Oracle 11g R2 Datab in Madison, WI)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us