ERwin datawarehouse Modeler (Jobs in Madison, WI)   Requirement id 158709 Job title Modeler Job location in Madison, WI Skills required Oracle PL/SQL, Metadata Development, ERwin, datawarehouse Open Date 21-Jul-2026 Close Date Job type Contract Duration 4 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Modeler: Oracle PL/SQL, Metadata Development, ERwin, datawarehouse Start Date : 08/24/2026 End Date : 12/31/2026 Deadline : 7/28/2026 4:00:00 PM Client Info :DCF Note: *Interview process: via Zoom/Teams. *Onsite, hybrid or remote: WI residency required. Must be WI resident or willing to relocate within 30 days of start date at own expense. *90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required. Description: This is a data modeler position who will be responsible for documenting several key business areas and concepts through the reverse engineering of models as well as the analysis and creation of key metadata points (definitions, etc).While this is being posted as a Business Intelligence Data Modeler, DCF is looking for someone with both application and data warehouse database modeling experience. The individual in this position will: •Develop conceptual, logical, and physical data models for DCF data architecture. Ensure that all relevant aspects of data model (granularity, etc.) are considered. Analyze the logical and physical database models and guarantee models are in accordance with standards. • Document and define key metadata around database architecture. • 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. • Design models optimized for both 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. • Assessment of data quality within database architecture. **The project is currently funded through 12/31/26 with the potential for an extension.”Experience with Human Services is desirable. Top skills: • Advanced knowledge of conceptual, logical and physical data modeling concepts; looking for BOTH APPLICATION and data warehouse database modeling experience (5+ years) • Experience in ERWIN data modeling software (5+ years) • Experience in reverse-engineering data structures and metadata development. (5+ years) • Advanced experience in Oracle PL/SQL (6+ years) Preferred skill: • Experience with human services INTERVIEW NOTES: PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid upon confirming the interview. Please see "DCF Realtime Photo Requirement & Instructions" document in the Attachments section of this posting for details. • Interviews will be set up shortly after the posting close date. • MUST provide three (3) business references for the interview. (One reference must be a supervisory level.) IMPORTANT NOTES: • Candidate MUST be physically located in the United States. International candidates/phone numbers will not be accepted. • Candidate must follow ALL DCF work rules • Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9:00 am – 3 pm (or CST hours as defined by the hiring manager) • Candidate will be required to provide their own equipment for this position (See job description for required specifications.) Project details: Position will be responsible for documenting key metadata on current production application databases. Position will work independently to assess and create key metadata documentation with guidance from senior Data Architect. While this is being posted as a Business In   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 158709 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), Oracle PL/SQL job openings in Madison, WI Jobs List .NET Web Developer III -113460-SP Create date: 17-Jan-2023 Start date : 01/30/2023 End Date : 06/30/2023 Submission deadline :1/19/2023 at 4:00PM CST Client Info :DWD Note : * Interview Process: Virtual * Duration of the Contract: 6/30/23 with potential for 2-year extension. * Onsite or Remote? 100% remote. Candidates not required to reside i.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Certified Microsoft .NET Web Developer III -113456-SP Create date: 17-Jan-2023 Start date : 01/30/2023 End Date : 06/30/2023 Submission deadline :1/19/2023 at 4:00PM CST Client Info :DWD Note : * Interview Process:45-minute online meeting with WebCam. * Duration of the Contract: 06/30/2023 with potential for 2-year extension. * Onsite or Remote? Remote. Resou.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Certified Microsoft .NET Web Developer III -113453-SP Create date: 17-Jan-2023 Start date : 01/30/2023 End Date : 06/30/2023 Submission deadline :1/19/2023 at 4:00PM CST Client Info :DWD Note : * Interview Process:45-minute online meeting with WebCam. * Duration of the Contract: 6/30/2023 with potential for 2-year extension. * Onsite or Remote? Remote. Resour.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Programmer - 3 - WISCJP00014067 Create date: 23-Jul-2018 Start Date : 08/06/2018 # End Date : 06/30/2019 Submission Dead Line : Due to SCS 07/30/2018 by 8:00 a.m. Client Info : DOA - Division of Enterprise Technology (DET) Description : We are seeking an enthusiastic.... (This job is for - ESBSSIS Jobs in WI Madison Consultant - (in Madison, WI)) Business Intelligence Technical Lead-2 - WISCJP00011805 Create date: 12-Oct-2017 Start Date : 11/13/2017 End Date : 06/30/2018 Submission Dead Line : 10/19/2017 Description : The Department of Children and Families Business Intelligence Section is seeking a highly qualified individual to fill the role of Data Warehouse Technica.... (This job is for - job Jobs in WI Madison TechLead - (in Madison, WI))    Oracle PL/SQL job openings in other states Jobs List Programmer Analyst - Sentence Computation - 151864 Create date: 26-Nov-2025 Start date :12/15/2025 End Date : 6/30/2027 Submission deadline :12/4/2025 3:00:00 PM Client Info : MSDOC Note: * Can work remote but will be required to report onsite on occasion to meet with user groups. Do NOT submit anyone unwilling to report onsite as needed. Description: job Jobs in MS Jackson Analyst - (in Jackson, MS)) Programmer Analyst - 151867 Create date: 26-Nov-2025 Start date : 12/15/2025 End Date : 6/30/2027 Submission deadline : 12/4/2025 3:00:00 PM Client Info : The Mississippi Department of Corrections (MDOC) Note: * Can work remote but will be required to report onsite on occasion to meet with user groups Description : W.... (This job is for - job Jobs in MS Jackson Analyst - (in Jackson, MS)) VDH Data Analyst 3 (756384) Create date: 05-Mar-2025 No of Submissions : 2 Start date : 03/17/2025 End Date : 06/30/2025 Submission deadline : 3/11/2025 Client Info : VDH Note: * Agency Interview Type : Web Cam Interview Only * Hybrid Description : Position will primarily be responsible for assisting w.... (This job is for - GCP Jobs in VA Richmond Analyst - (in Richmond, VA)) VDH Data Analyst 2 (756380) Create date: 03-Mar-2025 Hybrid No of Submissions : 2 Start date : 02/14/2025 End Date : 06/30/2025 Submission deadline : 03/13/2025 Client Info : VDH Note: * Agency Interview Type: Web Cam Interview Only Description : This individual will be primarily responsible for migrati.... (This job is for - Python Jobs in VA Richmond Analyst - (in Richmond, VA)) GA DPH - Programmer Analyst 3 (755917) Create date: 28-Jan-2025 Hybrid No of Submissions : 2 Start date : 02/17/2025 End Date : 06/30/2025 Submission deadline : 01/31/2025 Client Info : DPH Note: * Agency Interview Type: Either Web Cam or In Person * Oracle Apex Developer Position * Georgia DPH IT (SendSS) are req.... (This job is for - job Jobs in GA Atlanta Analyst - (in Atlanta, GA))    Oracle PL/SQL job openings in WI Jobs List Programmer 6 - 107353 - SP Create date: 26-Jul-2022 start date:8/15/2022 End date:At least 9 Months from projected start date submission deadline:8/2 at 4:00PM CST. client info : DHSS Note: * Interview Process: Virtual WebEx on camera with 3 interviewers * Duration of the Contract: Very strong possibility of lasting beyond 12 months wit.... (This job is for - HL7 Jobs in WI JeffersonCity Consultant - (in Jefferson City, WI)) (Modeler: Oracle PL/SQL, Metadata Development, ERwin, datawarehouse 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)