Data Warehouse Data Models ELT Reporting Communication Skills Database Admin DBA D   Requirement id 58861 Job title Architect Job location in Boise, ID Skills required Oracle ODI, SQL Server Databases, Implementing Application, Data Warehouse Data Models ELT Reporting Open Date 24-Jan-2017 Close Date Job type Not specified Duration 18 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Oracle ODI, SQL Server Databases, Implementing Application, Data Warehouse Data Models ELT Reporting Start Date :02/27/2017 End Date :08/25/2018 Submission Deadline :02/10/2017 Client Info :Idaho Department of Health & Welfare Description : Works with the senior IT architecture team to design, implement and deploy a functional, maintainable/sustainable and scalable enterprise data warehouse. Must be able to work with a team and also independently to achieve the highest quality enterprise data warehouse. Data models and ETL must address data quality best practices and rule sets that promote data integrity. The data warehouse must be in synch with various data systems to provide reporting and data usage that is auditable, defensible and repeatable. Must have the ability to understand the reporting needs of various divisions within the agency and be able to provide a complete solution that meets the requirements of Idahos Department of Health & Welfare. Agency Expected Deliverables Six Plus years of experience Four year college degree in a technical field of study • Designs and implements data warehouse, data marts and data stores, while ensuring high level of data availability. • Designs and implements processes that meets the agreed upon performance metrics • Employs industry standard best practices in data warehouse design and implementation • Design and implement data structures and commonly used data business intelligence tools for data analysis • May evaluate database warehouse management systems and select infrastructure components such as software, hardware, database warehouse management systems and networking capabilities. • Works closing with the database architects and database administrators to ensure extract functions meet the needs of the end users • Works closely with the application development teams to ensure capture of all new data elements and process changes as they are made at the application level Specific Skills Required (Programming languages, databases, operating systems, etc.) Must have working knowledge of a modern welfare eligibility case management system and hands-on experience with IDHW Division of Welfares automated eligibility system, IBES, and related components. • Experience with both Oracle and SQL Server databases. • Extensive experience designing, implementing and deploying into production an enterprise data warehouse • Experience understanding data users and data consumers, both system consumers as well as user groups • Experience complying with governmental agency and federal security reporting policies and best practices • Experience designing security at both the schema level and the accessibility level in conjunction with the DBAs • Extensive experience collaborating with the application architects, functional architects, infrastructure architects and database architects • Extensive experience defining data standards and creating data models • Experience in designing and implementing data warehouse for optimal performance and low process overhead • Extensive experience tuning ELT and reporting processes • Experience working with government agencies is required. • Experience in both strategic design of data warehouse & the ability to implement the strategy. • Excellent communication skills and hands on experience working with the database & warehouse teams.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 58861 while calling.   Other jobs in ID: Boise (11), Oracle ODI job openings in Boise, ID Jobs List US-IT Business Consultant V-J-11-189-984 Create date: 15-Dec-2016 Start Date : 1/3/2017 End Date : 11/30/2017 Submission Dead Line : 12/21/2016 Description : Capability Definition: Applies experience and subject matter knowledge in the Reporting domain to solve common and complex business issues within established guidelines and recommends appropriate alternat.... (This job is for - job Jobs in ID BOISE Consultant - (in Boise, ID))    Oracle ODI job openings in other states Jobs List 216961 - 136333 SUPPORT RENEWAL FOR ORACLE X8 E - NSPO Create date: 20-Sep-2024 Bid URL : https://www.rampla.org/s/opportunity-details?id=006Ql00000DbkM9IAJ Note : online Submission Submission Deadline : 10/2/2024, 05:00 PM EDT Start Date : 10/14/2024 End Date : 10/14/2025 Client : City of Los Angeles Description : THIS RAMP ID REFERS TO A LOS ANGEL.... (This job is for - Support Renewal Jobs in CA LosAngeles Consultant - (in Los Angeles, CA)) Certified Microsoft .NET Web Developer III - 126747 Create date: 31-Jan-2024 Start date : 03/04/2024 End date : 06/30/2024 Submission deadline : 02/07/2024 at 4:00PM CST. Client info : DWD Note : * Interview Process: Teams with camera on. PLEASE NOTE: Realtime screenshot photo of candidate MUST be uploaded to candidates bid upon confirming the interview. Please see .... (This job is for - DB2 Jobs in WI Madison Developer - (in Madison, WI)) NC FAST Reports Developer (723779) Create date: 22-Nov-2023 Onsite Start date :12/01/2023 End Date : 11/30/2024 Submission deadline : 11/30/2023 Client Info : NCDHHS-NCFAST Description : ------------------------------------------------------ The NC Department of Health and Human Services seeks a contractor to assist with the design and impleme.... (This job is for - OEM Jobs in NC Durham Developer - (in Durham, NC)) VSP Oracle E-Business Suite (723905) Create date: 06-Nov-2023 Onsite Start date :12/04/2023 End Date :04/29/2024 Submission deadline : 11/8/2023 Client Info : VSP Description : ------------------------------------------------------ *local candidates strongly preferred *manager will ONLY conduct onsite interviews, NO exceptions O.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) DOA - PeopleSoft DBA (714073) Create date: 28-Jun-2023 Hybrid Start date :07/17/2023 End Date :06/30/2024 Submission deadline :6/30/2023 Client Info :DOA Description : ------------------------------------------------------ PeopleSoft DBA Administrator Local candidates only; ON SITE work Tues, Wed, Thurs each week is REQUI.... (This job is for - job Jobs in VA Richmond Consultant - (in Richmond, VA))     (Architect: Oracle ODI, SQL Server Databases, Implementing Application, Data Warehouse Data Models ELT Reporting in Boise, ID)

Featured Jobs Windows Engineer (Jobs in Clifton Forge, Virginia) Stakeholders AGILE Manager (Jobs in Richmond, Virginia) JavaScript Power Consultant (Jobs in Richmond, Virginia) Cybersecurity IT Analyst (Jobs in Richmond, Virginia) Peripherals IT Consultant (Jobs in Petersburg, Virginia) Filing Consultant (Jobs in Winchester, Tennessee) MS Office Consultant (Jobs in COLUMBIA, South Carolina) - - Consultant (Jobs in Bismarck, North Dakota) Scheduling Written Consultant (Jobs in Murfreesboro, Tennessee) GPO Brocade Manager (Jobs in COLUMBIA, South Carolina)