Mentoring Data Migration Star Schemas Snowflake Data Integrity Excellent Oral And W   Requirement id 108631 Job title Architect Job location in Albany, NY Skills required Mentoring, Database Architecture, Data Modeling, Data Migration Star Schemas Snowflake Da Open Date 27-Jul-2020 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Phone Screen and Face to Face interview    Email Recruiter: coolsoft Job Description Architect: Mentoring, Database Architecture, Data Modeling, Data Migration Star Schemas Snowflake Da Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 8/5/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 12-month project with our client in Albany, NY that requires a Database Architect, Expert Support the continued development and approval processes of business solutions in response to critical agency requirements for the development efforts for the NYWIC data mart. Day-to-Day Tasks include, but not limited to: Work with SMEs, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions. Convert business processes, domain specific knowledge, and information needs into a conceptual model. Convert conceptual models into logical models with detailed descriptions of entities and dimensions. Develop and maintain fully defined conceptual, logical, and physical dimensional data models to ensure the information models are capable of meeting end user and developer needs. Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. Model aggregation layers and specific star schemas as subject areas within a logical and physical model Understand and meet referential data integrity requirements Document decisions made in meetings and alternative solutions discussed. Mandatory Qualifications: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. 84 + Months-Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. Preferred Qualifications: 85 Months Experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. in a data warehouse/business intelligence environment 85 Months Experience in a data modeling tool (e.g., ErWin). 85 Months Experience in relational data management disciplines and design and development experience using Oracle technologies. 72 Months Experience utilizing SQL programming for data analysis purposes in a data warehouse/business intelligence environment 72 Months Experience with business intelligence tools (e.g., OBIEE 11G) involving data analytics. 60 Months Experience with designing, developing, and creating applications and health care business intelligence reporting solutions. 48 Months Demonstrated analytics and communications experience (e.g., math, statistics, quantitative methods, and writing). 24 Months Experience with reviewing the data modeling of others for compliance and accepted standards of development. Bachelors degree in business intelligence, information science, computer science, or mathematics. Languages Must have English Native or bilingual proficiency Additional vendor information Candidates need to meet 60% of the Preferred Qualifications to qualify for the position.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 108631 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2), Mentoring job openings in Albany, NY Jobs List Expert Tester - 5510 Create date: 29-Sep-2021 Description: Day-to-Day Tasks include, but not limited to: Planning, designing, developing and executing test plans based on business requirements and functional specifications. Coordinating, tracking and analyzing testing activities. Recording and scripting automated functional tests. Mentoring .... (This job is for - Planning Mentoring Analyzing Jobs in NY Albany Tester - (in Albany, NY)) Software Architect - 4244 Create date: 22-Oct-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 11/2/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 30-month project with our client in Albany, NY that requires a Software Arch.... (This job is for - Monitoring Mentoring Jobs in NY Albany Architect - (in Albany, NY)) Business Analyst - 4236 Create date: 20-Oct-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 10/31/20. Responsibilities TVT is a NYS HBITS Prime Vendor! Are you Tech Terrific, an innovative thinker, and have great interpersonal skills? We have a 12-month project with our.... (This job is for - Business Analyst Mentoring Jobs in NY Albany Analyst - (in Albany, NY)) QA Tester - 4212 Create date: 08-Oct-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 10/21/20. Responsibilities Are you Tech Terrific, an innovative thinker, and have great interpersonal skills? We have a 30-month project with our client in Albany, NY that requir.... (This job is for - Mentoring Jobs in NY Albany Tester - (in Albany, NY)) Systems Administrator - 4192 Create date: 05-Oct-2020 Responsibilities Are you a Tech junkie or IT geek? We have a 30-month project with our client in Albany, NY that requires a Systems Administrator, Expert Expert-level Systems Administrator with extensive hardware and software management experience to serve as the contract administrative lead for the NYS Board of Elections infr.... (This job is for - Mentoring Security Jobs in NY Albany Administrator - (in Albany, NY))    Mentoring job openings in other states Jobs List IA-OCIO-TS4-Technical Lead (703889) Create date: 23-Feb-2023 Start date : 03/13/2023 End Date : 02/11/2024 Submission deadline : 2/28/2023 Client Info : OCIO: Office of the Chief Information Officer Note: * Hybrid Description : --------------------------------------------- The Office of the Chief Information Officer (OCIO) at the State o.... (This job is for - Mentoring Jobs in IA DesMoines Consultant - (in Des Moines, IA)) CTDS UX Research Lead (Phase 2) Create date: 25-Jun-2021 Description: Experiences Required for This Role UX Research Management – At least 5 years of experience and use cases with the following: UX research team management, recruiting, and hiring Leading and mentoring UX researchers to support career development Demonstrating and teaching others how .... (This job is for - UX Mentoring Jobs in CT Hartford Consultant - (in Hartford, CT)) BPM Consultant - 70787 Create date: 12-Jan-2021 Note: This is a markup account, please list consultants W2 hourly pay rate in the comments section when submitting. Upon offer, it is required to show consultants W2 take home pay in the Exh A Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description: Architect Mentoring Integration Jobs in NC Charlotte Consultant - (in Charlotte, NC)) Storage Engineer - Mid - 69348 Create date: 12-Nov-2020 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : The main function Storage Engineer is to help in Storage allocations, troubleshooting BAU tasks, address hardware issues and proactively monitor storage capacity availability and required take necessar.... (This job is for - Mentoring Jobs in VA AShburn Engineer - (in Ashburn, VA)) NC FAST Test Automation Agile Team Manager (635644) Create date: 28-Sep-2020 Start Date :09/28/2020 End Date :09/27/2021 Submission Deadline :10/02/2020 Client Info : NCDHHS-NCFAST Note: * Agency Interview Type:Webcam Interview Only Description: It requires the services of an Test Automation Agile Team Manager to assist with management of automation.... (This job is for - Mentoring SAFe Jobs in NC Durham Manager - (in Durham, NC))    Mentoring job openings in NY Jobs List Expert Database Administrator - 5347 Create date: 09-Aug-2021 Description: Day-to-Day Tasks include, but not limited to: Installing, configuring, and upgrading Oracle GoldenGate software. Building replication from Sybase databases to Oracle databases. Monitoring the performance and availability of the replication environment. Starting and stopping replicati.... (This job is for - Oracle Mentoring Configuring Jobs in NY Menands Administrator - (in Menands, NY)) Business Analyst - 4294 Create date: 02-Nov-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 11/15/20. Responsibilities Are you Tech Terrific, an innovative thinker, and have great interpersonal skills? We have a 24-month project with our client in Menands, NY.... (This job is for - Business Analyst Mentoring Documentation Jobs in NY Menands Analyst - (in Menands, NY)) Oracle Database Architect - 4290 Create date: 02-Nov-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 11/14/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Menands, NY that requires an Oracle Dat.... (This job is for - Mentoring Analysis Jobs in NY Menands Architect - (in Menands, NY)) Database Architect - 4112 Create date: 08-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/19/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Albany, NY that requires a Database Arch.... (This job is for - Mentoring Architect Jobs in NY Menands Architect - (in Menands, NY)) SOA Architect - 4057 Create date: 19-Aug-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 8/30/20. Requirements Years of work experience: 7 year(s) Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 9-mon.... (This job is for - Mentoring Jobs in NY Menands Architect - (in Menands, NY)) (Architect: Mentoring, Database Architecture, Data Modeling, Data Migration Star Schemas Snowflake Da in Albany, NY)

Featured Jobs Z/Os Specialist (Jobs in Raleigh, North Carolina) Problem Analyst (Jobs in Chelsea, Massachusetts) SQL PostgreSQL Analyst (Jobs in Atlanta, Georgia) PEOPLESOFT Customer Analyst (Jobs in Atlanta, Georgia) LMS MS Developer (Jobs in Durham, North Carolina) Email Supervision Administrator (Jobs in Nashville, Tennessee) Troubleshooting Engineer (Jobs in Des Moines, Iowa) Consultant (Jobs in Murfreesboro, Tennessee) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Application Developer (Jobs in Richmond, Virginia)