Databases IBES Oracle ODI SQL Tuning ELT Data Modeling Implementation Data Warehous   Requirement id 60001 Job title Architect Job location in Boise, ID Skills required Programming Languages, Databases, Operating Systems, IBES Oracle ODI SQL Tuning ELT Data Mode Open Date 27-Mar-2017 Close Date Job type Not specified Duration 18 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Programming Languages, Databases, Operating Systems, IBES Oracle ODI SQL Tuning ELT Data Mode Start Date :04/17/2017 End Date :10/16/2018 Submission Deadline :04/03/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: 60001 while calling.   Other jobs in ID: Boise (11), Programming Languages job openings in Boise, ID Jobs List SDT1 - Service Desk Technician - PSO210921 Create date: 21-Sep-2021 Start Date :10/4/2021 End Date :07/01/2022 Submission Deadline :09/28/2021 Client Info : Idaho State Liquor Division Description : Temporary Service Desk Technician – this position will provide standard and non-standard technical support to end-users in response to specific req.... (This job is for - Database Admin Jobs in ID Boise Consultant - (in Boise, ID)) DBA2, NA2, And WD2 - IDJC-IJOS-2022 Create date: 18-May-2021 Start Date :07/12/2021 End Date :6/30/2023 Submission Deadline :06/04/2021 Client Info : Idaho Dept. of Juvenile Corrections Note : * please have final questions submitted by Tuesday, June 1st to allow for adequate response time. Description : Agency Proj.... (This job is for - JavaScriptAngularJS Jobs in ID Boise Consultant - (in Boise, ID)) Business Process Engineer - 270-101018-157 Create date: 10-Oct-2018 Start Date :11/5/2018 End Date :11/4/2019 Submission Deadline :10/18/2018 Description : The Division of Family and Community Services (FACS) is commencing the first year of a multi-year project to modernize the Divisions Child Welfare Information System. That system, known as iCARE, is us.... (This job is for - Databases Jobs in ID Boise Engineer - (in Boise, ID)) Software Engineer 2 - 270-102317-126 Create date: 23-Oct-2017 Start Date : 11/13/2017 End Date : 05/12/2019 Submission Dead Line : 11/03/2017 Description : Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) Software Engineer 2 (SE2) The software engineer is responsible for analysis, .... (This job is for - job Jobs in ID Boise Engineer - (in Boise, ID)) Business Process Analyst - 17-10 Create date: 18-Aug-2017 Start Date : 09/01/2017 End Date : 08/31/2018 Submission Dead Line : 08/25/2017 Description : Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) IDOL needs 1 experienced Business Process Analyst to work with the iUS Consortium t.... (This job is for - Business AnalystDatabases Jobs in ID Boise Analyst - (in Boise, ID))    Programming Languages job openings in other states Jobs List Application Architect II -134675 Create date: 03-Sep-2024 No of Submissions : 2 start date : 10/14/2024 End date : 06/30/2025 submission deadline : 9/10/2024 at 4PM CST. client info : DOC Note: * Interview Process: Microsoft teams. Video and Audio on. * Working location: Candidate must be a CURRENT WI resident. No relocation a.... (This job is for - job Jobs in WI Madison Architect - (in Madison, WI)) Application Architect III - 130746 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. MicrosoftNET Jobs in WI Madison Architect - (in Madison, WI)) Application Architect II - 130319 Create date: 08-May-2024 No of Submissions : 2 Start date : 06/03/2024 End date : 06/30/2024 Submission deadline : 5/15/2024 at 4PM CST. Client info : DOC Note : * Interview Process: Microsoft teams. Video and Audio on. * Working location: Candidate must be a CURRENT WI resident. No relocation a.... (This job is for - JavaScript Jobs in WI Madison Architect - (in Madison, WI)) NCDPI - Developer/Programmer- Senior (729402) Create date: 13-Mar-2024 Onsite start date :03/04/2024 End date :08/02/2024 submission deadline : 03/19/2024 client info : NCDPI Description : Full Stack .NET Developer to help Migrate legacy Applications. You will work on a small team to migrate lega.... (This job is for - ADONET Jobs in NC Raleigh Developer - (in Raleigh, NC)) SOS Site Reliability Engineer (652518) Create date: 12-May-2021 Start Date:06/07/2021 End Date:05/13/2022 Submission Deadline:05/17/2021 Client Info:SOS *Note: Agency Interview Type: Web Cam Interview Only Description: AGENCY: Secretary of State JOB DUTIES: • Design/integrate systems to assist in managing infrastructure and .... (This job is for - Java Jobs in GA Atlanta Engineer - (in Atlanta, GA))     (Architect: Programming Languages, Databases, Operating Systems, IBES Oracle ODI SQL Tuning ELT Data Mode 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)