Wednesday, October 11, 2023

Looking for Senior Cloud Database Architect - GC, USC only...

ROLE: Senior Cloud Database Architect

LOCATION: Only Locals to Georgia -- US Citizens and GC holders only. 

             

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.

 

 

Skill

Required / Desired

Amount

of Experience

Design and develop data models, data warehouses, data marts

Required

7

Years

Cloud-based enterprise data warehouse

Required

4

Years

Snowflake

Required

5

Years

WhereScape Data warehouse automation

Required

4

Years

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 3D

Required

5

Years

QA Testing

Required

7

Years

High proficiency in SQL, R, Python

Required

7

Years

Experience in the public healthcare industry

Highly desired

 

Thanks & Regards,

 

Chandu A

Chandu@Tekcombine.com

Suite #204

8405 Sterling Street,

Irving - Texas - 75063.

www.linkedin.com/in/sekhar-rao-51a512198

Hangouts: aforakkineni

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sureshotjobs/CA%2BRonb8N%3DcBmrqf4jMLPTKvDY8NRaxSwe7PsnfVysZj8e0vHVw%40mail.gmail.com.

No comments:

Post a Comment