Data Warehouse Architect

Overview

On Site
USD0 - USD0
Contract - W2

Skills

Data
Warehouse
Architect
aws
data model
data govern

Job Details

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING!

Strategic Staffing Solutions is currently looking for a Data Warehouse Architect for a W2 contract opportunity with one of our largest clients!

Title: Data Warehouse Architect
Location: Denver, CO
Duration: 9 Months

Schedule: Hybrid

Top skills:


  • AWS native services and data architecture experience, experience with modern technology stacks, Databricks, and working with data lakehouse architectures desired.
  • Strong experience/knowledge in data modeling skills is required. An understanding of the creation of data products. Utilities Energy/gas, utility/communications phones, etc., would be helpful.
  • Min 8-10 years of experience.
  • Experience delivering artifacts and diagramming with architecture tooling.
  • Commensurate experience is more beneficial.
  • Experience with data movement connectors and/or platforms is nice to have; AWS experience is required, and knowledge of SAP and/or Salesforce data models and architecture is preferred.
  • Understanding technology options to understand what is best option is.

Non-technical skills:


  • No ego, humble approach
  • Great communication/documentation and diagramming skills.
  • Someone who is excited about learning and has solid AWS.
  • Work together. Self-motivated.

Position Overview:

What does a typical day look like?


  • Projects run from small enhancements from overall solutions design. Example Customer data grid sits in AWS Aurora/Relational database Core operational database, data from the CRM (Salesforce) and the billing system CRS. We also have the company s Energy Data Fabric that sits on a Databricks platform in AWS.
  • Solution architecture focused on data and data movement/access/visualization/integrations, then handed off to database engineers.


  • Works across hybrid cloud/on-premise databases, including SaaS solutions like Salesforce.
  • Assess how data should be modeled (changes to existing operational database to fit with new data elements/domains aligned with a Customer 360 view), how that data should be accessed (i.e., normalized databases might be great for storage but not always for quick real-time access).
  • Understand and be accountable in setting standards around the data governance and management of what data to access from where (understanding system of record, system of truth, aligning to standards to minimize replication of data, etc).

    Beware of scams. S3 never asks for money during its onboarding process.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Strategic Staffing Solutions