Senior Data Architect / Cloud Data Engineer (AWS & Snowflake)

Overview

Remote
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

Data Architect
Data Engineer
AWS
Snowflake
DWH/ Data warehousing
SQL
ETL/ ELT
Data Modeling
Python
Spark

Job Details

W2 Only, C2C is not accepting. 

Job Title: Senior Data Architect / Cloud Data Engineer (AWS & Snowflake)
Location: Onshore preferred; offshore candidates are acceptable if they can work flexible EST hours
Reports To: Information Systems Officer/Enterprise Architect
Essential Requirement: The candidate should be capable of covering for the client's Information Systems Officer/Enterprise Architect during their absence, taking ownership of architectural reviews, technical decision-making.

Role Overview

·         We are seeking a highly skilled Senior Data Architect / Cloud Data Architect to support enterprise data initiatives and serve as a key technical partner to the architecture team. decisions, perform solution reviews, and guide the design and in cloud-based data platforms.

·         The ideal candidate will have deep expertise in data warehousing, SQL, cloud data architecture (AWS and Snowflake), and a strong ability to balance hands-on engineering with high-level architectural thinking.

Key Responsibilities

·         Act as a technical right hand to the Enterprise Architect, supporting architecture reviews, design decisions, and strategic planning.

·         Design and implement scalable data warehouse and analytics solutions on AWS and Snowflake.

·         Develop and optimize SQL, ETL/ELT pipelines, and data models to support reporting and analytics.

·         Collaborate with cross-functional teams (data engineering, application development, infrastructure) to align on architecture best practices and ensure consistency across solutions.

·         Evaluate and recommend technologies, tools, and frameworks to improve data processing efficiency and reliability.

·         Provide guidance and mentorship to data engineering teams, enforcing data governance, quality, and security standards.

·         Troubleshoot complex data and performance issues and propose long-term architectural solutions.

·         Support capacity planning, cost optimization, and environment management within AWS/Snowflake ecosystems.

Required Skills and Experience

·         10+ years of experience in data engineering and architecture, with a strong focus on data warehouse design and optimization.

·         Expert-level proficiency in SQL and relational database design.

·         Hands-on experience with AWS cloud services (Redshift, S3, Glue, Lambda, etc.) and Snowflake.

·         Strong understanding of data modeling (star/snowflake schemas), ETL/ELT frameworks, and best practices for data integration.

·         Experience in designing data pipelines using Python, Spark, or similar technologies is a plus.

·         Excellent communication and documentation skills-able to translate technical concepts for business and technical audiences.

·         Ability to operate independently, make architectural decisions, and act as a trusted advisor on technology direction.

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.

About Pristine Resource