← Back to jobs

Shef Solutions Inc. Logo
Data Architect

Shef Solutions Inc.

 

San Diego, CA, USA

Posted On: 30+ days ago
Experience: 5+ years
Availability: Hybrid
Openings: 1
Category: Data Architect
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

You will design and implement enterprise-scale data architectures and integration frameworks.

Responsibilities

  • Design physical and logical enterprise data models and warehouse architectures.
  • Build data lake and warehouse structures using Inmon and Kimball methodologies.
  • Architect ETL pipelines to source, analyze, and load data from multiple application databases.
  • Define ETL layers including staging, recovery point, warehouse, and mart layers.
  • Develop incremental load strategies, mapping designs, error handling, and workflow schedules to meet SLAs.

Required Skills

  • 5+ years of experience in data architecture.
  • Expertise in Enterprise Data Modelling (Physical and Logical).
  • Experience with Normalized, Relational, and Dimensional databases and Star Schemas.
  • Advanced SQL proficiency.
  • Hands-on experience with Oracle and Snowflake.
  • Experience with Informatica PowerCenter or similar ETL tools.
  • Knowledge of ETL architecture, including workflow design and mapping.
  • Bachelor's degree or equivalent experience.

Preferred Skills

  • Experience with Tableau, IBM Cognos Suite, Power BI, Matillion, Alteryx, or Python.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs