ERwin Data Modeling SQL Scripting Data Analysis Kimball Data Warehouse Methodologie   Requirement id 146508 Job title Consultant Job location in Madison, WI Skills required ERwin, Data Warehouse, Oracle PL/SQL, Data Modeling SQL Scripting Data Analysi Open Date 26-Mar-2024 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: ERwin, Data Warehouse, Oracle PL/SQL, Data Modeling SQL Scripting Data Analysi Start date : 05/06/2024 End date : 06/30/2024 Submission deadline : Monday, April 1st at 4:00PM CST. Client info : DCF Note : * Interview Process: Teams with camera on. 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. * INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • 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 Wisconsin for the entire length of the contract. NO REMOTE WORK CAN BE COMPLETED OUTSIDE OF WISCONSIN. • 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.) * Duration: 6/30/2024, with the potential to extend for an additional term(s) * Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense. This position is currently remote (however candidate must reside in Wisconsin for the length of the contract). However, position status is subject to change. 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. • Partner with Enterprise Architecture team to assess and obtain the approval for the design. • Work with DBAs to coordinate instantiation of tables and other relevant database objects. • 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. • Understand and balance business requirements and user expectations. Experience with Human Services business intelligence is desirable.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 146508 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), ERwin job openings in Madison, WI Jobs List Business Intel Data Modeler III -125634 Create date: 02-Jan-2024 start date : 02/05/2024 End date : 06/30/2024 submission deadline : 1/9/24 at 4:00PM CST. client info : DOC Note: * Interview Process: Virtual, 45 minutes, voice and video via Microsoft Teams * Duration: 6/30/2024 with possible extensions * Onsite or Remote? Candidate MUST .... (This job is for - ERwin Jobs in WI Madison Modeler - (in Madison, WI)) Business Intel Data Modeler III - 118325 - SP Create date: 24-May-2023 start date : 07/01/2023 End date : 06/30/2024 submission deadline : 5/26/23 at 4:00PM CST. client info : DOC Note : * Interview Process: Virtual, 45 minutes, voice and video via Microsoft Teams * Duration: 6/30/2024 with possible extensions * Onsite or Remote? 100% re.... (This job is for - ERwin Jobs in WI Madison Consultant - (in Madison, WI)) Business Intel Data Modeler III -118180-SP Create date: 17-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline :May 18th at 4:00PM CST. Client Info :DCF Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortly af.... (This job is for - Data Warehousing ERwin Jobs in WI Madison Developer - (in Madison, WI)) Data Modeler - 45857 Create date: 11-Apr-2019 Job Description : Data Modeler Requirements Communication and Requirements gathering Expertise in translating functional business requirements to technical requirements and design. Strong communication skills with the ability to interact with stakeholders at all levels. Ability to lead re.... (This job is for - SDLC ERwin Jobs in WI Madison Consultant - (in Madison, WI)) Data Warehouse Analyst-3 - WISCJP00014375 Create date: 30-Jan-2019 Start Date :03/4/2019 End Date :06/30/2019 Submission Deadline :2/13/2019 Client Info :Department of Workforce Development (DWD) Description : This request is for advanced data warehouse business analysis, database design, ETL design, and data warehouse support. Best-qualified.... (This job is for - ERwin Jobs in WI Madison Analyst - (in Madison, WI))    ERwin job openings in other states Jobs List Software Architect - 3625 Create date: 08-Apr-2020 Note: * Please be advised responses are due no later than 4/8/20. Responsibilities Are you a tech & IT geek? We have a 24-month project with our client in Brooklyn, NY that requires a Software Architect, Expert The Software Architect partners with end users/client personnel to translate business needs int.... (This job is for - ERwin Jobs in MT Brooklyn Architect - (in Brooklyn, MT)) Software Architect - 3625 Create date: 27-Mar-2020 Note: * Please be advised responses are due no later than 4/8/20. Responsibilities Are you a tech & IT geek? We have a 24-month project with our client in Brooklyn, NY that requires a Software Architect, Expert The Software Architect partners with end users/client personnel to translate business needs int.... (This job is for - ERwin Jobs in NY Brooklyn Architect - (in Brooklyn, NY)) Data Modeler - 59262 Create date: 10-Feb-2020 Job Description : Provides the highest technical expertise for the planning, analysis, design, implementation, and control of the organizations data. Handles and leads the most complex or critical data management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database de.... (This job is for - ERwin Jobs in MO StLouis Modeler - (in St Louis, MO)) Legacy Systems Specialist I Create date: 07-Jan-2020 Start Date :01/20/2020 End Date :09/30/2020 Submission Deadline :01/09/2020 Client Info :OIT Description : The Chief Technology Office division exists to satisfy the business needs of our customers through the development of partnerships, consulting, planning, applicat.... (This job is for - Data Architect ERwin Jobs in CO Denver Specialist - (in Denver, CO)) IT Data ModelerA - 56943 Create date: 18-Dec-2019 Note: * Candidate must be our W2 Employee. * We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. * Candidates RTR form should be only on the name of APEX Systems. * BACKFILL for CURRENT CE - EXCLUSIVE TO Client. Client Info : Wellmark Blue Cross Blue Shield of Iowa PowerDesigner ERwin Jobs in IA DesMoines Modeler - (in Des Moines, IA))    ERwin job openings in WI Jobs List Data Modeler Create date: 07-Sep-2011 [Note : Length of Contract: Until 2/29/2012] [Note : Start Date: 9/19/2011] Responsibilities: The data modeler works closely with the Data Architects and project teams to develop the logical data model representing project data requirements (including data definitions) and for custom solutions, also dev.... (This job is for - ERwin SDLC Data Modeler Jobs in WI Milwaukee Modeler - (in Milwaukee, WI)) (Consultant: ERwin, Data Warehouse, Oracle PL/SQL, Data Modeling SQL Scripting Data Analysi in Madison, WI)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)