Senior Cloud Database Architect | Atlanta, GA

Detailed Information

  • Location: Atlanta, GA

  • Company: Idealforce

a qualified candidate to serve full-time, as a Senior Data Warehouse Cloud Modeler/Architect for the EASE project. Complete Description: The Client 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 Where Scape 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 warehouseWork with business stakeholders to understand reporting requirements and develop data models to support those requirementsCreate database scripts and power scripts including data definition language, database schemas, and roles, for all layers of the cloud data warehouseWork with other developers on extract, load and transform logicApplies and adapts data architecture principles, standards, concepts, practices and techniques as appropriate to specific use casesPerforms Data vault2 modeling and associated tasksDesigns and implements Validatar tests to ensure the integrity and quality of the data warehouseWrites and deploys code to all data warehouse environmentsCreate views to support business user requirementsDesigns and implements role-based security throughout the data warehouse Minimum QualificationsSeven years of data warehouse architect and/or modeling experienceThree years' experience working in a cloud environment, preferably in SnowflakeBS 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 QualificationsExperience developing in Wherescape RED and 3DExerience modeling using Data Vault 2 MethodologyExperience with quality assurance testingExperience in the public healthcare industry Desired Skills Leadershipo Results orientation, willingness to commit to a direction and drive operations to completiono Demonstrated ability to manage adversity and challenging situationso Ability to articulate vision of transformation effortso High personal and professional integrity Relationship Managemento Ability to develop cooperative and constructive relationshipso Ability to handle complaints, settle disputes, and resolve conflicts and negotiate with otherso Ability to collaborate with a teamo Ability to identify and understand the existing organizational cultureo Ability to build trust and cooperation amongst a team Oversight and Decision-makingo Highly developed skills in priority setting and aligning to a Departmental strategyo Ability to break down complex problems into manageable goals Technicalo High proficiency in SQL, R, Pythono Ability to use critical thinking to solve complex problems related to entity linking Required / Desired Skills Skill Required / Desired /Amount of Experience Design and develop data models, data warehouses, data marts Required 7Years Cloud-based enterprise data warehouse Required 4 Years Snowflake Required 5 Years Where Scape Data warehouse automation Required4Years Data Vault 2 methodology Highly desired 4 Years Develop, implement, and automate testing scripts using Validatar Required 5 Years Developing ETL logic Required 6 Years Developing in Wherescape RED and 3DRequired 5Years QA Testing Required 7 Years High proficiency in SQL, R, Python Required 7 Yearinteractionperience in the public healthcare industry Highly desired THIRD PRTY CANDIDATES: Email your candidate/s resume to jb dot resumes at along with the following details: Rate, Current location and Availability.

Disclaimer : The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed. PDN-9ad9c41e-4117-4815-b60f-e8008cafabf3

View Jobs by Category >>

Related Jobs