Communication Decision Making Documentation Snowflake High Level Design Documents W   Requirement id 110178 Job title Architect Job location in Menands, NY Skills required Data Warehouse Architecture, Collaborative Environment, Communication, Decision Making Documentation Snowflake Open Date 18-Sep-2020 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type Phone Screening    Email Recruiter: coolsoft Job Description Architect: Data Warehouse Architecture, Collaborative Environment, Communication, Decision Making Documentation Snowflake Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/30/20. Responsibilities TVT is a NYS HBITS Prime Vendor! Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Menands, NY that requires a Senior Data Warehouse Architect Support the development of business solutions in response to critical agency requirements for the Enterprise Information Management Project. 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 Meet referential data integrity requirements Document decisions made in meetings and alternative solutions discussed. Mandatory Qualifications: Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system. 60-84 months-Candidate able to work independently, without assistance and provides guidance to others. May have an advanced education. Preferred Qualifications: 66 Months experience with developing and maintaining logical and physical dimensional data models including star schema and snowflake schema. 66 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 66 Months experience in relational data management disciplines and design and development experience using Oracle technologies. 66 Months experience with SQL programming. 60 Months experience working with business intelligence tools (e.g., OBIEE 11G). 60 Months experience working with ETL tools (e.g. Informatica). 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions. 48 Months experience working with HIPAA requirements or similar standards and Accessibility Standards. 48 Months experience with reviewing the data modeling of others for compliance and accepted standards of development. 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: 110178 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), Data Warehouse Architecture job openings in Menands, NY Jobs List Senior Data Warehouse Architect - 4156 Create date: 18-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/30/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 a Senior Data .... (This job is for - ETL Jobs in NY Menands Architect - (in Menands, NY))    Data Warehouse Architecture job openings in other states Jobs List Chesterfield County Data Warehouse Architect 4 (743061) Create date: 24-Jul-2024 Hybrid No of Submissions : 3 start date :08/05/2024 End date :07/31/2025 submission deadline : 7/29/2024 client info : Chesterfield County Note: * Agency Interview Type: Both Web Cam and In Person Interview Descript.... (This job is for - job Jobs in VA Chesterfield Architect - (in Chesterfield, VA)) ELECT - Data Warehouse-BI Developer 3 - REMOTE (700810) Create date: 25-Jan-2023 start date : 01/03/2023 End date : 12/29/2023 submission deadline : 1/30/2023 client info : ELECT Note : * REMOTE * Web Cam Interview Only Description : Responsible for designing, developing, and maintaining data .... (This job is for - Testing Jobs in VA Richmond Developer - (in Richmond, VA)) ITS63-EHS-FY20-Data Warehouse Architect-004-DW-REPOST -SP Create date: 27-Jan-2020 Note: Email Submission Note: Interview requirements: _MUST BE IN PERSON and person must be local Note: This positon May be filled PRIOR TO CLOSE DATE Note: Maximum number of resumes per ITS63 Vendors: __2 Note: Resumes must be emailed to: EOHHS ITContractorResumes@state.ma.us Submission Deadline: 1/30/2020 Sta.... (This job is for - job Jobs in MA Quincy Architect - (in Quincy, MA)) Architect - 53570 Create date: 20-Jun-2018 Description: Data Warehouse Architect The Data Warehouse Architect is responsible for the architectural design, development and maintenance of complex, enterprise-wide data warehousing systems. Provides leadership and direction including long and short-range planning of data warehouse architecture, ETL processes, and data mode.... (This job is for - Architect Jobs in GA Atlanta Architect - (in Atlanta, GA)) K2380 Data Architecture Consulting Services -SPO Create date: 19-Jun-2017 Submission Deadline : 7/6/2017 2.00PM Client : Washington State Health Care Authority (WSHCA) Description : The Washington State Health Care Authority, hereafter called “HCA,” is initiating this Request for Proposals (RFP) to solicit proposals from qualified vendors to supply IT consulting services to support HCAs .... (This job is for - Medicaid Jobs in WA Olympia Architect - (in Olympia, WA))    Data Warehouse Architecture job openings in NY Jobs List Data Warehouse Architect - 4145 Create date: 17-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/28/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 30-month project with our client in New York, NY that requires a Data Wareho.... (This job is for - Python Jobs in NY NewYork Architect - (in New York, NY)) C001043 ETL Developer/ Data Warehouse Architect -SPO Create date: 26-Dec-2017 Note : Email Or Paper submission Submission Deadline : 1/5/2018 Start Date : 2/15/2018 End Date : 11/14/2018 Client : Office of the State Comptroller ("OSC") Description : SERVICES A. Requirements The Consultant shall work with the Data Analytics Bureau and the Division of the Chief.... (This job is for - job Jobs in NY Albany Developer - (in Albany, NY)) (Architect: Data Warehouse Architecture, Collaborative Environment, Communication, Decision Making Documentation Snowflake in Menands, NY)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)