Snowflake Architect

Job Title: Snowflake Architect - Data Modeling

Location : Houston, Texas

Client: Confidential

Hybrid - 1 week in a month

Local in Houston or Texas - Preferred

Interview: 3 rounds

Need someone with very good Talend & Snowflake (Data modelling) experience.

Skillset :

Talend (Strong)

Snowflake ( data modeling)

Tableau or powerbi ( overall good analytics skiill as BI tool isn't finalized)

Financing report experience is good have

Requirements:

Proven experience as a Snowflake architect or data engineer with a focus on data

modeling.

In-depth knowledge of Snowflake architecture, SQL, and database design principles.

Hands-on experience with designing and optimizing ETL processes.

Strong analytical and problem-solving skills, with the ability to troubleshoot complex

issues.

Excellent communication and collaboration skills, with the ability to work effectively in a

cross-functional team environment.

Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent

work experience).

Snowflake certification (e.g., SnowPro Core) is a plus

Job Summary:

We are seeking an experienced Snowflake architect specializing in data modeling to join

our dynamic team. The ideal candidate will have a strong background in designing and

implementing data models within the Snowflake environment, ensuring efficient data

storage, retrieval, and analytics capabilities. This role requires deep technical expertise

in Snowflake architecture, SQL, and ETL processes, along with a proven ability to

collaborate with cross-functional teams to deliver scalable and reliable data solutions.

Responsibilities:

Data Modeling:

Design and implement scalable data models using Snowflake best practices.

Develop logical and physical data models based on business requirements.

Optimize data models for performance and efficiency, considering storage, retrieval, and

computational costs.

Ensure data integrity and consistency across databases and data warehouses.

Snowflake Architecture:

Architect and maintain Snowflake environments, including databases, schemas,

warehouses, and roles.

Implement Snowflake features such as clustering, partitioning, and materialized views to

enhance performance.

Configure and optimize Snowflake storage options and virtual warehouses based on

workload requirements.

Data Integration and ETL:

Collaborate with ETL developers to design and optimize data pipelines for ingesting and

transforming data into Snowflake.

Implement data integration strategies to ensure seamless data flows between systems

and platforms.

Monitor and troubleshoot ETL processes to ensure data quality and reliability.

Performance Tuning and Optimization:

Conduct performance tuning of SQL queries and data models to meet SLA requirements.

Implement indexing and caching strategies to improve query performance.

Monitor system performance metrics and recommend optimizations based on usage

patterns.

Collaboration and Documentation:

Work closely with data engineers, analysts, and stakeholders to understand data

requirements and deliver solutions.

Document data models, architecture designs, and configurations.

Provide technical guidance and mentorship to junior team members.