Data Architect (Snowflake & AWS)- 10+ yrs - NYC, NY - Onsite
New York, NY, US • Posted 4 hours ago • Updated 4 hours agoContract Independent
Contract Corp To Corp
50% Travel Required
On-site
Depends on Experience
iMedhas Consulting Services
Fitment
Dice Job Match Score™
👾 Reticulating splines...
Job Details
Skills
- PostgreSQL
- Data Transformation
- Snowflake
- star schema
- CI/CD deployment
- data warehouse architecture
- Snowflake Schema
- Advanced SQL
- ETL/ELT Development
- AWS Native Services
- Git Version Control
- Dimensional Data Modeling
- Data Pipeline Orchestration
- PostgreSQL Data Ingestion
Summary
Job Title : Data Architect (Snowflake & AWS)
Location: New York, New York, United States
Skill Cluster : Data-Snowflake with AWS Native Services, ETL.
Client Interview : No
Study Level : Bachelor's Degree
Experience : 7 years
Primary Skill : Snowflake
Job Description :
Warehouse and analytics data infrastructure.
This role focuses on ingesting operational data from source systems (primarily PostgreSQL), transforming and modelling that data in the data warehouse (currently Snowflake), and preparing reporting-ready datasets and optimized queries for analytics and reporting services.
The engineer partners closely with product and software engineering teams to ensure data is reliable, performant, and easy to consume - whether through optimized SQL queries or analytics-friendly data models.
This role combines deep technical expertise in data engineering with ownership of data architecture, a version-controlled database codebase, and support for multiple environments.
Responsibilities:
-
Design, develop, and maintain a scalable data warehouse architecture to support analytics and reporting needs.
-
Build and manage data ingestion pipelines that move operational data (from PostgreSQL) into the data warehouse (Snowflake) with high reliability and data quality.
-
Transform and model raw data into reporting-friendly schemas (e.g., dimensional models, denormalized datasets, or analytics-optimized stakeholders to translate business requirements into scalable data solutions.
-
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 modelling, ingestion patterns, and warehouse optimization.
-
Participate in agile development processes, additional tasks within the department as assigned by management.
Qualifications:
-
4–8 years of prof data modeling concepts (e.g., dimensional modelling, star/snowflake schemas, reporting-optimized structures).
-
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 and ability
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91143549
- Position Id: 3524-31204-1825
- Posted 4 hours ago
Company Info
Welcome to iMedhas Consulting Services. We are an IT consulting and services enterprises with precision expertise in Digital Transformations, Big data and Analytics. Through our expert team, we provide greater adaptabilities to disseminate with new technologies to increase the overall productivity, operational efficiency, and productivity of a particular business process of an organization.
The goal is the achievement of higher customer satisfaction and providing lucrative returns on investment to the business. On the other hand, we deliver content management expertise, ERP (SAP) systems integration, EAI, and Information Management services.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs