Snowflake Data Modelling Architect (Jobs in Albany, NY)   Requirement id 109648 Job title Architect Job location in Albany, NY Skills required SME In Business Systems, Business Process, Data Models, Snowflake Data Modelling Open Date 28-Aug-2020 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: SME In Business Systems, Business Process, Data Models, Snowflake Data Modelling start date:10/29/2020 End date:10/29/2021 submission deadline:9/4/2020 Agency Name: Department of Health/ITS Note: * Interview: Phone or video call Description: This Database Architect position is required to 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 in health care business intelligence reporting solutions. 48 Months Attended and participated in information and requirements gathering sessions, ensured that business requirements can be translated into data requirements. 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.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 109648 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),    SME In Business Systems job openings in other states Jobs List Product Owner - 74229 Create date: 21-Aug-2020 start date:9/7/2020 End date:12/01/2022 submission deadline:8/28/2020 client info : BOE Note: * local candidates interview in person, are preferred. Description: • Serve as subject matter expert (SME) in relevant product .... (This job is for - job Jobs in UT SaltLakeCity Consultant - (in Salt Lake City, UT))     (Architect: SME In Business Systems, Business Process, Data Models, Snowflake Data Modelling 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) TCL Consultant (Jobs in Jackson, Mississippi) Email Supervision Administrator (Jobs in Nashville, Tennessee) LMS MS Developer (Jobs in Durham, North Carolina) Communication Process Manager (Jobs in Lincoln, Nebraska) Healthcare Specialist (Jobs in Raleigh, North Carolina) Oracle Architect (Jobs in Madison, Wisconsin)