Job Description:

• 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 extracting, loading, and transforming logic.
• Applies and adapts data architecture principles, standards, concepts, practices, and techniques as appropriate in specific use cases.
• Performs Data vault2 modeling and associated tasks.
• Designs and implements Validator tests to ensure the integrity and quality of the data warehouse.
• Writes and deploys code tall data warehouse environments.
• Create views to support business user requirements.
• Designs and implements role-based security throughout the data warehouse.
• 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.
• Experience developing in WhereScape RED and 3D.
• Experience modeling using Data Vault 2 Methodology.
• Experience with quality assurance testing.
• Experience in the public healthcare industry.
• Skills: Leadership.
• Results orientation, willingness to commit to direction, and drive operations completion.
• Demonstrated ability to manage adversity and challenging situations.
• Ability to articulate a vision of transformation efforts.
• High personal and professional integrity.
• Relationship Management: Ability to develop cooperative and constructive relationships.
• Ability to handle complaints, settle disputes, resolve conflicts, and negotiate with others.
• Ability to collaborate with a team.
• Ability to identify and understand the existing organizational culture.
• Ability to build trust and cooperation amongst a team.
• Oversight and Decision-making. Highly developed skills in priority setting and aligning with Departmental strategy.
• Ability to break down complex problems into manageable goals.
• Technical: High proficiency in SQL, R, Python.
• Ability to use critical thinking to solve complex problems related entity entity-linking.