← Back to jobs

Sspearhead Inc Logo
Data Warehouse Architect Lead Specialist

Sspearhead Inc

 

Durham, NC, USA

Posted On: 1 day ago
Experience: 12+ years
Availability: Hybrid
Openings: 1
Category: Data Warehouse Architect
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

You will lead the architecture, design, and implementation of enterprise data warehouse platforms.

Responsibilities

  • Translate business requirements into scalable data models, data pipelines, and analytical structures.
  • Build data architecture blueprints, conceptual/logical/physical data models, and documentation.
  • Oversee ETL/ELT pipeline development and performance tuning across data ingestion, transformation, and integration.
  • Design, implement, and optimize data storage strategies for structured, semi-structured, and unstructured data.
  • Mentor engineering teams, review solution designs, and provide guidance on technical decisions.

Required Skills

  • 12+ years of experience in data warehousing, data architecture, and enterprise data systems.
  • Strong expertise in data modeling (dimensional modeling, star schema, snowflake, normalization).
  • Hands-on experience with database platforms including Oracle, SQL Server, Teradata, DB2, or Netezza.
  • Proficiency in ETL/ELT tools such as Informatica, DataStage, Talend, SSIS, or Matillion.
  • Advanced SQL performance tuning and query optimization skills.
  • Experience with cloud data platforms such as AWS Redshift, Azure Synapse, Snowflake, or Google BigQuery.
  • Strong understanding of data governance, MDM, metadata, lineage, and data quality concepts.
  • Experience leading data architecture strategy and technical roadmap planning.

Preferred Skills

  • Experience with Kafka and Spark for real-time data streaming and processing.

Education

Bachelor's or Master's degrees

Related Jobs

No related jobs found

← Back to jobs