Data Architect

About This Role

This role involves architecting, designing, and maintaining data warehouse and analytics infrastructure. The engineer will focus on ingesting, transforming, and modeling operational data to create reliable, performant, and consumable datasets for analytics and reporting services.

Responsibilities

• Design, develop, and maintain a scalable data warehouse architecture to support analytics and reporting needs
• Build and manage data ingestion pipelines from operational data sources (PostgreSQL) into the data warehouse (Snowflake) with high reliability and data quality
• Transform and model raw data into reporting-friendly schemas like dimensional models or denormalized datasets
• Partner with product and software engineering teams to ensure data is reliable, performant, and easy to consume
• Establish and promote data engineering best practices including naming conventions, documentation, testing, and performance optimization
• Monitor data pipelines and warehouse performance, proactively identifying and resolving data quality, latency, or scalability issues
• Contribute to architectural decisions around data modeling, ingestion patterns, and warehouse optimization
• Participate in agile development processes

Requirements

• 4-8 years of professional data modeling experience (dimensional modeling, star/snowflake schemas)
• Familiarity with ELT/ETL concepts, data pipelines, and orchestration practices
• Experience ingesting and transforming data from relational databases, particularly PostgreSQL
• Solid experience with Git-based version control for database code and data transformations
• Experience supporting multiple environments (development, staging, production) with controlled deployment processes
• Strong problem-solving skills

Qualifications

• 4-8 years of professional data modeling concepts

Skills

* Required skills