Data Warehouse Architect: Lakehouse & Data Products

Tcognition, Inc.; City of Albany (NY); On-site; USD 120,000 - 172,000; Full time

Job summary

Tcognition, Inc. is seeking a Data Warehouse Architect Lead for Michigan's data initiatives. The role focuses on building and maintaining data pipelines, data lake hydration, and data product development with strong governance and security practices.

You will lead a team to design scalable data architectures, collaborate with cross-functional partners, and ensure delivery of trusted data assets for analytics and ML applications. Local Michigan on-site presence is required for critical hours.

Qualifications

• 4+ years hand-on experience in hydrating the enterprise Data Lake on a Cloud Service Provider (AWS, Azure, or Google) from relational, semi-structured and unstructured data sources by building Extract and Load Data Pipelines.
• 4+ years hands-on experience in Transforming datasets in a Data Lake on a Cloud Service Provider to deliver Data Products with traceability of attributes to the Critical Data Elements in the systems of record.
• 2+ years experience enforcing Data Sharing Policies to Data Products to ensure users access appropriate versions at subscription time.

Responsibilities

• Oversee the design, development, and maintenance of data pipelines for analytics and operational systems.
• Architect and optimize data infrastructure, including storage, orchestration frameworks, and ETL/ELT processes.
• Ensure data quality, reliability, and security with standards, monitoring, and governance practices.
• Lead and mentor data engineering staff, review designs/code, and support professional growth.
• Collaborate with data scientists, analysts, product teams, and stakeholders to meet organizational needs.

Skills

Data Warehouse

Cloud Services

AWS

Azure

Google Cloud

Data Lake

Data Pipelines

ETL

Data Transformation

Data Products

SQL

Python

R

Spark

Terraform Scripting

DAGs Scripting

YAML scripting

Docker

Education

Bachelor's Degree

Tools

Juniper Notebooks

NOSQL DB

Graph DB

Parquet DB

Lakehouse

Medallion Architecture

Kafka

Kubernetes

Glue

Databricks

Power BI

Tableau

Redshift Spectrum

Sagemaker

DBT

Datahub

SageMaker

GitHub

DevOps

Job description

Tcognition, Inc. is seeking a Data Warehouse Architect Lead for Michigan's data initiatives. The role focuses on building and maintaining data pipelines, data lake hydration, and data product development with strong governance and security practices.

You will lead a team to design scalable data architectures, collaborate with cross-functional partners, and ensure delivery of trusted data assets for analytics and ML applications. Local Michigan on-site presence is required for critical hours.