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.