DCH Senior Cloud Database Architect

DCH is seeking a qualified candidate to serve full-time, as a Senior Data Warehouse Cloud Modeler/Architect for the EASE project.

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 skills in priority setting and aligning to a Departmental strategy
o Ability to break down complex problems into manageable goals

Technical
o High proficiency in SQL, R, Python
o Ability to use critical thinking to solve complex problems related to entity linking


Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceDesign and develop data models, data warehouses, data martsRequired7YearsCloud-based enterprise data warehouseRequired4YearsSnowflakeRequired5YearsWhereScape Data warehouse automationRequired4YearsData Vault 2 methodologyHighly desired4YearsDevelop, implement, and automate testing scripts using ValidatarRequired5YearsDeveloping ETL logicRequired6YearsDeveloping in Wherescape RED and 3DRequired5YearsQA TestingRequired7YearsHigh proficiency in SQL, R, PythonRequired7YearsExperience in the public healthcare industryHighly desired0
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidate's email address.Question3Candidate must be paid AT LEAST $92.00 if selected for engagement. Candidate can be paid more; however, the SRP rate cannot exceed $124.20. Do you accept this requirement?Question4The maximum mark-up for this engagement s SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%?Question5This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement?Question6The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client s selection date. Do you accept this requirement?Question7This hybrid work environment will require the candidate to work on-site several days per month. Do you and your candidate accept this requirement?Question8Candidates MUST be located in Georgia to start and continue this opportunity. Do you and your candidate accept this requirement?Question9NAME the city your candidate is located in.