Job
Title: Senior Data Warehouse Architect / Modeler
Location:
Remote
Duration: 2+ Years Contract
Job Description:
Job
Summary
·Under
minimal guidance, the Data Warehouse Modeler/Architect/Developer 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 and Kimbal methodologies.
·This
role will also develop, implement, and automate testing scripts. The Senior
Architect will also work closely with other EASE developers, testers, and
analysts.
·The
Senior Modeler/Architect will report to and receive strategic guidance from the
OAPI Executive Director, Technical Solutions Manager, EASE Project Manager, and
others.
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 Data Warehouse
Modeler/Architect/Developer 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 Vault 2 modeling and associated tasks
·Designs
and implements 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
·Develop
and implement "ELT" processes for populating data into ODS,
Data Vault, and Marts
·Responsible
for several "ELT" Jobs
·Debug
data quality issues and resolve as needed
·Collaborate
with Business Analysts to ensure data quality and implement Business Logic in
Data Mart.
·Other
tasks based on best practices
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 excess 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
·Experience
modeling using Data Vault 2 and Kimball
·Experience
with quality assurance testing
·Experience
in the public healthcare industry
Desired
Skills
Leadership
·Results
orientation, willingness to commit to a direction and drive operations to
completion
·Demonstrated
ability to manage adversity and challenging situations
·Ability
to articulate vision of transformation efforts
·High
personal and professional integrity
Relationship
Management
·Ability
to develop cooperative and constructive relationships
·Ability
to handle complaints, settle disputes, and 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 to a 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 to entity linking
Information
Locations RemotePosition Open to Anywhere in the US, but will work on-siteIndustry Information TechnologyStatus OpenJob Age 2 Day'sCreated Date 06/15/2026No.of Positions 1Duration 24 MonthsZip Code
