DB2 MS SQL Server ETL Data Modeler Data Warehousing Analyst (Jobs in Madison, WI)   Requirement id 6554 Job title Analyst Job location in Madison, WI Skills required DB2, MS SQL Server, SQL, ETL Data Modeler Data Warehousing Open Date 09-Sep-2011 Close Date Job type Not specified Duration 10 Months Compensation DOE Status requirement --- Job interview type Phone Screening Apply    Email Recruiter: coolsoft Job Description Analyst: DB2, MS SQL Server, SQL, ETL Data Modeler Data Warehousing Job Description: . Work with client to collect, document and verify data requirements for assigned data project tasks. . Provide guidance and serve as a resource in the collection of metadata elements to the Subject Matter Experts associated with each SoR. . Assist the Data Modelers and ETL Developers with specific questions about SoR data elements relating to the development of the logical and physical data models for the atomic data store of the data projects. . Use Excel spreadsheets and other tools to record the metadata that will be transferred to the metadata repository. This information will include, as an example, definitions, physical location and layout, ownership, application/system use, and relationships to other data elements. . Coordinate with other Data Analysts in the use and development of metadata collection processes, tools, guidelines, and best practices. . Assist the Project Managers with the documentation of process steps/tasks used, developed, or modified while collecting the Metadata. Experience: . 2 to 5 years experience in data solutions including a combination of data requirements gathering, data documentation and mapping, data delivery and data quality assurance. . 1 to 3 years experience within the property & casualty insurance business including multiple lines of business/product types, multiple functional areas and the complete insurance life cycle. . 1 to 2 years of business facing interaction related to data or systems requests Key Knowledge, Skills, and Abilities: . Demonstrated knowledge of managing data for applications. . Demonstrated knowledge or exposure to standard concepts, practices, and procedures within database management. . Demonstrated knowledge of at least one programming language and supporting tools and techniques. . Demonstrated knowledge of or exposure to a database platform (DB2, MS SQL Server) and SQL language constructs, stored procedures or similar techniques. . Experience in or substantial exposure to at least 3 of: requirements gathering, data design, ETL development, data modeling, or decision support systems. . Exposure to data warehousing design principles and associated data management and delivery requirements. . Experience in gathering database mapping requirements and creating mapping documents in detail using commercial data modeling software or similar techniques. . Competent in standard Microsoft tools and standards. . Demonstrated ability to communicate complex technical information to non-technical personnel both verbally and in writing. . Knowledge of and participation in project management. Preferred Qualifications . More than 3 years of Property & Casualty insurance experience in a complex environment. . Working knowledge of data requirements gathering and maintaining and publishing data definitions and business rules within a structured environment. . Demonstrated knowledge of data solutions and processes delivery to business units in support of company operations or specific business objectives. . Demonstrated knowledge in data warehousing methods and practices   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 6554 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), DB2 job openings in Madison, WI Jobs List Application Architect II - 145049 - Rebid Create date: 31-Jul-2025 Start date : 08/11/2025 End Date : 06/30/2026 Submission deadline : 8/4/2025 4:00:00 PM Client Info : ETF Note: * Interview Process: Teams * Duration of Contract: 6/30/2026 with potential for extension * Onsite or Remote? No WI residency required. Open to nationwide .... (This job is for - Cobol DB2 CICS Jobs in WI Madison Architect - (in Madison, WI)) COBOL Mainframe Programmer V - 143423 Create date: 05-Jun-2025 Start date : 07/01/2025 End Date : 06/30/2026 Submission deadline : 6/9/2025 4:00:00 PM Client Info : DWD Note: * Interview Process: Teams with camera on. PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid in order to accept an interview request..... (This job is for - DB2 VSAM CICS Jobs in WI Madison Consultant - (in Madison, WI)) .NET Web Developer III - 141553 Create date: 03-Apr-2025 Start date : 05/05/2025 End Date : 06/30/2025 Submission deadline : 4/10/2025 4:00:00 PM Client Info : DCF Note: * 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 R.... (This job is for - DB2 Jobs in WI Madison Developer - (in Madison, WI)) Software Engineer IV - Rebid - 132819 Create date: 15-Jul-2024 No of Submissions : 1 Start date : 07/29/2024 End Date : 06/30/2025 Submission deadline : 7/17 at 4:00PM CST. Client Info : DOT Note: * This is a Rebid. * Interview Process: Teams interview with Camera On * Duration: 6/30/25 with possible extensions *.... (This job is for - DB2 Jobs in WI Madison Engineer - (in Madison, WI)) .NET Web Developer III - 130699 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 - DB2 Jobs in WI Madison Developer - (in Madison, WI))    DB2 job openings in other states Jobs List GA DOL - Quality Analyst (Testing) (761315) Create date: 07-Apr-2025 Start date : 05/05/2025 End Date : 06/30/2025 Submission deadline : 04/10/2025 Client Info : GDOL Note: * Agency Interview Type : Either Web Cam or In Person * Onsite Description : MUST be local to Metro Atlanta Onsite REQUIRED The G.... (This job is for - DB2 Jira Jobs in GA Atlanta Analyst - (in Atlanta, GA)) SYSTEM SOFTWARE PROGRAMMER- PROJECT LEAD-11411-1 Create date: 09-Oct-2024 Candidate Submission Limit Per Supplier : 2 Start date : 11/3/2024 OR IMMEDIATELY (WHICHEVER IS SOONER) Submission deadline : 10/16/2024 Client Info : SC Department of Public Health (DPH) Note : Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? .... (This job is for - DB2 Sql Server 2000 ASPNet Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) NCDOT - Technical Specialist (747600) Create date: 19-Sep-2024 Hybrid No of Submissions : 2 start date :09/30/2024 End date :04/11/2025 submission deadline : 09/25/2024 client info : NCDOT Note: * Agency Interview Type: In Person Only Description : **The candidates .... (This job is for - DB2 Endevor Jobs in NC Raleigh Specialist - (in Raleigh, NC)) Programmer/Developer -63093 Create date: 25-Jul-2024 No of Submissions : 2 Start date :08/12/2024 End Date :06/30/2025 Submission deadline :08/02/2024 Client Info :TN DHS Note: * Position Location : Remote Description : Must have the following knowledge and experience: Generally on all of the follo.... (This job is for - DB2 Jobs in TN Nashville Developer - (in Nashville, TN)) System Specialist IV - B36991W107 Create date: 20-Jun-2024 No of Submissions : 1 Start date : 07/15/2024 End Date : 01/15/2025 Submission deadline : 06/25/2024 Client Info :ODOT Note: * Position Location : Remote Description : Computer systems specialists provide technical guidance for the development and trouble.... (This job is for - DB2 Cobol CICS Jobs in OR Salem Specialist - (in Salem, OR))    DB2 job openings in WI Jobs List Data Analyst Create date: 28-Apr-2011 candidates who are currently local (Chicago, Milwaukee, Madison) will be considered first. Description: Familiarity with DB2 and Data Stage. Performs data analysis to determine data quality issues. Develops functional design interfaces and data conversions. Creates plan for ETL and conversion tech design, build and implemen.... (This job is for - DB2 Datastage Jobs in WI Milwaukee Analyst - (in Milwaukee, WI)) Informatica Developer Create date: 21-Mar-2011 have experience working in a DB2 and Unix environment * 5+ years as an ETL programmer/analyst - Informatica Powercenter - Create mappings and maplets, Load Data in EDW or data mart, Change Data Capture, History, Archiving, workflows, Informatica repositories; Performance Tuning, UNIX administration of Informatica. * 2+ years a.... (This job is for - DB2 Unix Jobs in WI Milwaukee Developer - (in Milwaukee, WI)) Very Strong Core Java Create date: 07-Mar-2011 Very strong Core Java and OO design fundamentals. . Significant experience with parsing (XML(JaxB), Non-XML) using Java. . Experience working with MQ/ESB. . Experience with persistence layer development using ORM Hibernate (For databases like Oracle/DB2.). . Familiar with Weblogic (ideally Weblogic 10) application development. <.... (This job is for - Oracle DB2 Cobol Jobs in WI Milwaukee Developer - (in Milwaukee, WI)) HRMS Peoplesoft Developer Create date: 16-Feb-2011 HRMS Peoplesoft Developer: The need is for multiple Benefits related projects that are smaller in nature. 5-7 years of PeopleSoft experience with the following requirements: PeopleSoft HRMS v8.9 / PeopleTools v8.46 Payroll/Benefits concentration DB2 database Mainframe environment (familiar with mainframe JCL) Solid testing skills Good communication.... (This job is for - peoplesoft Hrms DB2 Jobs in WI Milwaukee Developer - (in Milwaukee, WI)) (Analyst: DB2, MS SQL Server, SQL, ETL Data Modeler Data Warehousing in Madison, WI)

Featured Jobs SDLC Analyst (Jobs in Richmond, Virginia) ADA Analyst (Jobs in Lansing, Michigan) Telecommunications LAN Engineer (Jobs in Madison, Wisconsin) COTS LAN TCP/IP CCNP Specialist (Jobs in Raleigh, North Carolina) MVVM Oracle Developer (Jobs in Madison, Wisconsin) - Analyst (Jobs in Raleigh, North Carolina) Help Desk Analyst (Jobs in Richmond, Virginia) SOP Testing Analyst (Jobs in Madison, Wisconsin) Workflow Healthcare Analyst (Jobs in Raleigh, North Carolina) Business Analyst Graphical Manager (Jobs in Columbia, South Carolina)