Microsoft SQL Server 2012 Data Modeling Microsoft Office 2010 datawarehouse Data A   Requirement id 18330 Job title Architect Job location in Madison, WI Skills required Data Warehouse Design, Oracle PL/SQL, Microsoft SQL Server 2008, Microsoft SQL Server 2012 Data Modeling Open Date 18-Apr-2014 Close Date Job type Not specified Duration 1 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: Data Warehouse Design, Oracle PL/SQL, Microsoft SQL Server 2008, Microsoft SQL Server 2012 Data Modeling [ NOTE : START DATE : 05-05-2014 END DATE : 06-30-2014 ] [ NOTE : SUBMISSION DEADLINE : 04-25-2014 on Friday 8:00 AM ] Description: DOT is looking for a candidate that can help us re-build our Data Warehouse & BI practice by implementing best practice design, architecture, and development methodologies. The candidate will be responsible for design and maintenance, including data design, database architecture, metadata, ETL design, development, testing, and implementation of data warehouse initiatives. Provide an architectural framework for the data warehouse development, maintenance and enhancement efforts. 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. Monitor technological advancements to ensure that solutions are continuously improved, supported, and aligned with industry and company standards. Conducts highly complex work critical to the organization. Works with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Works with moderate supervision with latitude for independent judgment. Assist less experienced peers by providing technical guidance. Typically requires 5 - 7 years experience or equivalent education. Ideal candidate will have skills and experience in the following areas: • Strong skills in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite • Excellent skills in the architecture of data warehouse and data integration strategies and solutions • Demonstrated skills in establishing data warehouse best practice standards • Excellent knowledge and programming in relational data base technologies; e.g. Oracle, DB2, SQL Server • Strong skills working with relational and dimensional data models • Strong skills working with slowly changing dimensions • Strong data management and data analysis using SQL • Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff • Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support) • Demonstrated knowledge and skills in requirements gathering • Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team • Skills in navigating a large organization in order to accomplish results • Ability to initiate and follow through on complex projects of both short and long term duration • Excellent organizational and time management skills. • Excellent analytical and problem solving skills • Ability to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed • Proficiency with MS Office suite, MS Visio, and MS Outlook • Ability to complete projects of substantial depth and complexity, and work with customers at many levels in the organization Required Skills: * Data Warehouse Design * Oracle PL/SQL * Microsoft SQL Server 2008 * Microsoft SQL Server 2012 * Data Modeling * Microsoft Office 2010   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 18330 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 Warehouse Design job openings in Madison, WI Jobs List Data Warehouse Analyst III - 42886 Create date: 30-Jan-2019 Job Description : Database design, ETL design, and data warehouse support. Best-qualified candidates will have strong experience using Oracle, Erwin and Business Objects in a business intelligence/data warehouse environment. This position will do the following: work with advanced-level accountants and other business customers to understa.... (This job is for - ETLERwin Jobs in WI Madison Analyst - (in Madison, WI)) Sr. Internal Business Systems Analyst Create date: 20-Apr-2015 [NOTE : START DATE: 05-04-2015 END DATE : 06-30-2015 NOTE : SUBMISSION DEADLINE : 04-24-2015 8:00 AM on Friday] Job Description: Evaluate the internal technical needs of an organization and recommend solutions. Serve as liaison between internal departments and development team. Define the system.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI)) Data Warehouse Analyst Create date: 12-May-2014 [ NOTE : START DATE : 05-27-2014 END DATE : 06-30-2014 ] [NOTE : SUBMISSION DEADLINE : 05-14-2014 on Wednesday 8:00 AM ] Description: Provide support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into the databases. Analy.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))    Data Warehouse Design job openings in other states Jobs List Technical Specialist 3/TS3 - 68155 Create date: 14-Jan-2020 Start Date : 02/03/2020 End Date : 06/30/2020 Submission Dead Line : Tuesday 1/21/2020 at 10:00am EST Client Info : EDU Note: * Will close to submissions: Tuesday 1/21/2020 at 10:00am EST * Interviews: Phone will be considered for out of State candidates * You.... (This job is for - Tableau Jobs in OH Columbus Specialist - (in Columbus, OH)) ITS63-Web Software Developer-SP Create date: 21-Nov-2016 Client Name:Department of Housing and Community Development Submission Deadline:11/25/2016 1:00:00 PM EST Start Date:12/2/2016 End Date:06/20/2017 Description: The Department of Housing and Community Development would like to modify and enhance a currently deployed web based .NET software application to include new r.... (This job is for - SQL Jobs in MA Boston Developer - (in Boston, MA)) Data Warehouse Analysis And Design - SPO Create date: 30-Oct-2014 [ NOTE : SUBMISSION DEADLINE - 11/18/2014, 2:00 PM CT ] [ NOTE : PROJECT START DATE - 12/1/2014 END DATE - 6/30/2015 ] [Client : Office of the Secretary of State, State of Illinois] *Description: *The Office of the Secretary of State (SOS) is seeking candidates to perform detailed analys.... (This job is for - job Jobs in IL Springfield Analyst - (in Springfield, IL)) BI Architect /Sr.SSAS Developer - J-10-904-237 Create date: 10-Jun-2014 ETL Architect /Sr.SSAS Developers Responsibilities: The primary role is to provide technical analysis, design, development and implement Data mart solution utilizing MS SQL Server 2012 and SSAS. Responsibilities: Analyze Business Requirements and translate those into a scalable Datamart design by utilizing best DW design .... (This job is for - SSAS Jobs in FL FORTLAUDERDALE Developer - (in Fort Lauderdale, FL)) Data Warehouse Specialist- 357655 Create date: 07-Mar-2014 Description: The Data Warehouse Specialist will be primarily responsible for designing and implementing data warehouse and relational database applications also to include business intelligence development and administration. * Interviews customer and gathers requirements * Provides Data profiling, data clean.... (This job is for - job Jobs in AR LittleRock Specialist - (in Little Rock, AR))     (Architect: Data Warehouse Design, Oracle PL/SQL, Microsoft SQL Server 2008, Microsoft SQL Server 2012 Data Modeling in Madison, WI)

Featured Jobs Process Consultant (Jobs in Denver, Colorado) Agile Stakeholders Manager (Jobs in Glen Allen, Virginia) Data Warehousing Manager (Jobs in Madison, Wisconsin) Help Desk SCSM Manager (Jobs in Columbia, South Carolina) IT Project Management Risk Consultant (Jobs in Lansing, Michigan) Node.Js Engineer (Jobs in Durham, North Carolina) Spark Azure Engineer (Jobs in Richmond, Virginia) Strong Manager (Jobs in Raleigh, North Carolina) SQL Consultant (Jobs in Raleigh, North Carolina) SHARE Analyst (Jobs in PETERSBURG, Virginia)