Data Warehouse Architect

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

Git
Terraform
Ansible or Jenkins

Job Details

Data Warehouse Architect

Remote

12+ Months

  • Must have a minimum of eight (8) years of experience in dimensional modeling, data vault, and normalized/denormalized schema design with the ability to architect data models that translate business requirements into scalable technical solutions, developing documentation and architectural diagrams, and leading data projects from end-to-end.

  • Must have a minimum of eight (8) years of experience performing data partitioning, clustering, indexing, and query optimization techniques to enhance data warehouse performance

  • Must have a minimum of eight (8) years of experience integrating with BI platforms such as Power BI, Tableau, Looker or other similar products, and designing data marts or sematic layers for analytics

  • Must have a minimum of five (5) years of experience in designing and implementing scalable data warehouse solutions in Snowflake, Amazon Redshift, Google Big query, Azure Synapse, or similar.

  • Must have a minimum of five (5) years of experience in building and orchestrating data pipelines using dbt, Apache Airflow, Talend, Informatica, Azure Data Factory, Databricks or SSIS.

  • Must have a minimum of five (5) years of experience in big data ecosystems and distributed processing frameworks, utilizing Databricks or other Spark based tools, for handling large scale data transformation.

  • Must have a minimum of five (5) years of experience in data governance best practices including metadata management, data lineage, cataloging, RBAC, encryption, and regulatory compliance such as GDPR, HIPPA, SOC 2. Experience in one of the tools like Alation, Collibra, Azure Purview, Informatica Axon or Open Metadata.

  • Must have a minimum of five (5) years of experience in cloud infrastructure (e.g., IAM, VPC, Storage) and CI/CD practices, including tools such as Git, Terraform, Ansible or Jenkins

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.