Snowflake Developing ETL Processes Wherescape Red SQL Architect (Jobs in Atlanta   Requirement id 143788 Job title Architect Job location in Atlanta, GA Skills required Data Warehouses, Data Models, Snowflake, Developing ETL Processes Wherescape Red Open Date 11-Oct-2023 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Data Warehouses, Data Models, Snowflake, Developing ETL Processes Wherescape Red Hybrid start date :10/23/2023 End date :10/16/2024 submission deadline :10/17/2023 client info :DCH Description : The Georgia Department of Community Health (DCH) is in the process of replacing its legacy data warehouse / decision support system (DW/DSS) with a modern cloud-based enterprise data warehouse and analytics solution to serve the entire department as part of its Enterprise Analytics Solution for Everyone (EASE) project. Job Summary Under minimal guidance, the Senior Cloud Modeler/Architect is responsible for designing and developing conceptual, logical and physical data models and implementing these models in Snowflake using WhereScape Data warehouse automation and Data Vault 2 methodologies. This role will also develop, implement, and automate testing scripts using Validatar. The Senior Cloud Modeler/Architect will also work closely with other EASE developers, testers, and analysts. The Senior Cloud Modeler/Architect will report to and receive strategic guidance from the OAPI Technical Solutions Manager and EASE Project Managers. Roles and Responsibilities The ideal candidate will design and develop the data models and data warehouse including the loading of data, Data vault and information marts. The ideal candidate will also be responsible for implementing and maintaining the architecture for the EASE solution. The Senior architect will, at minimum, perform the following: •Design and develop conceptual, logical, and physical data models for the cloud data warehouse •Work with business stakeholders to understand reporting requirements and develop data models to support those requirements •Create database scripts and power scripts including data definition language, database schemas, and roles, for all layers of the cloud data warehouse •Work with other developers on extract, load and transform logic •Applies and adapts data architecture principles, standards, concepts, practices and techniques as appropriate to specific use cases •Performs Data vault2 modeling and associated tasks •Designs and implements Validatar tests to ensure the integrity and quality of the data warehouse •Writes and deploys code to all data warehouse environments •Create views to support business user requirements •Designs and implements role-based security throughout the data warehouse Minimum Qualifications •Seven years of data warehouse architect and/or modeling experience •Three years experience working in a cloud environment, preferably in Snowflake •BS in Business Information Systems, Information Technology, Computer Science, or related field OR a combination of experience in access of ten years data warehouse experience with at least 3 years working in a cloud environment, preferably Snowflake Preferred Qualifications •Experience developing in Wherescape RED and 3D •Exerience modeling using Data Vault 2 Methodology •Experience with quality assurance testing •Experience in the public healthcare industry Desired Skills Leadership o Results orientation, willingness to commit to a direction and drive operations to completion o Demonstrated ability to manage adversity and challenging situations o Ability to articulate vision of transformation efforts o High personal and professional integrity Relationship Management o Ability to develop cooperative and constructive relationships o Ability to handle complaints, settle disputes, and resolve conflicts and negotiate with others o Ability to collaborate with a team o Ability to identify and understand the existing organizational culture o Ability to build trust and cooperation amongst a team Oversight and Decision-making o Highly developed ski   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 143788 while calling.   Other jobs in GA: Alpharetta (12), Atlanta (37), Conyers (2), Downtown Atlanta (1), Dublin (1), Duluth (5), Dunwoody (4), Lawrenceville (2), Norcross (4),    Data Warehouses job openings in other states Jobs List Data Designer - J-11-447-930 Create date: 13-Nov-2019 Description: Must Have: Experience with Guidewire Insurance Policy Administration Systems (PolicyCenter, ClaimsCenter, BillingCenter) Experience with traditional RDBMS databases and data warehouses. Experience with traditional RDBMS databases and data warehouses Experience performing data mappings, designing .... (This job is for - Guidewire Jobs in OH Dublin Designer - (in Dublin, OH)) Business Intelligence Administrator Create date: 29-Apr-2019 Note : **Must be US citizen or green card and can hire on after 6 months Description: A contract-to-hire opportunity is currently available in Columbus, Ohio for an experienced Business Intelligence Administrator who will provide technical support for enterprise BI platforms, tools and activities. The BI Administrator works collabora.... (This job is for - job Jobs in OH Columbus Administrator - (in Columbus, OH)) Data Architect - 42884 Create date: 30-Jan-2019 Candidate must be your W2 Employee Job Description : Apex Systems, the nations 2nd largest Information Technology Staffing organization, has an opening for a Data Architect to work within one of our large clients in the Des Moines, IA area. This 6+ month contract with the possibility of extension. SDLC Jobs in IA DesMoines Architect - (in Des Moines, IA)) Sr Data Analyst - 34249 Create date: 03-May-2018 Client Info :SurveyMonkey Candidate must be our W2 Employee Candidates RTR form should be only on the name of APEX Systems We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Job Description : Responsibilities Partner with cross-functional business and technical teams.... (This job is for - job Jobs in CA PaloAlto Analyst - (in Palo Alto, CA)) System Architect - J-11-028-286 Create date: 09-Jul-2015 NOTE : START DATE : 07/27/2015 END DATE : 10/23/2017 SUBMISSION DEADLINE : 07/15/2015 CLIENT INFO : COMSYS DESCRIPTION : ** THIS IS A LONG TERM PROJECT *** Senior Developer/Architect As Senior Developer and System Architect, work with onshore/offshore .... (This job is for - job Jobs in MA BOSTON Architect - (in Boston, MA))     (Architect: Data Warehouses, Data Models, Snowflake, Developing ETL Processes Wherescape Red in Atlanta, GA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)