Data Warehouse Architect

Raag Solutions; Lansing (MI); On-site; USD 110,000 - 160,000; Full time

Job summary

Raag Solutions is seeking a skilled data engineer to design and implement advanced extract–load pipelines into enterprise data lakes across AWS, Azure, or Google Cloud. You will transform datasets into reusable data products with lineage to source systems and enforce data-sharing policies to ensure proper access.

The role focuses on Lakehouse and Medallion architectures, using Python/PySpark, SQL, Parquet, and star-schema modeling, with exposure to Databricks or SageMaker,

Qualifications

• Bachelor degree in Computer Science, Data Science, or Information Systems.
• 4+ years building extract-and-load pipelines that ingest relational, semi-structured, and unstructured data into an enterprise data lake on AWS, Azure, or Google Cloud.
• 4+ years transforming cloud data lake datasets into data products with attributes traceable to critical data elements in source systems.
• 2+ years enforcing data-sharing policies so subscribers receive only the data product version they0re entitled to access.
• Technical focus on Lakehouse and Medallion architecture, Python/PySpark, SQL, Parquet, and star-schema modeling.

Skills

Python/PySpark

SQL

Parquet

Star-schema modeling

Education

Bachelors degree in Computer Science, Data Science, or Information Systems

Tools

Databricks

SageMaker

GitHub

Jenkins

Terraform

Job description

Bachelor’s degree. The detailed JD specifies Computer Science, Data Science, or Information Systems.

4+ years building extract-and-load pipelines that ingest relational, semi-structured, and unstructured data into an enterprise data lake on AWS, Azure, or Google Cloud.

4+ years transforming cloud data lake datasets into data products with attributes traceable to critical data elements in source systems.

2+ years enforcing data-sharing policies so subscribers receive only the data product version they’re entitled to access.

Technical focus Lakehouse and Medallion architecture, Python/PySpark, SQL, Parquet, and star-schema modeling. Preferred experience includes Databricks or SageMaker, GitHub/Jenkins/Terraform, and cloud governance tools that automate access controls at subscription.